Sql Query to extract all the AR receipts applied to a particular AR invoice in Oracle cloud ERP
This query extracts all the AR receipts which are applied to a particular AR invoice in Oracle cloud ERP. This query is really helpful when doing root cause analysis for a particular AR invoice issue. We have included important columns like Receipt Date, AR invoice number and Receipt Bank account name.
Read MoreSql query to extract all AR invoices for a particular customer in oracle cloud ERP
This query extracts all the AR invoices for a particular customer in oracle cloud ERP. This helps in checking which invoices have been closed and which are still open for a particular customer.
Read MoreSQL query to extract all the open AR invoices for a particular BU in oracle cloud ERP
This query helps in extracting all the open AR invoices for a particular BU in oracle cloud ERP. This is extremely helpful in sending the extract to dunning softwares. SELECT apsa.TRX_NUMBER TRANSACTION_NUMBER , hou.NAME BU_NAME, CST.ACCOUNT_NUMBER CUSTOMER_NUMBER , hp.PARTY_NAME CUSTOMER_NAME , apsa.CLASS TRANSACTION_CLASS , rctta.NAME TRANSACTION_TYPE , rctta.DESCRIPTION TRANSACTION_TYPE_DESC, apsa.INVOICE_CURRENCY_CODE TRX_CURRENCY , apsa.AMOUNT_DUE_REMAINING AMOUNT_DUE_REMAINING, apsa.AMOUNT_DUE_ORIGINAL […]
Read MoreSql query to Extract all Open AR invoices for a particular Customer in Oracle cloud
This query helps in extracting all the Open AR invoices which are still open for a particular customer in oracle cloud ERP. This is particularly helpful in dunning operations when sending data to third parties which expect to send the dunning letters to customer for unpaid invoices from their end.
Read MoreQuery 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
Read MoreCommon Tables and their Purpose for Oracle Cloud Receivables
This post will list the tables needed to verify data and building reports for Oracle cloud Receivables. Table Name Purpose Primary Key Important columns Important Joins RA_CUSTOMER_TRX_ALL This table consists of header information for receivable invoices, debit memo and credit memo CUSTOMER_TRX_ID TRX_NUMBERTRX_DATECOMPLETE_FLAG RA_CUSTOMER_TRX_LINES_ALL This table consists of line information for receivable invoices, debit memo […]
Read More