The below given SQL Query will retrieve the set of data for AP and AGIS Invoices with consolidated and non
Category: Oracle Receivables
Query to get AR and AGIS Invoices
The below given SQL Query will retrieve the set of data for AR and AGIS Invoices with consolidated and non
Query to get AGIS – Intercompany Matched or unmatched Balances for a particular Account level details
Please find below the SQL Query to identify the Intercompany Balances for a particular Account whether they have been MATCHED
Query to get the Receipt Class and Receipt Method setup in the system
Please find below the SQL Query to retrieve the Receipt Class and Receipt Method setup in the system Navigation in
Oracle apps R12 Query to get the Credit Memo Balance Due
The below given query provides the SQL Data extract for Credit Memo Balance Due. SELECT HZ_ACCT.ACCOUNT_NUMBER, NVL (SUM (AR_PAY_SCH.AMOUNT_DUE_REMAINING), 0)
Oracle apps R12 Query to check Customer Transaction Balances
The below given SQL Query provides the data extract to check Customer Transaction Balances SELECT HZ_ACCT.ACCOUNT_NUMBER, NVL (SUM (AR_PAY_SCH.AMOUNT_DUE_REMAINING), 0)
AR SQL Query to get Open Invoices where Customer payment status is Open
Hi All, The below given SQL Query for Oracle Apps Receivables (AR) provides the main columns from the table –
Oracle Receivables – AR Setup Checklist that requires for transaction processing
The below given are the common AR setup to be done in Oracle Apps – Oracle Receivables for the transaction
AR Invoice query to get transactions posted to GL
Hi All, Please find below the Query to identify if transactions has been posted to GL. This will be helpful