Introduction This Post illustrates steps required to Associative array in select statement as a normal database table in Oracle EBS R12. Step 1 First Create Associative Array Type TYPE assoc_array_type …
Read MoreIntroduction This Post illustrates steps required to Vendor Ledger Report Query in Oracle EBS R12. Script to Vendor Ledger Report Query. SELECT flag, vendor_num, vendor_name, vendor_site_id, vendor_site_code, state_code, project_code,…
Read MoreIntroduction This Post illustrates steps required to Oracle has provided an API to get the dynamic list of approvers for AME.ame_dynamic_approval_pkg.get_ame_apprs_and_ins_list.We need to pass the transaction type id and transaction…
Read MoreIntroduction This Post illustrates the steps required to retrieve GL Journal Import in Oracle EBS R12. Script to retrieve GL Journal Import SELECT glc.segment1 || ‘-‘ || apps.gl_flexfields_pkg.get_description_sql (glc.chart_of_accounts_id,…
Read MoreIntroduction This Post is about Active Users/Employee Details and their Active responsibilities find Query Script to Active Users/Employee Details and their Active responsibilities find Query. SELECT fu.user_name, PAPF.FIRST_NAME||PAPF.LAST_NAME Employee_Name,…
Read MoreIntroduction This Post illustrates steps required to Load JSON File to Oracle table in Oracle EBS R12. For Example : 1) Sample JSON:- { “department”: { “department_number”: 10, “department_name”: “ACCOUNTING”, “employees”:…
Read MoreIntroduction This Post is about to Map Member Functions For Multiset Operations in Oracle EBS R12.MAP member functions are special functions used to compare objects. The MAP member functions are used…
Read MoreIntroduction This Post illustrates the steps required for Auto Apply given receipts to Invoices Script to Auto Apply given receipts to invoices. CREATE OR REPLACE PACKAGE BODY APPS.XX_RECEIPT_APPLICATION_PKG IS PROCEDURE MAIN( errbuf …
Read MoreIntroduction: This Post illustrates the steps required to Sales Order Loader API from Blanket Sales Agreement in Oracle EBS R12 Script to Sales Order Loader API from Blanket Sales Agreement CREATE OR…
Read MoreIntroduction This Post is about to Check on hand Quantity For Specific Inventory Organization in Oracle EBS R12. Script to Check on hand Quantity for specific inventory Organization API…
Read More