Results for “receipt_reference_status”

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

Overview

The AR_CASH_REMIT_REFS_INTERIM table is an interim staging object in the Oracle Receivables (AR) module. It stores a subset of data drawn from AR_CASH_REMIT_REFS_ALL for a specific run of the Auto Cash Application Program (designated BETA in the source documentation). The table acts as a transient workspace during automated cash application processing, holding remittance reference records that the program matches against open receivables before committing results to the permanent base tables.

The ETRM metadata lists this object as VALID under the AR schema and identifies it as a standalone object. Its Data Vault classification—mined heuristically from foreign key structure—is satellite rather than hub or link, because it describes attributes of a processing event tied to parent entities (auto rule sets and transmissions) rather than establishing a new business key of its own. This classification should be treated as a modeling suggestion; the table's true role is operational staging.

Key Information Stored

The table contains 19 documented columns under Oracle EBS 12.2.2. The surrogate primary key is REMIT_REFERENCE_ID, defined by the constraint AR_CASH_REMIT_REFS_INTERIM_PK1. No alternate unique index or business-key candidate is documented, so REMIT_REFERENCE_ID is the only guaranteed unique identifier.

• REMIT_REFERENCE_ID — surrogate primary key for each interim remittance reference row.
• AUTOMATCH_SET_ID — foreign key to AR_CASH_AUTO_RULE_SETS, identifying the auto cash rule set driving the match.
• TRANSMISSION_ID — foreign key to AP_TRANSMISSIONS_SETUP, linking the row to the transmission configuration.
• CASH_RECEIPT_ID — the cash receipt being applied.
• CUSTOMER_ID, CUSTOMER_NUMBER — customer identifiers for the remittance.
• INVOICE_REFERENCE, INSTALLMENT_REFERENCE — references to the target invoice and installment.
• AMOUNT_APPLIED, AMOUNT_APPLIED_FROM — monetary values governing the application range.
• TRANS_TO_RECEIPT_RATE — conversion rate between transaction and receipt currency.
• BANK_ACCOUNT_NUMBER, TRANSIT_ROUTING_NUMBER — bank routing information carried from the remittance file.
• REFERENCE_SOURCE — source system or origin of the reference.
• MATCHING_REFERENCE_DATE — date used for matching logic.
• RECEIPT_REFERENCE_STATUS — processing status of the reference.

Common Use Cases and Queries

Because the table is regenerated per Auto Cash Application run, its principal use is diagnostics and reconciliation of that program. Typical queries include:

• Inspecting the interim rows produced by a specific rule set: SELECT * FROM AR_CASH_REMIT_REFS_INTERIM WHERE AUTOMATCH_SET_ID = :p_set_id;
• Locating unmatched or failed references: SELECT REMIT_REFERENCE_ID, INVOICE_REFERENCE, RECEIPT_REFERENCE_STATUS FROM AR_CASH_REMIT_REFS_INTERIM WHERE RECEIPT_REFERENCE_STATUS <> 'APPLIED';
• Comparing interim volume against the base table AR_CASH_REMIT_REFS_ALL to verify subset selection per run.
• Reconciling amounts applied versus receipt totals for a batch or transmission.

Related Objects

• AR_CASH_REMIT_REFS_ALL — permanent base table from which the interim subset is derived.
• AR_CASH_AUTO_RULE_SETS — joined via AUTOMATCH_SET_ID.
• AP_TRANSMISSIONS_SETUP — joined via TRANSMISSION_ID.
• AR_CASH_RECEIPTS — referenced through CASH_RECEIPT_ID for receipt validation.
• AR_CASH_RECEIPT_HISTORY — used alongside for application status tracking.
• Auto Cash Application / AutoMatch concurrent program — the primary consumer that populates and reads this table.