Performance Tuning
Tip 1 – Monitor Wait Times Oracle provides wait events that allow you to understand the total time a query spends in the database. Start your tuning efforts with the…
Read MorePO Interface Based on Project ,Task, Expenditure Type
PO interface based on project, Task, Expenditure type Staging.sql CREATE TABLE APPS.XX_NEW_PO ( ROWNUMBER NUMBER, SUPPLIER_NUMBER VARCHAR2(30 BYTE), SUPPLIER_SITE VARCHAR2(30 BYTE), SUPPLIER_NAME VARCHAR2(240 BYTE), PO_NUMBER VARCHAR2(30 BYTE), SHIP_TO_LOCATION…
Read MoreOPM Query to identify In Transit Transactions
OPM Query to identify In Transit Transactions Introduction: This blog shares the query to identify In Transit Transactions. Cause of the Issue: This blog shares the query to identify In…
Read MoreOPM Query to identify DCOGS Transactions
Introduction: This blog shares the query to identify DCOGS Transactions. Cause of the Issue: This blog shares the query to identify DCOGS Transactions. This would help in simplifying OPM Period…
Read MoreOAF Error – Unable to set binding parameter that does not exist
Introduction: This blog discusses on one of the causes for the issue “Unable to set binding parameter that does not exist ” Cause of the Issue: In OAF , our…
Read MoreOPM – Work in Process Report
OPM – Work in Process Report Introduction: This report will provide Work in Process items detail period wise. Cause of the issue: Every month needs to be run the lot…
Read MoreAutoinvoice Program Error correction Script on Duplicate Invoice Number
Header : Load data into oracle receivables transactions Usage of Heading : Useful to collect amount from customers that has been consumed through invoice number/Trx Number Description of post :…
Read MoreAutoinvoice Program Error correction Script on Offset Account and Revenue Account
please_complete_offset_account_ra_interface_lines_all Header : Load data into oracle receivables transactions Usage of Heading : Useful to collect amount from customers that has been consumed through invoice number/Trx Number Description of post…
Read MoreAutoinvoice Program Error correction Script on Rule Start date
Header : Load data into oracle receivables transactions Usage of Heading : Useful to collect amount from customers that has been consumed through invoice number/Trx Number Description of post :…
Read MoreOracle GL Transaction Register Report
Header : Outbound details from oracle general ledger Usage of Heading : Useful to get General ledger transaction details information data Description of post : This query is very useful…
Read More