Search Results ar_interim_cash_receipts_all




Overview
Explore in AI Chat

Overview

The AR_INTERIM_CASH_RECEIPTS_ALL table is a core transactional table within Oracle E-Business Suite Receivables (AR), specifically for versions 12.1.1 and 12.2.2. It functions as a staging area for payments processed via the QuickCash feature. QuickCash is designed for high-volume, rapid application of cash receipts against customer transactions. The table temporarily holds receipt data after entry and before it is permanently posted and transferred to the main cash receipts tables (AR_CASH_RECEIPTS_ALL) by the concurrent PostBatch program. Its primary role is to ensure data integrity and manage the workflow for batch-oriented cash application processes.

Key Information Stored

The table stores the essential attributes of a QuickCash receipt pending final posting. Key columns, as indicated by its primary and unique keys, include CASH_RECEIPT_ID (the unique identifier), RECEIPT_NUMBER, BATCH_ID (linking to AR_BATCHES_ALL), and CUSTOMER_TRX_ID (linking to the invoice in RA_CUSTOMER_TRX_ALL). Other critical columns define the receipt's financial and relational context: PAY_FROM_CUSTOMER (customer identifier), AMOUNT, CURRENCY_CODE, and RECEIPT_METHOD_ID. The table also maintains references to banking details through columns like CUSTOMER_BANK_ACCOUNT_ID and REMIT_BANK_ACCT_USE_ID, linking to the IBY and AP banking structures.

Common Use Cases and Queries

The primary use case is troubleshooting and monitoring the status of QuickCash receipts within the posting workflow. Common queries involve identifying receipts stuck in an interim state or validating batch totals before final posting. For instance, to list all interim receipts within a specific batch for review, one might use:

  • SELECT receipt_number, amount, currency_code, pay_from_customer FROM ar_interim_cash_receipts_all WHERE batch_id = &batch_id;

Another typical scenario is reconciling the interim table against the source data to ensure all expected payments were captured before running the PostBatch program. Reporting use cases are generally operational and audit-focused, centering on the lifecycle of a QuickCash payment from entry to posting.

Related Objects

As defined by its foreign keys, AR_INTERIM_CASH_RECEIPTS_ALL has extensive relationships with other EBS entities. It is a direct parent to the AR_INTERIM_CASH_RCPT_LINES_ALL table, which holds the detailed application lines for each interim receipt. Major foreign key dependencies include AR_BATCHES_ALL (batch control), RA_CUSTOMER_TRX_ALL (transaction being paid), HZ_CUST_ACCOUNTS (customer), and AR_PAYMENT_SCHEDULES_ALL (payment schedule). Its integration with the banking model is through IBY_EXT_BANK_ACCOUNTS and AP_BANK_ACCOUNTS_ALL. The successful execution of the PostBatch program moves data from this interim table and its related lines into the permanent AR_CASH_RECEIPTS_ALL and AR_RECEIVABLE_APPLICATIONS_ALL structures.