Search Results ar_batch_sources_all




Overview
Explore in AI Chat

Overview

The AR_BATCH_SOURCES_ALL table is a core setup table within Oracle E-Business Suite Receivables (AR). It serves as the master repository for defining and storing the configuration parameters for transaction batch sources. A batch source is a logical grouping mechanism that controls the accounting, bank account, and automatic numbering rules for transactions entered manually or imported via interfaces, such as AutoInvoice. Its primary role is to provide a consistent set of default values and validation rules for batches of transactions, ensuring proper posting to the general ledger and association with the correct bank accounts for cash application, particularly for receipts.

Key Information Stored

The table stores configuration details that govern batch processing. The primary identifier is BATCH_SOURCE_ID. Key columns include NAME and DESCRIPTION for the source. Critical setup columns define the accounting rules (e.g., REV_ACCT_CCID for the revenue account), the bank account linkage via REMIT_BANK_ACCT_USE_ID (a foreign key to CE_BANK_ACCT_USES_ALL), and numbering controls such as BATCH_SOURCE_TYPE (e.g., 'MANUAL', 'IMPORT'), and attributes for automatic batch and transaction numbering sequences. The ORG_ID column signifies the operating unit, making it a multi-org table. The STATUS column controls whether the batch source is active for use.

Common Use Cases and Queries

This table is central to transaction entry and reporting. A common use case is identifying the default revenue account or remittance bank for a set of invoices. For troubleshooting, one may query batch sources linked to a specific bank account. Standard reporting includes listing all active batch sources per operating unit. Sample queries include fetching setup details for a named source or joining to transaction tables for analysis.

  • Listing active batch sources: SELECT name, description, batch_source_type FROM ar_batch_sources_all WHERE status = 'A' AND org_id = :org_id;
  • Finding the default GL account for a source: SELECT bs.name, gcc.segment1 FROM ar_batch_sources_all bs, gl_code_combinations gcc WHERE bs.rev_acct_ccid = gcc.code_combination_id AND bs.batch_source_id = :id;

Related Objects

As a foundational setup table, AR_BATCH_SOURCES_ALL is referenced by numerous transaction processing and regional extension tables. The provided metadata confirms foreign key relationships from core tables like AR_BATCHES_ALL and AR_LOCKBOXES_ALL. Crucially, it is referenced by several Brazil (JL_BR) localization tables, including JL_BR_AR_BANK_RETURNS_ALL—the object from the user's original search—which links returned bank payments to their originating batch source. Other dependent objects include JL_BR_AR_COLLECTION_DOCS_ALL, FV_AR_BATCHES_ALL (for Federal Financials integration), and CE_BANK_ACCT_USES_ALL for the remittance bank account definition.