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 Tables | AR Receipt Table Description |
AR_CASH_RECEIPTS_ALL | The Receipt table stores receipt entry per record |
AR_CASH_RECEIPT_HISTORY_ALL | The Receipt table stores the AR Receipt History and AR Receipt status updates |
AR_MISC_CASH_DISTRIBUTIONS_ALL | The table stores the accounting entries for miscellaneous cash applications |
AR_DISTRIBUTIONS_ALL | The table stores the accounting distributions for cash receipts, miscellaneous receipts, adjustments, credit memo applications, cash receipt applications, and bills receivable transactions |
AR_RECEIVABLE_APPLICATIONS_ALL | The 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