Search Results ar_ai_batch_source_v

Overview

AR_AI_BATCH_SOURCE_V is a PL/SQL view owned by the APPS schema in Oracle E-Business Suite Releases 12.1.1 and 12.2.2. It belongs to the Oracle Receivables (AR) product family and carries a status of VALID in the ETRM repository. The view exposes the set of Receivables batch sources that are relevant to the organization currently returned by AR_AI_ORG_V, the helper view used in the AutoInvoice workflow to resolve the operating unit context of the session.

Its purpose is to drive AutoInvoice batch-source selection lists and lookup pages. A batch source identifies the origin and defaulting rules applied to a group of transactions as they are imported through AutoInvoice. Because batch sources are defined per operating unit in RA_BATCH_SOURCES_ALL, a naive query can return the same batch-source name multiple times — once for each organization. AR_AI_BATCH_SOURCE_V is designed precisely to prevent that duplication. The documented description states that it "selects batch sources based on the org returned from ar_ai_org_v" and that "each batch source (name) should appear on the list only once." Only batch sources of type FOREIGN, that is, foreign or imported transactions processed by AutoInvoice, are included.

The view is therefore a presentation-layer object rather than a transactional data source. It is consumed by AutoInvoice setup and submission forms, and it can be joined safely to other AutoInvoice metadata queries.

Underlying Base Objects

The view is defined exclusively over RA_BATCH_SOURCES_ALL, referenced in the ETRM metadata as a synonym in the APPS schema. RA_BATCH_SOURCES_ALL is the multi-organization table that stores batch-source definitions, including the BATCH_SOURCE_ID primary key, the NAME and DESCRIPTION, the BATCH_SOURCE_TYPE classification, and the ORG_ID of the owning operating unit.

The view text performs a UNION ALL between two branches. The first branch aggregates RA_BATCH_SOURCES_ALL rows with BATCH_SOURCE_TYPE = 'FOREIGN' by NAME, returning MAX(DESCRIPTION), MAX(BATCH_SOURCE_ID), and MAX(ORG_ID), together with a literal GET_ALL flag of 'Y'. This branch collapses duplicate names across organizations into a single row. The second branch selects each FOREIGN batch source individually, returning its own DESCRIPTION, BATCH_SOURCE_ID, and ORG_ID, with GET_ALL set to 'N'.

Key Columns

• NAME — The batch-source name as displayed to users and referenced in the AutoInvoice interface tables. This is the value users select when submitting the AutoInvoice program.
• DESCRIPTION — The descriptive text attached to the batch source for identification and help text.
• BATCH_SOURCE_ID — The unique identifier of the batch source. In the aggregated GET_ALL = 'Y' branch this is a MAX() surrogate, whereas in the GET_ALL = 'N' branch it is the exact identifier of the individual row.
• ORG_ID — The operating unit that owns the batch source. Under Multi-Org Access Control this drives which definitions are visible to the current responsibility.
• GET_ALL — A derived flag. 'Y' denotes the consolidated row returned for a given NAME; 'N' denotes an individual organization-level row. This flag allows the calling form to offer a "get all" style choice alongside specific rows.

Common Use Cases and Queries

The primary use case is populating the list of valid AutoInvoice batch sources for the current operating unit without repeating names. A typical query restricting to the consolidated rows is:

SELECT name, description, batch_source_id, org_id
FROM apps.ar_ai_batch_source_v
WHERE get_all = 'Y'
ORDER BY name;

A second scenario retrieves every individual batch source tied to the session organization, which is useful when the exact BATCH_SOURCE_ID is required for an interface-table load:

SELECT name, description, batch_source_id, org_id
FROM apps.ar_ai_batch_source_v
WHERE get_all = 'N'
AND org_id = fnd_profile.value('ORG_ID');

A diagnostic query confirms that no batch-source name is duplicated across the consolidated result set, validating the view's stated design goal:

SELECT name, COUNT(*)
FROM apps.ar_ai_batch_source_v
WHERE get_all = 'Y'
GROUP BY name
HAVING COUNT(*) > 1;

Because the view filters to BATCH_SOURCE_TYPE = 'FOREIGN', it should not be used to enumerate manual or non-AutoInvoice batch sources; those must be queried directly from RA_BATCH_SOURCES_ALL.