Results for “ar_interim_posting”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

AR_INTERIM_POSTING is a Receivables (AR) module table in the Oracle E-Business Suite 12.1.1 and 12.2.2 schemas that supports posting to the General Ledger when Cash Basis accounting is enabled. Under cash basis accounting, revenue recognition is deferred until cash is actually received against a transaction. When a receipt is applied, the Receivables engine must create accounting entries that reverse or recognize the previously deferred revenue amounts. AR_INTERIM_POSTING serves as a staging mechanism for that cash-basis posting activity, holding receipt-and-application detail before final accounting is transferred to subledger and general ledger tables.

The table is owned by the AR schema and carries an ETRM status of VALID with a documented physical schema of 9 columns. ETRM's heuristic Data Vault classification, mined from the foreign key structure, identifies this object as standalone — meaning it does not present clear parent-child foreign key relationships that would map it to a hub or link construct. From a modeling perspective, this classification suggests AR_INTERIM_POSTING behaves less like a conformed hub (a core business entity) and more like a transient or staging construct tied to the posting flow. Where such staging tables have no enforced outbound FKs, modeling them as a raw staging satellite or transient mart, rather than a durable hub or link, is a common approach.

Key Information Stored

The table is uniquely identified by the primary key AR_INTERIM_POSTING_PK, which comprises the CASH_RECEIPT_ID column. A second unique index, AR_INTERIM_POSTING_U1 (an alternate business-key candidate), is also defined on CASH_RECEIPT_ID, confirming that the receipt identifier is the governing business key for records in this table. Among the documented columns, the following are most significant:

• CASH_RECEIPT_ID — The primary key of the table and the link to the source cash receipt; the unique business-key candidate.
• BATCH_SOURCE — Identifies the batch source of the posting activity, providing context for how the receipt was created.
• BATCH_NAME — The name of the batch associated with the receipt posting.
• RECEIPT_NUMBER — The human-readable receipt number for operational reporting and reconciliation.
• RECEIPT_DATE — The date the receipt was entered or applied, critical for period determination.
• RECEIPT_AMOUNT — The monetary amount of the receipt relevant to cash-basis recognition.
• TRX_NUMBER — The transaction number of the invoice or debit memo against which the receipt was applied.
• LINE_NUMBER — The transaction line reference for the applied amount.
• AMOUNT_APPLIED — The portion of the receipt applied to the transaction, which drives the cash-basis posting amount.

Common Use Cases and Queries

AR_INTERIM_POSTING is typically queried during cash-basis accounting reconciliation and posting diagnostics. A common pattern joins it to AR_CASH_RECEIPTS on CASH_RECEIPT_ID to retrieve receipt detail, and to AR_PAYMENT_SCHEDULES or AR_RECEIVABLE_APPLICATIONS to confirm the application amounts. A representative query:

SELECT aip.CASH_RECEIPT_ID, aip.RECEIPT_NUMBER, aip.RECEIPT_DATE, aip.RECEIPT_AMOUNT, aip.TRX_NUMBER, aip.AMOUNT_APPLIED FROM AR.AR_INTERIM_POSTING aip WHERE aip.RECEIPT_DATE BETWEEN :from_date AND :to_date;

Typical reporting uses include verifying that applied receipts were picked up for cash-basis posting, troubleshooting out-of-balance posting runs, and auditing unposted interim records at period close. Because the table is narrow (9 columns), it is inexpensive to scan for completeness checks against the AR subledger accounting entries.

Related Objects

The following objects are most relevant to AR_INTERIM_POSTING based on its key structure and functional role:

• AR_CASH_RECEIPTS — joined on CASH_RECEIPT_ID; the primary source receipt record.
• AR_CASH_RECEIPT_HISTORY — receipt lifecycle status history, joined on CASH_RECEIPT_ID.
• AR_RECEIVABLE_APPLICATIONS — application detail tied to receipts and transactions; corroborates AMOUNT_APPLIED.
• AR_PAYMENT_SCHEDULES — installment and applied-amount data linked through CASH_RECEIPT_ID.
• RA_CUSTOMER_TRX_ALL / RA_CUSTOMER_TRX_LINES_ALL — transaction header and line sources referenced by TRX_NUMBER and LINE_NUMBER.
• AR_XLA_CASH_RECEIPT_LINES — subledger accounting lines for cash receipts, used downstream of interim posting.
• AR_INTERIM_CASH_RECEIPTS_ALL — companion interim posting structure in the AR cash receipt flow.