Search Results ar_interim_cash_rcpt_lines_all
Overview
The AR_INTERIM_CASH_RCPT_LINES_ALL table is a temporary data store within Oracle E-Business Suite Receivables (AR). Its primary role is to support the QuickCash functionality, a feature designed for the rapid, high-volume application of customer payments. The table acts as a staging area, holding proposed payment application details before they are formally posted to the core Receivables tables. This interim storage allows for validation and processing logic to be executed efficiently before committing the final transactions, ensuring data integrity in the permanent AR_CASH_RECEIPT_HISTORY_ALL and AR_RECEIVABLE_APPLICATIONS_ALL tables.
Key Information Stored
The table stores line-level details for each payment application created via QuickCash. Its composite primary key, consisting of CASH_RECEIPT_ID and CASH_RECEIPT_LINE_ID, uniquely identifies each interim application line. Critical foreign key columns link the interim data to the core transactional entities of the Receivables module. These include PAYMENT_SCHEDULE_ID (linking to the invoice or charge being paid), CUSTOMER_TRX_ID (linking to the transaction header), and CUSTOMER_TRX_LINE_ID for line-specific applications. The table also references the interim receipt header (AR_INTERIM_CASH_RECEIPTS_ALL), the customer account (HZ_CUST_ACCOUNTS via SOLD_TO_CUSTOMER), and the associated receipt batch (AR_BATCHES_ALL via BATCH_ID). Columns typically store the applied amount, the type of application (e.g., to a transaction, on-account, or unapplied), and associated accounting information.
Common Use Cases and Queries
The primary use case is the investigation and troubleshooting of QuickCash payment runs that are in process or have encountered errors before final posting. Database administrators and functional consultants may query this table to validate data before submission or to diagnose issues where payments fail to apply. A common diagnostic query involves joining to related transactional tables to review pending applications for a specific batch or customer.
- Sample Query: To review all interim applications for a specific receipt batch, one might use:
SELECT ictl.cash_receipt_id, ictl.payment_schedule_id, ictl.amount_applied FROM ar_interim_cash_rcpt_lines_all ictl WHERE ictl.batch_id = <batch_id>; - Reporting Use Case: The table is not used for standard operational reporting, as its data is transient. Reports are instead generated from the permanent history tables (AR_CASH_RECEIPT_HISTORY_ALL) after the QuickCash process successfully completes and clears this interim table.
Related Objects
As indicated by its foreign keys, AR_INTERIM_CASH_RCPT_LINES_ALL has direct dependencies on several core AR and Trading Community Architecture (TCA) tables. It is a child table of AR_INTERIM_CASH_RECEIPTS_ALL. Its key relationships are for validating and posting applications: it references AR_PAYMENT_SCHEDULES_ALL (the invoice/charge to be paid), RA_CUSTOMER_TRX_ALL and RA_CUSTOMER_TRX_LINES_ALL (the transaction details), AR_BATCHES_ALL (the controlling batch), and HZ_CUST_ACCOUNTS (the customer). Data from this table is ultimately processed and transferred to permanent tables via internal AR posting programs, primarily populating AR_RECEIVABLE_APPLICATIONS_ALL for the application history and updating AR_PAYMENT_SCHEDULES_ALL for the remaining balance.
-
Table: AR_INTERIM_CASH_RCPT_LINES_ALL
12.2.2
owner:AR, object_type:TABLE, fnd_design_data:AR.AR_INTERIM_CASH_RCPT_LINES_ALL, object_name:AR_INTERIM_CASH_RCPT_LINES_ALL, status:VALID, product: AR - Receivables , description: Temporary table used to store QuickCash payment applications , implementation_dba_data: AR.AR_INTERIM_CASH_RCPT_LINES_ALL ,
-
Table: AR_INTERIM_CASH_RCPT_LINES_ALL
12.1.1
owner:AR, object_type:TABLE, fnd_design_data:AR.AR_INTERIM_CASH_RCPT_LINES_ALL, object_name:AR_INTERIM_CASH_RCPT_LINES_ALL, status:VALID, product: AR - Receivables , description: Temporary table used to store QuickCash payment applications , implementation_dba_data: AR.AR_INTERIM_CASH_RCPT_LINES_ALL ,
-
Table: AR_INTERIM_CASH_RECEIPTS_ALL
12.1.1
owner:AR, object_type:TABLE, fnd_design_data:AR.AR_INTERIM_CASH_RECEIPTS_ALL, object_name:AR_INTERIM_CASH_RECEIPTS_ALL, status:VALID, product: AR - Receivables , description: QuickCash payments processed by the PostBatch program , implementation_dba_data: AR.AR_INTERIM_CASH_RECEIPTS_ALL ,
-
Table: AR_BATCHES_ALL
12.2.2
owner:AR, object_type:TABLE, fnd_design_data:AR.AR_BATCHES_ALL, object_name:AR_BATCHES_ALL, status:VALID, product: AR - Receivables , description: Receipt batch information , implementation_dba_data: AR.AR_BATCHES_ALL ,
-
Table: AR_INTERIM_CASH_RECEIPTS_ALL
12.2.2
owner:AR, object_type:TABLE, fnd_design_data:AR.AR_INTERIM_CASH_RECEIPTS_ALL, object_name:AR_INTERIM_CASH_RECEIPTS_ALL, status:VALID, product: AR - Receivables , description: QuickCash payments processed by the PostBatch program , implementation_dba_data: AR.AR_INTERIM_CASH_RECEIPTS_ALL ,
-
Table: AR_BATCHES_ALL
12.1.1
owner:AR, object_type:TABLE, fnd_design_data:AR.AR_BATCHES_ALL, object_name:AR_BATCHES_ALL, status:VALID, product: AR - Receivables , description: Receipt batch information , implementation_dba_data: AR.AR_BATCHES_ALL ,
-
Table: AR_PAYMENT_SCHEDULES_ALL
12.2.2
owner:AR, object_type:TABLE, fnd_design_data:AR.AR_PAYMENT_SCHEDULES_ALL, object_name:AR_PAYMENT_SCHEDULES_ALL, status:VALID, product: AR - Receivables , description: All transactions except adjustments and miscellaneous cash receipts , implementation_dba_data: AR.AR_PAYMENT_SCHEDULES_ALL ,
-
Table: AR_PAYMENT_SCHEDULES_ALL
12.1.1
owner:AR, object_type:TABLE, fnd_design_data:AR.AR_PAYMENT_SCHEDULES_ALL, object_name:AR_PAYMENT_SCHEDULES_ALL, status:VALID, product: AR - Receivables , description: All transactions except adjustments and miscellaneous cash receipts , implementation_dba_data: AR.AR_PAYMENT_SCHEDULES_ALL ,
-
Table: RA_CUSTOMER_TRX_LINES_ALL
12.1.1
owner:AR, object_type:TABLE, fnd_design_data:AR.RA_CUSTOMER_TRX_LINES_ALL, object_name:RA_CUSTOMER_TRX_LINES_ALL, status:VALID, product: AR - Receivables , description: Invoice, debit memo, chargeback, credit memo and commitment lines , implementation_dba_data: AR.RA_CUSTOMER_TRX_LINES_ALL ,
-
Table: RA_CUSTOMER_TRX_LINES_ALL
12.2.2
owner:AR, object_type:TABLE, fnd_design_data:AR.RA_CUSTOMER_TRX_LINES_ALL, object_name:RA_CUSTOMER_TRX_LINES_ALL, status:VALID, product: AR - Receivables , description: Invoice, debit memo, chargeback, credit memo and commitment lines , implementation_dba_data: AR.RA_CUSTOMER_TRX_LINES_ALL ,
-
Table: RA_CUSTOMER_TRX_ALL
12.1.1
owner:AR, object_type:TABLE, fnd_design_data:AR.RA_CUSTOMER_TRX_ALL, object_name:RA_CUSTOMER_TRX_ALL, status:VALID, product: AR - Receivables , description: Header-level information about invoices, debit memos, chargebacks, commitments and credit memos , implementation_dba_data: AR.RA_CUSTOMER_TRX_ALL ,
-
Table: RA_CUSTOMER_TRX_ALL
12.2.2
owner:AR, object_type:TABLE, fnd_design_data:AR.RA_CUSTOMER_TRX_ALL, object_name:RA_CUSTOMER_TRX_ALL, status:VALID, product: AR - Receivables , description: Header-level information about invoices, debit memos, chargebacks, commitments and credit memos , implementation_dba_data: AR.RA_CUSTOMER_TRX_ALL ,
-
Table: HZ_CUST_ACCOUNTS
12.1.1
owner:AR, object_type:TABLE, fnd_design_data:AR.HZ_CUST_ACCOUNTS, object_name:HZ_CUST_ACCOUNTS, status:VALID, product: AR - Receivables , description: Stores information about customer accounts. , implementation_dba_data: AR.HZ_CUST_ACCOUNTS ,
-
Table: HZ_CUST_ACCOUNTS
12.2.2
owner:AR, object_type:TABLE, fnd_design_data:AR.HZ_CUST_ACCOUNTS, object_name:HZ_CUST_ACCOUNTS, status:VALID, product: AR - Receivables , description: Stores information about customer accounts. , implementation_dba_data: AR.HZ_CUST_ACCOUNTS ,