Results for “subinv_locator_type”

16 results




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

Overview

GMF_XLA_SUBINV_V is a public APPS view in Oracle E-Business Suite that exposes subinventory definition attributes for consumption by the Subledger Accounting (SLA) Accounting Derivation Rules (ADR) and Journal Line Definition framework. It is owned by the APPS schema and registered in ETRM as a VALID object belonging to the GMF – Process Manufacturing Financials product family. The view derives its data from the Oracle Inventory subinventory master, which is why the user search term "subinventory_type" resolves here: SUBINVENTORY_TYPE is one of the driveable attributes surfaced by this view for accounting rule evaluation.

In Oracle EBS 12.1.1 and 12.2.2, the SLA ADR engine maps transactional context to accounting attributes through source views. GMF_XLA_SUBINV_V provides the subinventory-level context — subtype, locator type, asset flag, and the full set of default accounts — so that accounting rules can conditionally derive expense, material, overhead, resource, OSP, and encumbrance accounts without joining directly to MTL_SECONDARY_INVENTORIES in custom rule logic. This encapsulation makes it easier to extend or override default account derivation while remaining upgrade-safe.

Underlying Base Objects

Per the documented ETRM metadata, the only referenced base object is MTL_SECONDARY_INVENTORIES (accessed via a SYNONYM in the APPS schema). The view text is a single flat SELECT with no joins, UNIONs, or aggregates, aliasing the source table as SUBINV. This simplicity is intentional: the view is a projection/filter shim that renames columns into SLA-friendly source names. Because MTL_SECONDARY_INVENTORIES is the authoritative subinventory definition table in Oracle Inventory, any change made to the subinventory (subtype, locator control, asset flag, or default account assignments) is immediately visible through this view — there is no materialization or caching.

Key Columns

Common Use Cases and Queries

The primary use case is authoring or debugging SLA accounting derivation rules that branch on subinventory attributes. Analysts frequently query this view to enumerate subinventory types and account assignments before writing an ADR.

  • List subinventories by type and asset status.
  • Return default accounts for a specific subinventory to compare against SLA-derived postings.
  • Filter by SUBINV_ASSET_FLAG to separate asset (storable) from non-asset (expense) subinventories.

Sample SQL:

SELECT organization_id, subinventory_code, subinventory_type, subinv_asset_flag, subinv_locator_type, subinv_material_account, subinv_expense_account
FROM apps.gmf_xla_subinventory_v
WHERE organization_id = :org_id
AND subinventory_type = 'STORAGE';

Because the view already exposes SLA-oriented naming, it can be referenced in custom ADR source queries or diagnostic reports without additional joins. Confirm grants to the calling schema when using it outside the APPS or GMF application users, and note that no row-level security (MOAC) is applied here — organization filtering must be supplied explicitly.