Results for “batch”

50+ results




Overview
Explore in AI Chat

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:

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.