Oracle Receivables

Oracle EBS R12 SQL to get AR and AGIS Invoices

The blog provides Oracle EBS R12 SQL to get AR and AGIS Invoices with consolidated and non consolidated batches based on the AGIS Batch Source Name , Org_id and Flex Value Set Name defined SELECT INTEF.ORG_ID, INTEF.INTERFACE_LINE_ID, INTEF.INTERFACE_LINE_ATTRIBUTE1 BATCH_ID, INTEF.INTERFACE_LINE_ATTRIBUTE2 TRX_ID, INTEF.INTERFACE_LINE_ATTRIBUTE3 LINE_ID, INTEF.INTERFACE_LINE_ATTRIBUTE4 BATCH_NUMBER, HEADERS.ATTRIBUTE1  ,   –trx_number in case of non-consolidated batches FDL.ATTRIBUTE1, — trx_number […]

Oracle EBS R12 AR Receipt Class and Receipt Method SQL

The blog provides Oracle EBS R12 SQL to get AR Receipt Class and Receipt Method SQL Please find below the SQL Query to retrieve the Receipt Class and Receipt Method setup in the system Navigation in front End: Receivables Manager -> Setup -> Receipts -> Receipt Classes Query to verify the setup from backend SELECT […]

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) CM_BALANCE_DUEFROMHZ_CUST_ACCOUNTS_ALL HZ_ACCT,HZ_CUST_ACCT_SITES_ALL HCASA,HZ_CUST_SITE_USES_ALL HCSU,HZ_PARTY_SITES HPS,HZ_LOCATIONS LOC,RA_CUSTOMER_TRX_ALL RCTA,RA_CUST_TRX_LINE_GL_DIST_ALL RA_CUS_TRX_GL_DIST,AR_PAYMENT_SCHEDULES_ALL AR_PAY_SCH,GL_CODE_COMBINATIONS CCWHERE 1=1AND AR_PAY_SCH.CUSTOMER_ID = HZ_ACCT.CUST_ACCOUNT_IDAND AR_PAY_SCH.CUST_TRX_TYPE_ID = RCTA.CUST_TRX_TYPE_IDAND HCASA.PARTY_SITE_ID = HPS.PARTY_SITE_IDAND LOC.LOCATION_ID = HPS.LOCATION_IDAND HZ_ACCT.CUST_ACCOUNT_ID = HCASA.CUST_ACCOUNT_IDAND HCASA.CUST_ACCT_SITE_ID = HCSU.CUST_ACCT_SITE_IDAND AR_PAY_SCH.CUSTOMER_ID = HCASA.CUST_ACCOUNT_IDAND AR_PAY_SCH.CUSTOMER_SITE_USE_ID = HCSU.SITE_USE_IDAND […]

Oracle EBS R12 SQL to get Open Invoices Customer Transaction Balances

The blog provides the Oracle EBS R12 SQL to check Customer Transaction Balances. The Oracle EBS R12 Account Receivable AR Invoices with Outstanding Customer Transaction Balances, AR Invoices which Over Due date are retrieved for AR Reconciliation The below given SQL Query provides the data extract to check Customer Transaction Balances SELECT HZ_ACCT.ACCOUNT_NUMBER, NVL (SUM […]

Scroll to top
Copy Protected by Chetan's WP-Copyprotect.