Search Results ra_batch_sources_all

Overview

The RA_BATCH_SOURCES_ALL table is a core master data table within the Oracle E-Business Suite Receivables (AR) module, versions 12.1.1 and 12.2.2. It serves as the central repository for defining and managing the sources of transactional data, specifically invoices, credit memos, and commitments. Each record represents a distinct origin point or method for generating these transactions, such as "Manual," "Order Entry," "Project Billing," or "AutoInvoice." The table's multi-org structure, indicated by the "_ALL" suffix, allows it to store definitions specific to different operating units, enabling a shared service deployment model. Its primary role is to provide a controlled list of valid sources that are referenced throughout the transaction lifecycle, ensuring data integrity and enabling source-based processing rules and reporting.

Key Information Stored

The table's primary key is the BATCH_SOURCE_ID, a unique system-generated identifier. While the provided metadata does not list all columns, based on its function and common EBS patterns, the table typically stores descriptive and control information for each source. Key columns include NAME and DESCRIPTION for identifying the batch source, and the ORG_ID to segregate data by operating unit. Crucially, it holds configuration columns like DEFAULT_INV_TRX_TYPE, which links to the RA_CUST_TRX_TYPES_ALL table to define the default transaction type (e.g., Invoice, Credit Memo) for transactions created from this source. Other common attributes control status (enabled/disabled), automatic batch numbering, and default GL date rules, governing how transactions sourced from it are processed.

Common Use Cases and Queries

A primary use case is validating and reporting on the origin of transactions. For instance, to list all active batch sources for a specific operating unit, a query would filter on status and ORG_ID. When analyzing transactional data, reports frequently join RA_CUSTOMER_TRX_ALL to RA_BATCH_SOURCES_ALL on BATCH_SOURCE_ID to display the source name alongside invoice details. Implementation and support tasks often involve querying this table to verify setup, such as identifying the batch source linked to a specific transaction type for Order Management or Project Billing integration. A typical diagnostic query is:

SELECT bs.name, bs.description, tt.name default_trx_type
FROM ra_batch_sources_all bs,
ra_cust_trx_types_all tt
WHERE bs.default_inv_trx_type = tt.cust_trx_type_id
AND bs.org_id = :org_id
ORDER BY bs.name;

Related Objects

As documented in the foreign key metadata, RA_BATCH_SOURCES_ALL has extensive relationships with core and peripheral modules, underscoring its central role. Key documented relationships include:

• RA_CUSTOMER_TRX_ALL: Every transaction stores its originating BATCH_SOURCE_ID.
• RA_BATCHES_ALL: Batches are associated with a specific source.
• RA_CUST_TRX_TYPES_ALL: Linked via DEFAULT_INV_TRX_TYPE to define a default type.
• OE_TRANSACTION_TYPES_ALL: Referenced by INVOICE_SOURCE_ID for Order Management invoicing.
• AR_SYSTEM_PARAMETERS_ALL: Stores a system-wide LATE_CHARGE_BATCH_SOURCE_ID.
• PA_IMPLEMENTATIONS_ALL: Links to an INVOICE_BATCH_SOURCE_ID for Project Accounting.
• LNS_SYSTEM_OPTIONS_ALL: Referenced for Loans (LNS) module integration.
• Additional integrations exist with objects for India Localization (JAI_*) and other extensions (JG_ZZ_*).