EBS Technical

Query to get Bill Code details

Introduction:-This query will provide complete Bill Code and GL String details from Back end Code:- SELECT MSIB.SEGMENT1 Catalog_Item, MSIB.INVENTORY_ITEM_STATUS_CODE STATUS, MSIB.DESCRIPTION item_description,msib.PRIMARY_UNIT_OF_MEASURE UOM,IGC.SEGMENT5 “Account Segment”, (IGC.SEGMENT1||’.’||IGC.SEGMENT2||’.’||IGC.SEGMENT3||’.’||IGC.SEGMENT4||’.’||IGC.SEGMENT5||’.’||IGC.SEGMENT6||’.’||IGC.SEGMENT7||’.’||IGC.SEGMENT8||’.’||IGC.SEGMENT9)”GLC”, gl_flexfields_pkg.get_concat_description (igc.chart_of_accounts_id, igc.code_combination_id )”Code…

Read More

Query to get asset details in oracle apps r12

Introduction: This query will provide the complete asset details in oracle apps. We can use this query to develop the custom fixed assets reports in oracle apps and can extract…

Read More

SQL Query to get CVR rule details from Oracle EBS R12

Introduction: A cross-validation rule defines whether a value of a particular segment can be combined with specific values of other segments.The same details we can fetch using the below code.…

Read More

Create a new Request Group using API in Oracle apps

Introduction: Through the below script, we can create a new Request Group from back end. Script: BEGIN FND_PROGRAM.REQUEST_GROUP (REQUEST_GROUP => ‘System Administrator Reports’, APPLICATION => ‘CUSTOM’, CODE => ‘Run Collection…

Read More

Oracle Learning Management – Training History report

The sample query can be used to extract the Training history report for an employee in Oracle OLM(Learning Management) Query : Oracle Learning Management – Training History report SELECT full_name,…

Read More

Oracle PMS : Employee KRA (Objectives & competencies) report query

The below sample query can be used to extract the objectives , competencies for an employee in Oracle EBS PMS Query: KRA Report (Objectives & Competencies) for an person id,…

Read More

Employee Absence History Query – Oracle EBS

The below sample query can be used to extract the employee absence history in Oracle EBS. Query: Absence history for an person id, if person id is not given on…

Read More

How to delete the XML Publisher report templates and data definitions

XML Publisher report data definitions and data template definitions codes names are unique in nature, if you want to delete the defined templates and definitions you can use the below…

Read More

How to create Payroll Assignment Set using Oracle API

The sample script is used to create an assignment set using an API. You can create an assignment from the assignment set creation window in Oracle but you will not…

Read More

How to delete an element entries using Oracle API

There are scenarios where we are need to delete the element entries created. Here is sample script which can be used to delete(i.e purge, Date track delete mode as ‘ZAP’)…

Read More