Results for “ar_batches_all”

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

Overview

AR.AR_BATCHES_ALL is the core Receivables table that stores receipt batch information in Oracle E-Business Suite 12.1.1 and 12.2.2. It is the parent object for automatic and manual receipt batch processing, grouping individual cash receipts, interim cash receipts, adjustments, and related transactions under a single controlling batch record. The table is owned by the AR schema and carries the ORG_ID column, meaning it participates in multi-org (Operating Unit) security through the standard MOAC model. Each row represents one batch, defined by a name, a batch date, a source, a control count, and a control amount used to balance batch entry against actual entered receipts.

From a dimensional modeling perspective, the heuristic Data Vault classification mined from the foreign-key structure is satellite-leaning. This suggests modelling the table as a satellite attached to the receipt-batch hub rather than as an independent hub, since the majority of its attributes describe the descriptive context of a batch whose business identity is anchored by its primary and unique keys.

Key Information Stored

The table documents 62 columns. The following are the most operationally significant:

• BATCH_ID — Surrogate primary key (constraint AR_BATCHES_PK, unique index AR_BATCHES_U1). Not a business key; it is the value propagated to all child tables.
• NAME — User-visible batch name, part of the business identity together with BATCH_SOURCE_ID under unique key AR_BATCHES_UK2.
• BATCH_SOURCE_ID — Foreign key to AR_BATCH_SOURCES_ALL; determines the batch source, which controls numbering, receipt class, and remittance behavior.
• BATCH_DATE — Accounting and operational date assigned to the batch.
• GL_DATE — General Ledger date used when accounting entries are created for the batch.
• STATUS — Current batch state (for example open, submitted, or closed) governing whether further receipts may be added.
• CONTROL_COUNT and CONTROL_AMOUNT — Expected receipt count and total amount entered by the user for batch balancing.
• CURRENCY_CODE — Foreign key to FND_CURRENCIES; defines the batch currency.
• EXCHANGE_RATE_TYPE, EXCHANGE_DATE, and EXCHANGE_RATE — Currency conversion attributes used for foreign-currency batches.
• TYPE — Indicates the batch mechanism (for example manual, automatic, or lockbox).
• TRANSMISSION_REQUEST_ID — Foreign key to AR_TRANSMISSIONS_ALL; part of unique key AR_BATCHES_UK1 and links the batch to its remittance transmission.
• LOCKBOX_ID and LOCKBOX_BATCH_NAME — Link automatic lockbox receipts back to AR_LOCKBOXES_ALL.
• REMIT_BANK_ACCT_USE_ID — Foreign key to CE_BANK_ACCT_USES_ALL, identifying the remittance bank account used for deposit and risk assignment.
• RECEIPT_METHOD_ID and RECEIPT_CLASS_ID — Foreign keys to AR_RECEIPT_METHODS and AR_RECEIPT_CLASSES.
• SET_OF_BOOKS_ID — Identifies the ledger associated with the batch in the multi-ledger architecture.

Standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) and the fifteen ATTRIBUTE flex columns are also present for audit and descriptive flexibility.

Common Use Cases and Queries

Typical scenarios include batch reconciliation, lockbox transmission tracking, posting-status reporting, and audit of manual versus automatic batches. A common reconciliation query compares the control totals against the actual summed receipts joined through AR_CASH_RECEIPTS_ALL.BATCH_ID:

• Find all open batches for an operating unit: SELECT batch_id, name, batch_date, status, control_amount FROM ar_batches_all WHERE status = 'OPEN' AND org_id = :p_org_id;
• Compare control versus actual totals by joining AR_BATCHES_ALL to AR_CASH_RECEIPTS_ALL on BATCH_ID and aggregating AMOUNT.
• Trace a lockbox batch to its transmission using TRANSMISSION_REQUEST_ID joined to AR_TRANSMISSIONS_ALL.
• Report batches whose deposits are pending by filtering on DEPOSIT_DATE and STATUS.
• Cross-reference remittance batches on customer transactions through RA_CUSTOMER_TRX_ALL.REMITTANCE_BATCH_ID.

Related Objects

• AR_CASH_RECEIPTS_ALL — Child table via BATCH_ID; the confirmed cash receipts belonging to each batch.
• AR_INTERIM_CASH_RECEIPTS_ALL and AR_INTERIM_CASH_RCPT_LINES_ALL — Child tables via BATCH_ID; unposted receipts pending processing.
• AR_BATCH_SOURCES_ALL — Parent source definition referenced by BATCH_SOURCE_ID.
• AR_TRANSMISSIONS_ALL — Remittance transmission referenced by TRANSMISSION_REQUEST_ID.
• CE_BANK_ACCT_USES_ALL — Bank account use referenced by REMIT_BANK_ACCT_USE_ID.
• AR_LOCKBOXES_ALL — Lockbox definition referenced by LOCKBOX_ID.
• AR_ADJUSTMENTS_ALL and AR_AUTOREC_EXCEPTIONS — Child tables via BATCH_ID for adjustments and auto-receipt exceptions.
• RA_CUSTOMER_TRX_ALL — References this table via REMITTANCE_BATCH_ID.
• FV_AR_BATCHES_ALL — Federal financials extension table referencing BATCH_ID.
• AR_MC_BATCHES — Multi-currency companion table referencing BATCH_ID.