Results for “organization_pk”

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

Overview

The view EDW_MTL_ILDM_PORG_LCV is an Operations Intelligence (OPI) source view that exposes the Inventory Organization Group level of the Inventory Locator dimension. It belongs to the OPI – Operations Intelligence product, which is documented as obsolete in Oracle E-Business Suite 12.1.1 and 12.2.2. Its primary role is to supply a conformed, denormalized dimension record set to the Enterprise Data Warehouse (EDW) layer, where inventory organizations and their parent groupings are staged for analytical reporting and dimensional modeling.

The view consolidates inventory organization data originating from Oracle Process Manufacturing (OPM) master tables with operating unit information, producing a unified list of organization groups. The suffix _LCV denotes that this is a level/column value source construct used by the EDW extraction process. The column ORGANIZATION_DP — the term the user searched for — is a constant literal designating the dimension role (for example, 'INVENTORY ORGANIZATION GROUP'), allowing the EDW loading routines to tag each row with its dimensional classification.

Underlying Base Objects

The ETRM metadata records no implemented base objects for this view, and it is explicitly noted as "Not implemented in this database." The view text, however, reveals its composition through three UNION branches:

• SY_ORGN_MST (aliased O) joined with EDW_LOCAL_INSTANCE (I), providing the OPM organization master records.
• EDW_MTL_ILDM_OU_LCV (aliased OUV), a companion EDW operating-unit level view that supplies the operating unit branch.
• A third branch re-querying SY_ORGN_MST and EDW_LOCAL_INSTANCE filtered by O.ORGN_CODE = O.CO_CODE, deriving the OPM company-level grouping.

Because the documented metadata lists no referenced base objects, the view text is the authoritative source for its lineage. It sits above the EDW staging views and OPM organization master, and below the higher-level Inventory Locator dimension objects consumed by OPI analytics.

Key Columns

• OPM_ORGANIZATION_PK — Composite primary key formed as ORGN_CODE-INSTANCE_CODE-OPM, uniquely identifying the organization group for the OPM instance.
• INSTANCE_CODE — Identifier of the local EDW instance, sourced from EDW_LOCAL_INSTANCE.
• OPM_COMPANY_FK — Foreign key expression linking the organization to its OPM company context.
• OPM_ORGANIZATION_CODE — The OPM organization code (ORGN_CODE).
• OPM_ORGANIZATION_NAME — The OPM organization name (ORGN_NAME).
• OPM_ORGANIZATION_DP / ORGANIZATION_DP — Dimensional role descriptor, a literal string used to classify the row (for example 'INVENTORY ORGANIZATION GROUP'). This is the attribute the user searched for.
• DESCRIPTION and NAME — Descriptive text, generally the organization name or a formatted code(name) string.
• CREATION_DATE / LAST_UPDATE_DATE — Audit timestamps inherited from the source records.
• USER_ATTRIBUTE1 through USER_ATTRIBUTE5 — Placeholder descriptive flexfield attributes, populated (NULL) for extension flexibility.

Common Use Cases and Queries

This view supports OPI inventory analytics by supplying organization-group dimension rows. Typical use cases include building the Inventory Locator dimension hierarchy, reconciling OPM organizations to operating units, and attributing inventory transactions to their parent organization groups.

A basic extraction query might read:

• SELECT OPM_ORGANIZATION_PK, OPM_ORGANIZATION_CODE, OPM_ORGANIZATION_NAME, ORGANIZATION_DP FROM EDW_MTL_ILDM_PORG_LCV WHERE ORGANIZATION_DP = 'INVENTORY ORGANIZATION GROUP';
• SELECT INSTANCE_CODE, COUNT(*) FROM EDW_MTL_ILDM_PORG_LCV GROUP BY INSTANCE_CODE;

Because the view is documented as obsolete and not implemented in the reference database, DBAs should confirm its presence before relying on it and consider that later releases may replace this construct with newer EDW dimension views.