Search Results msd_levels_u2

Overview

MSD.MSD_LEVELS is a seed data table in the Oracle E-Business Suite 12.1.1 / 12.2.2 schema MSD (the Advanced Planning / Demand Planning schema foundation). It defines the levels used within a planning dimension hierarchy and records the owning dimension and the classification of each level. In that capacity, MSD_LEVELS functions as the master registry of hierarchy levels that other planning, BOM, WIP, BI/analytics, and HR-related tables reference through the LEVEL_ID foreign key.

From a Data Vault modeling perspective the table is best treated as a standalone reference hub: the metadata classifies it as standalone, with a single primary key MSD_LEVELS_PK on LEVEL_ID and no foreign keys of its own. It is referenced broadly (a characteristic of a hub-style reference entity) but does not itself depend upward on other MSD tables. This makes it useful as a conformed reference for level names, types, and dimension codes across dependent subject areas.

Key Information Stored

MSD_LEVELS contains 40 documented columns. The most important are summarized below.

• LEVEL_ID — Surrogate primary key. Unique numeric identifier for the level. It is the column referenced by the many dependent tables in the relationship model.
• LEVEL_NAME (VARCHAR2 30) — Human-readable level name. Part of the MSD_LEVELS_U2 business-key index.
• DESCRIPTION (VARCHAR2 240) — Descriptive text for the level.
• DIMENSION_CODE — Identifier of the dimension the level belongs to; defines ownership within the hierarchy.
• LEVEL_TYPE_CODE — Level classification based on the MSD_LEVEL_TYPE lookup (Top Level, Bottom Level, Intermediate Level).
• PLAN_TYPE — Plan type discriminator; part of both unique business-key indexes.
• ZD_EDITION_NAME — Edition/environment discriminator; also part of both unique indexes.
• ATTRIBUTE1_CONTEXT through ATTRIBUTE5_CONTEXT (VARCHAR2 240) — Context labels for the five associated attributes.
• ATTRIBUTE_CATEGORY, plus ATTRIBUTE1–ATTRIBUTE15 — Descriptive flexfield-style columns for extensible configuration.
• ORG_RELATIONSHIP_VIEW and SYSTEM_ATTRIBUTE1_CONTEXT / SYSTEM_ATTRIBUTE2_CONTEXT — Seed/organization and system context attributes.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — Standard WHO and enhanced WHO audit columns.

Two unique indexes are documented as business-key candidates: MSD_LEVELS_U1 on (PLAN_TYPE, LEVEL_ID, ZD_EDITION_NAME) and MSD_LEVELS_U2 on (PLAN_TYPE, LEVEL_NAME, ZD_EDITION_NAME). The surrogate key is LEVEL_ID; the business key is the combination of LEVEL_NAME, PLAN_TYPE, and edition.

Common Use Cases and Queries

Typical queries resolve level names and types for reporting, validate hierarchy configuration, or join levels to dependent planning tables.

• List all levels for a dimension: SELECT LEVEL_ID, LEVEL_NAME, LEVEL_TYPE_CODE FROM MSD.MSD_LEVELS WHERE DIMENSION_CODE = :dim;
• Find top-level levels: filter LEVEL_TYPE_CODE to the Top Level lookup value.
• Join to dependent tables using the shared key: SELECT ... FROM MSD.MSD_LEVELS l JOIN MSD.MSD_LEVEL_ASSOCIATIONS a ON a.LEVEL_ID = l.LEVEL_ID;
• Audit configuration changes by querying the WHO columns (LAST_UPDATE_DATE, LAST_UPDATED_BY).
• Cross-check edition/plan context using ZD_EDITION_NAME and PLAN_TYPE, honoring the U1 and U2 uniqueness rules.

Related Objects

MSD_LEVELS is referenced by many tables through LEVEL_ID. Significant dependents include:

• MSD_LEVEL_ASSOCIATIONS.LEVEL_ID → MSD_LEVELS.LEVEL_ID — associates levels with planning structures.
• MSD_ST_LEVEL_ASSOCIATIONS.LEVEL_ID and MSD_ST_LEVEL_VALUES.LEVEL_ID — level value/association storage.
• MSD_DELETED_LEVEL_VALUES.LEVEL_ID — tracks removed level values.
• MSC_ALLOCATIONS.LEVEL_ID — planning allocation definitions.
• CSP_PLANNING_PARAMETERS.LEVEL_ID — planning parameter configuration.
• BIS_LEVELS.LEVEL_ID and BIS_LEVELS_TL.LEVEL_ID — BI/analytics level definitions.
• FII_FIN_ITEM_HIERARCHIES.LEVEL_ID and FII_LOB_HIERARCHIES.LEVEL_ID — financial hierarchy levels.
• BOM_OPERATION_SKILLS.LEVEL_ID and WIP_PREFERENCE_LEVELS.LEVEL_ID — manufacturing/BOM and WIP references.