Results for “cstbv_manufacturing_gl_batch”

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

Overview

In Oracle EBS 12.1.1 and 12.2.2, APPS.CSTBV_MANUFACTURING_GL_BATCH is a reporting view owned by the APPS schema and catalogued under the BOM (Bills of Material) product family. It exposes manufacturing General Ledger batch information for a given inventory organization, joining organization identifiers, batch identifiers, batch descriptions, organization codes and names, accounting period references, GL batch dates, and standard WHO audit columns. The view is documented in ETRM as "Retrofitted," indicating it is a compatibility/retrofit object within the Oracle E-Business Suite release lineage rather than a core transactional table. Its role is to provide a denormalized, read-only readout of the ORG_GL_BATCHES entity enriched with organization descriptions — precisely the shape required for reporting, reconciliation, and integration queries that need to resolve an organization ID to a human-readable code and name.

Underlying Base Objects

The ETRM metadata documents three referenced base objects, all exposed through APPS synonyms: ORG_GL_BATCHES, MTL_PARAMETERS, and HR_ALL_ORGANIZATION_UNITS. The view text confirms a three-way equijoin on ORGANIZATION_ID:

• ORG_GL_BATCHES (OGB) — the driving table, supplying ORGANIZATION_ID, GL_BATCH_ID, DESCRIPTION, ACCT_PERIOD_ID, GL_BATCH_DATE, and the WHO columns.
• MTL_PARAMETERS (MP) — joined on OGB.ORGANIZATION_ID = MP.ORGANIZATION_ID, supplying ORGANIZATION_CODE from the inventory organization parameters.
• HR_ALL_ORGANIZATION_UNITS (HAOU) — joined on HAOU.ORGANIZATION_ID = OGB.ORGANIZATION_ID, supplying the organization NAME.

The view definition also includes the secure predicate '_SEC:OGB.ORGANIZATION_ID' IS NOT NULL and is declared WITH READ ONLY. The security clause is a placeholder resolved by Oracle's security policy mechanism, restricting rows to organizations accessible to the querying user's operating unit / inventory organization security profile.

Key Columns

• ORGANIZATION_ID — Inventory organization identifier; the primary join key and the column governed by the security predicate.
• GL_BATCH_ID — Identifier of the General Ledger batch in ORG_GL_BATCHES.
• DESCRIPTION — Free-text description of the GL batch.
• ORGANIZATION_CODE — Organization code from MTL_PARAMETERS; the value most commonly used in extracts and reports.
• ORGANIZATION_NAME — Organization display name from HR_ALL_ORGANIZATION_UNITS.
• ACCT_PERIOD_ID — Accounting period reference associated with the batch.
• GL_BATCH_DATE — Date assigned to the GL batch.
• CREATED_DATE, CREATED_BY, UPDATED_DATE, UPDATED_BY — WHO audit columns mapping to the underlying creation and update metadata.

Common Use Cases and Queries

The view is typically used when a report or interface must list manufacturing GL batches together with organization context, without writing multi-table joins against ORG_GL_BATCHES, MTL_PARAMETERS, and HR_ALL_ORGANIZATION_UNITS directly. It is useful for period-end reconciliation of manufacturing accounting entries, for feeds into downstream GL consolidation, and for ad-hoc analysis of batch activity by organization and accounting period. Because it is read-only and protected by the security predicate on ORGANIZATION_ID, it can be safely exposed to operational users in concurrent programs and BI Publisher data models.

Typical query by organization code:

• SELECT organization_code, organization_name, gl_batch_id, description, gl_batch_date, acct_period_id
• FROM apps.cstbv_manufacturing_gl_batch
• WHERE organization_code = :p_org_code
• AND gl_batch_date BETWEEN :p_from_date AND :p_to_date
• ORDER BY gl_batch_date, gl_batch_id;

Because only the referenced base objects and columns documented above are guaranteed, consumers should treat the view as a reporting convenience layer over ORG_GL_BATCHES and validate against the actual view text in the target instance before relying on it for integration.