Results for “last_batch_num”

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

Overview

AR_BATCH_SOURCES_ALL is the Oracle Receivables (AR) setup and control table that defines batch sources — the configuration records that govern how receipt batches and, in some contexts, invoice and adjustment batches are created, numbered, and posted to accounting. It stores the accounting, bank account, and numbering information associated with a batch source, as described in the ETRM metadata. Each row represents a single batch source, and the table is the authoritative repository for numbering rules (automatic or manual), default remittance bank accounts, and default receipt attributes applied to transactions created under that source.

From a Data Vault modeling perspective, the metadata's heuristic classification suggests this table functions as a hub. This is consistent with its role: the primary key BATCH_SOURCE_ID is the durable business key that anchors dependent records across the Receivables data model, while descriptive and contextual columns behave as satellite-style attributes attached to that hub.

Key Information Stored

The surrogate primary key is BATCH_SOURCE_ID, defined through the AR_BATCH_SOURCES_PK constraint. A documented unique index, AR_BATCH_SOURCES_U1, spans BATCH_SOURCE_ID and ORG_ID, reflecting the multi-org partitioning of the table and serving as the business-key candidate. The ALL suffix confirms that rows are partitioned by operating unit through ORG_ID.

• NAME — the user-facing batch source name.
• TYPE — the batch source type (for example automatic, manual, or standard receipt batches).
• START_DATE_ACTIVE and END_DATE_ACTIVE — the effective date range during which the source is usable.
• AUTO_BATCH_NUMBERING — flag controlling whether batch numbers are generated automatically.
• LAST_BATCH_NUM — the last batch number allocated, used for sequential numbering.
• DEFAULT_REMIT_BANK_ACCOUNT_ID — the default remittance bank account applied to receipts.
• REMIT_BANK_ACCT_USE_ID — foreign key to CE_BANK_ACCT_USES_ALL linking the source to a specific bank account use.
• DEFAULT_RECEIPT_CLASS_ID and DEFAULT_RECEIPT_METHOD_ID — defaults for receipt classification and payment method.
• DESCRIPTION — free-text descriptive information.
• ORG_ID — operating unit identifier.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — the standard DFF (descriptive flexfield) columns for extensibility.

Standard audit columns such as CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN are also present.

Common Use Cases and Queries

Batch sources are referenced whenever receipts are entered, batched, or reported. Typical operational queries retrieve the numbering and default-accounting setup for a given source, or list active sources for an operating unit:

• Retrieve the last batch number and auto-numbering flag to control batch creation:
  SELECT batch_source_id, name, auto_batch_numbering, last_batch_num FROM ar_batch_sources_all WHERE org_id = :org AND name = :name;
• List all active batch sources effective on a given date:
  SELECT batch_source_id, name, type FROM ar_batch_sources_all WHERE org_id = :org AND TRUNC(SYSDATE) BETWEEN start_date_active AND NVL(end_date_active, SYSDATE);
• Resolve the default remittance bank account and receipt defaults for a source:
  SELECT default_remit_bank_account_id, default_receipt_class_id, default_receipt_method_id FROM ar_batch_sources_all WHERE batch_source_id = :id;
• Reporting on batch activity by joining to AR_BATCHES_ALL and aggregating on source.

These queries support receipt processing configuration, bank reconciliation setup, and audit reports validating that batches were created against active, correctly numbered sources.

Related Objects

The table participates in a rich dependency network. The most significant related objects are:

• AR_BATCHES_ALL — references AR_BATCH_SOURCES_ALL.BATCH_SOURCE_ID; the primary transactional batch table.
• AR_LOCKBOXES_ALL — lockbox definitions linked via BATCH_SOURCE_ID.
• FV_AR_BATCHES_ALL — Federal (FV) batch records sharing the same source key.
• CE_BANK_ACCT_USES_ALL — referenced through REMIT_BANK_ACCT_USE_ID, supplying bank account use details.
• Brazilian localizations: JL_BR_AR_BANK_RETURNS_ALL, JL_BR_AR_COLLECTION_DOCS_ALL, JL_BR_AR_PAY_SCHED_AUX, JL_BR_AR_REC_MET_ACCTS_EXT_ALL, and JL_BR_AR_SELECT_ACCOUNTS_ALL — all reference BATCH_SOURCE_ID.

Together these relationships place AR_BATCH_SOURCES_ALL at the center of Receivables batch configuration, feeding both standard and localization-specific processing.