Introduction This Post illustrates the steps required to GL Transactions for AR Adjustments in Oracle EBS R12. Script to GL Transactions for AR Adjustments. SELECT NULL trans_type, ent.transaction_number invoice_num,…
Read MoreIntroduction This Post is about to GL Transactions for AR in Oracle EBS R12. Script used for GL Transactions for AR. SELECT rctt.description trans_type, TO_CHAR (rct.trx_number) invoice_num, TO_CHAR (rct.trx_date)…
Read MoreIntroduction 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 the steps required to finding MTD/YTD/ITD Cost/Revenue and Fee Details for a Project in PA Module Oracle EBS R12. Script to finding MTD/YTD/ITD Cost/Revenue and…
Read MoreIntroduction This Post illustrates steps required to Calling One Form from another Form using Personalization in Oracle EBS R12. Open the main form you want to personalize and go…
Read MoreInroduction This Post is about File moving and renaming using unix shell script in Oracle EBS R12. #!/bin/bash ####################################################################### # File_Name : imauanzstmtfilearchv.prog …
Read MoreIntroduction 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 More