-
Query to get all Applied Receipts created for a particular Customer/Account in Oracle Receivables
This query gives you all the applied receipts for a particular customer account. It can also be filtered on the date range based on Receipt Date
-
Query to Extract Oracle Payments Formatted Xml file from Oracle Cloud ERP Database
The below query can help extract the Oracle Payments xml file which is processed by Oracle cloud ERP Payments module. This query extracts the formatted xml which is sent to the bank. This can greatly help in Debugging Payment issues: SELECT * FROM iby_trxn_documents itd WHERE itd.payment_instruction_id IN (SELECT payment_instruction_id …
-
Query to Extract Oracle Payments Source Xml file from Oracle Cloud ERP Database
The below query can help extract the Oracle Payments xml file which is processed by Oracle cloud ERP Payments module. This query extracts the source xml. This can greatly help in Debugging Payment issues: SELECT * FROM iby_trxn_documents itd WHERE itd.payment_instruction_id IN (SELECT payment_instruction_id …