Query to find open invoices with the Supplier and PO details
Introduction This Post is about Query to find open invoices with the Supplier and PO details in Oracle EBS R12. Script to find open invoices with the Supplier and…
Read MoreQuery to get the Menu and Submenu list against a responsibility in oracle apps
Introduction This Post illustrates the steps required to get the Menu and Submenu list against a responsibility in Oracle EBS R12. Script t0 get the Menu and Submenu list against a…
Read MoreERROR ORA -00980 Synonym Translation no longer valid
Introduction This Post is about to ORA -00980 Synonym Translation no longer valid Error in Oracle EBS R12. Error Message : ORA -00980 Synonym Translation no longer Valid. Error…
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 More