Introduction 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 MoreQuery to get employee details who are not submitted the iExpense details for approval Introduction This post is about to get employee details who are not submitted the iExpense…
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 MoreBelow is a Sample Formula showing How to Call a Fast Formula from another Formula : DEFAULT FOR ASG_HR_ASG_ID is 0 DEFAULT FOR PAY_EARN_PERIOD_END is ‘4712/12/31 00:00:00’ (date) SET_INPUT(‘HR_ASSIGNMENT_ID’,ASG_HR_ASG_ID) v_asg_id =…
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 More