Results for “term_rule”

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

Overview

RA_BATCH_SOURCES_ALL is an Oracle Receivables (AR) foundation table that defines batch sources — the user-defined document sources used when creating invoices, credit memos, debit memos, chargebacks, and commitments in Oracle E-Business Suite. A batch source acts as a template and classification for customer transactions: it controls default transaction types, automatic document numbering, defaulting rules for addresses, salespersons, and terms, and accounting behavior for entire batches. In Release 12.1.1 and 12.2.2 the table exists in the AR schema with 98 documented columns, and is exposed to the multi-org architecture through the ORG_ID column and the _ALL suffix, which indicates that batch sources are defined per operating unit.

From a Data Vault modeling perspective, the metadata's heuristic classification for this object is a hub. Because each row represents a distinct business entity with a surrogate primary key (BATCH_SOURCE_ID) and a pair of business-key unique indexes, it aligns well with a hub construct in a dimensional or Data Vault warehouse model built over EBS data.

Key Information Stored

The table's primary key is enforced by RA_BATCH_SOURCES_PK on BATCH_SOURCE_ID. Two unique indexes provide business-key candidates: RA_BATCH_SOURCES_U1 on (NAME, ORG_ID, ZD_EDITION_NAME) and RA_BATCH_SOURCES_U2 on (BATCH_SOURCE_ID, ORG_ID, ZD_EDITION_NAME), confirming that batch source names must be unique within an operating unit and edition.

The most significant columns include:

• BATCH_SOURCE_ID — surrogate primary key, referenced by many downstream tables as the batch source foreign key.
• NAME and DESCRIPTION — the user-facing batch source label and description.
• ORG_ID — the operating unit that owns the batch source.
• STATUS — activates or deactivates the source without deletion.
• BATCH_SOURCE_TYPE — the category of source (for example manual, imported, or programmatically generated).
• DEFAULT_INV_TRX_TYPE — foreign key to RA_CUST_TRX_TYPES_ALL, supplying the default transaction type for that source.
• LAST_BATCH_NUM — tracks the highest batch number used, supporting automatic batch numbering.
• AUTO_BATCH_NUMBERING_FLAG and AUTO_TRX_NUMBERING_FLAG — control automatic numbering of batches and transactions.
• START_DATE and END_DATE — the effective life of the batch source.
• Defaulting rule columns such as TERM_RULE, SALESPERSON_RULE, BILL_CUSTOMER_RULE, SHIP_CUSTOMER_RULE, INVENTORY_ITEM_RULE, and ACCOUNTING_RULE_RULE — determine how values are defaulted onto transaction lines.
• LEGAL_ENTITY_ID — foreign key to FV_LEGAL_ENTITIES linking the batch source to a legal entity.
• CREDIT_MEMO_BATCH_SOURCE_ID — associates credit memos with a related batch source.
• Oracle EBS standard audit and descriptive flexfield columns (CREATED_BY, LAST_UPDATED_BY, ATTRIBUTE1–15, GLOBAL_ATTRIBUTE1–20).

Common Use Cases and Queries

Developers and functional consultants query RA_BATCH_SOURCES_ALL to validate setup before AutoInvoice runs, to confirm which source is assigned to a given legal entity, or to audit automatic numbering. A sample query retrieving active sources with their default transaction types is:

• SELECT bs.batch_source_id, bs.name, bs.org_id, bs.default_inv_trx_type
• FROM ra_batch_sources_all bs
• WHERE bs.status = 'A' AND bs.org_id = :org_id;

A second common pattern joins to RA_BATCHES_ALL and RA_CUSTOMER_TRX_ALL to trace transaction volume back to its originating source:

• SELECT t.trx_number, b.name batch_source, bt.batch_name
• FROM ra_customer_trx_all t, ra_batch_sources_all b, ra_batches_all bt
• WHERE t.batch_source_id = b.batch_source_id
• AND t.batch_id = bt.batch_id;

Related Objects

RA_BATCH_SOURCES_ALL sits at the center of a well-connected set of AR and cross-module tables, based on documented foreign key relationships.

• RA_CUST_TRX_TYPES_ALL — referenced via DEFAULT_INV_TRX_TYPE, supplying the default transaction type.
• FV_LEGAL_ENTITIES — referenced via LEGAL_ENTITY_ID for legal entity reporting.
• RA_BATCHES_ALL — references this table on BATCH_SOURCE_ID, recording batches created under each source.
• RA_CUSTOMER_TRX_ALL — references BATCH_SOURCE_ID, tying individual transactions to their source.
• AR_SYSTEM_PARAMETERS_ALL — references LATE_CHARGE_BATCH_SOURCE_ID, defining the late charge source.
• OE_TRANSACTION_TYPES_ALL — references INVOICE_SOURCE_ID and NON_DELIVERY_INVOICE_SOURCE_ID for order invoicing.
• PA_IMPLEMENTATIONS_ALL — references INVOICE_BATCH_SOURCE_ID for project-related invoicing.
• LNS_SYSTEM_OPTIONS_ALL — references BATCH_SOURCE_ID for lease-related transactions.
• AR_TRANSACTIONS_REP_ITF — the AutoInvoice interface table, referencing BATCH_SOURCE_ID during import validation.