GL Transactions for AR
Introduction 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 MoreHow to Use Associative array in select statement as a normal database table
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 MoreQuery for finding MTD/YTD/ITD Cost/Revenue and Fee Details for a Project in PA Module
Introduction 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 MoreZooming: Calling One Form from another Form using Personalization
Introduction 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 MoreFile Moving and renaming using UNIX SHELL Script in EBS
Inroduction This Post is about File moving and renaming using unix shell script in Oracle EBS R12. #!/bin/bash ####################################################################### # File_Name : imauanzstmtfilearchv.prog …
Read MoreHow to Use Associative array in select statement as a normal database table
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 MoreVendor Ledger Report Query
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 MoreDynamic Approver List for AME
Introduction 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 MoreQuery to retrieve GL Journal Import
Introduction 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 MoreOracle EBS Active Users/Employee Details and their Active responsibilities find Query
Introduction 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 More