Untitled
Introduction This Post is used for GL Transactions for AP in Oracle EBS R12. Script used for GL Transactions for AP. SELECT /*+ leading (ael aeh) */ aia.invoice_type_lookup_code trans_type,…
Read MoreGL Transactions for AR Adjustments
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 MoreGL 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 More