Oracle Receivables R12 AR Receipts SQL Queries

The blog provides the commonly used SQL Queries to reconcile the Oracle Receivables R12 AR Receipts to get accounted AR Receipts with GL Code Combinations, AR Payments received through checks , AR Receipts processing details, etc.

Oracle AR Receipts Tables

The below given are the Oracle AR Receipts tables in Oracle Receivables R12

Oracle AR R12 Receipts TablesAR Receipt Table Description
AR_CASH_RECEIPTS_ALLThe Receipt table stores receipt entry per record
AR_CASH_RECEIPT_HISTORY_ALLThe Receipt table stores the AR Receipt History and AR Receipt status updates
AR_MISC_CASH_DISTRIBUTIONS_ALLThe table stores the accounting entries for miscellaneous cash applications
AR_DISTRIBUTIONS_ALLThe table stores the accounting distributions for cash receipts, miscellaneous receipts, adjustments, credit memo applications, cash receipt applications, and bills receivable transactions
AR_RECEIVABLE_APPLICATIONS_ALLThe table stores the accounting entries for cash and credit memo applications

Oracle Receivables R12 SQL Query to retrieve AR Receipts accounted with GL Code Combinations

The Oracle Receivables R12 SQL Query uses table mappings for AR_DISTRIBUTIONS_ALL , GL_CODE_COMBINATIONS, AR_CASH_RECEIPT_HISTORY_ALL and AR_CASH_RECEIPT_ALL to retrieve AR Receipts with GL Code Combinations from GL Table

Oracle Receivables R12 SQL Query to retrieve AR Receipts Payment Schedule Details

The Oracle Receivables R12 SQL Query uses table mappings for AR_PAYMENT_SCHEDULES_ALL , AR_CUSTOMERS, AR_CASH_RECEIPT_ALL, HZ_CUST_SITE_USES_ALL, HZ_CUST_ACCT_SITES_ALL, HZ_PARTY_SITES to retrieve AR Receipts Payment Schedule details based on ORG_ID input

Oracle Receivables R12 SQL Query to retrieve AR Receipts Processing Details

Oracle Receivables R12 SQL Query to retrieve AR Receipts Accounted

Oracle Receivables R12 SQL Query to retrieve AR Payments Received Through Checks

Oracle Receivables R12 AR Receipts SQL Queries
Scroll to top