Results for “fv_ar_batches_all”

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

Overview

FV_AR_BATCHES_ALL is a Federal Financials (FV) module table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores receipt batch header information to be processed by the Apply Cash Receipt process. It functions as the FV-owned staging and control table for grouping accounts receivable receipts into batches prior to application, providing the header-level attributes such as batch amount, batch count, currency, receipt method, receipt class, and bank account context that govern downstream cash application and treasury reconciliation.

From a Data Vault modeling perspective, the heuristic classification derived from the foreign key structure suggests this object behaves as a link, since it primarily associates business entities — batch sources, receipt classes, receipt methods, bank accounts, and sets of books — rather than serving as a pure descriptive hub or satellite. This classification is a modeling suggestion only; the table is implemented as a standard Oracle EBS transactional entity with a surrogate primary key.

Key Information Stored

The table contains 41 documented columns. Its surrogate primary key is BATCH_ID, enforced through the unique index FV_AR_BATCHES_ALL_U1 and the constraint FV_AR_BATCHES_PK. The most significant columns include:

• BATCH_ID — surrogate primary key and the sole documented unique business-key candidate; the join column to AR_BATCHES_ALL.
• BATCH_NAME — user-facing identifier for the receipt batch.
• BATCH_AMOUNT and BATCH_COUNT — control totals for the monetary value and number of receipts in the batch.
• CURRENCY_CODE — currency in which the batch is denominated.
• GL_DATE and DEPOSIT_DATE — accounting date and bank deposit date.
• RECEIPT_METHOD_ID and RECEIPT_CLASS_ID — foreign keys to AR_RECEIPT_METHODS and AR_RECEIPT_CLASSES, defining how and in what class receipts are processed.
• BATCH_SOURCE_ID — foreign key to AR_BATCH_SOURCES_ALL, indicating the origin of the batch.
• BANK_ACCOUNT_ID, CE_BANK_ACCOUNT_ID, and CE_BANK_ACCT_USE_ID — bank account references spanning AP_BANK_ACCOUNTS_ALL, CE_BANK_ACCOUNTS, and CE_BANK_ACCT_USES_ALL.
• SET_OF_BOOKS_ID — foreign key to GL_SETS_OF_BOOKS_11I, anchoring the batch to a ledger.
• TRANSFER_STATUS — indicates the processing state of the batch.
• ORG_ID — multi-org operating unit discriminator.
• USSGL_TRANSACTION_CODE — federal-specific transaction code supporting USSGL reporting.
• EXCHANGE_RATE_TYPE, EXCHANGE_DATE, and EXCHANGE_RATE — currency conversion attributes for foreign-currency batches.

Standard EBS audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) and fifteen ATTRIBUTE flex columns are also present.

Common Use Cases and Queries

Typical scenarios include reconciling receipt batches awaiting application, auditing batch control totals against applied receipts, and reporting on federal USSGL transaction code usage. A representative query joins the batch header to its receipt method and class:

• Batch status monitoring: SELECT b.batch_name, b.batch_amount, b.batch_count, b.transfer_status FROM fv.fv_ar_batches_all b WHERE b.org_id = :org_id AND b.transfer_status = 'U';
• Batch-to-source analysis: SELECT b.batch_name, s.name source_name, b.deposit_date FROM fv.fv_ar_batches_all b JOIN ar.ar_batch_sources_all s ON s.batch_source_id = b.batch_source_id;
• Ledger and bank reconciliation: joining to GL_SETS_OF_BOOKS_11I and CE_BANK_ACCOUNTS to validate batch accounting and treasury alignment.
• Foreign-currency conversion reporting using EXCHANGE_RATE_TYPE and EXCHANGE_RATE.

Related Objects

The following referenced tables are the most significant dependencies, with join columns as documented:

• AR_BATCHES_ALL — joined on BATCH_ID; the base Accounts Receivable batch header.
• AR_BATCH_SOURCES_ALL — joined on BATCH_SOURCE_ID.
• AR_RECEIPT_CLASSES — joined on RECEIPT_CLASS_ID.
• AR_RECEIPT_METHODS — joined on RECEIPT_METHOD_ID.
• AP_BANK_ACCOUNTS_ALL — joined on BANK_ACCOUNT_ID.
• GL_SETS_OF_BOOKS_11I — joined on SET_OF_BOOKS_ID.
• CE_BANK_ACCOUNTS — joined on CE_BANK_ACCOUNT_ID.
• CE_BANK_ACCT_USES_ALL — joined on CE_BANK_ACCT_USE_ID.

These relationships position FV_AR_BATCHES_ALL at the intersection of receivables, payables banking, treasury, and general ledger data, making it a central integration point for Federal Financials cash receipt processing.