Search Results dp_dimension_code

Overview

MSD_DP_DIMENSIONS is a Demand Planning table owned by the MSD schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It stores the associations between Demand Plan User Defined Dimensions and the Real Dimensions available to a given demand plan. In effect, the table acts as a mapping or cross-reference registry: for each demand plan, it records which user-defined (DP) dimension codes are bound to which underlying real dimension codes. This mapping is fundamental because Demand Planning allows planners to define custom analytical dimensions that are not native to the source transaction schema, and those custom dimensions must ultimately resolve to a physical dimension before planning data can be stored, aggregated, and reported.

From a modeling standpoint, the mined Data Vault classification for this table is satellite-leaning. This is a heuristic suggestion rather than a physical declaration: the table's identity and descriptive attributes are functionally dependent on its owning demand plan, with the DEMAND_PLAN_ID foreign key anchoring the association to its parent entity. Modelers building a Data Vault or dimensional layer over the MSD schema should treat MSD_DP_DIMENSIONS as a dependent descriptive structure attached to the demand plan, not as an independent hub.

Key Information Stored

The documented physical schema comprises 15 columns. The most significant are:

DEMAND_PLAN_ID — the foreign key to MSD_DEMAND_PLANS that identifies the owning demand plan. It is the first component of the composite primary key.
DIMENSION_CODE — the real dimension against which the user-defined dimension is resolved. It is the second component of the primary key.
DP_DIMENSION_CODE — the Demand Plan user-defined dimension code being associated. It is the third component of the primary key.
DELETEABLE_FLAG — controls whether the association can be removed by the application.
ENABLE_NONSEED_FLAG — indicates whether non-seed (customer-defined) values are enabled for the dimension mapping.
ZD_EDITION_NAME — the editioning column used by Oracle EBS 12.2 online patching, present in the unique index and in all editioned tables.
LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — the standard EBS audit columns recording who created and last modified each row.
REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — concurrent program context columns identifying the request and program that last touched the row.

The surrogate primary key is MSD_DP_DIMENSIONS_PK over (DEMAND_PLAN_ID, DIMENSION_CODE, DP_DIMENSION_CODE). A separate unique index, MSD_DP_DIMENSIONS_U1, extends that key with ZD_EDITION_NAME, making it the edition-aware business-key candidate for uniqueness enforcement.

Common Use Cases and Queries

Typical usage centers on resolving how a planner's custom dimension maps to a physical dimension within a specific plan. A common query joins the table to its parent plan:

Listing all dimension associations for a plan: SELECT d.dimension_code, d.dp_dimension_code, d.enable_nonseed_flag FROM msd.msd_dp_dimensions d WHERE d.demand_plan_id = :plan_id;
Resolving a user-defined dimension to its real dimension: SELECT dimension_code FROM msd.msd_dp_dimensions WHERE demand_plan_id = :plan_id AND dp_dimension_code = :dp_code;
Auditing configuration changes through the standard audit columns, for example filtering on last_update_date to detect recently altered mappings.
Reporting which plans share a given dimension association, useful during plan cloning or template validation.

Because the table is relatively narrow and key-driven, queries are index-friendly when the demand plan is supplied as a predicate. In R12.2, queries should be edition-aware where the calling session must respect editioning semantics.

Related Objects

The principal related objects are:

MSD_DEMAND_PLANS — referenced by MSD_DP_DIMENSIONS.DEMAND_PLAN_ID. This is the mandatory parent join and the primary source of plan-level attributes.
MSD_DP_DIMENSIONS_PK — the primary key constraint enforcing row identity on (DEMAND_PLAN_ID, DIMENSION_CODE, DP_DIMENSION_CODE).
MSD_DP_DIMENSIONS_U1 — the unique index adding ZD_EDITION_NAME for edition-aware uniqueness.
Demand Planning dimension and plan definition views in the MSD schema, which consume the mapping rows to resolve user-defined dimensions at runtime.

Because the documentation exposes only a single foreign key, MSD_DEMAND_PLANS is the only strictly documented dependent relationship; other MSD dimension and plan metadata objects interact with this table logically through the DIMENSION_CODE and DP_DIMENSION_CODE business keys.

Table: MSD_DP_DIMENSIONS 12.1.1
owner:MSD, object_type:TABLE, fnd_design_data:MSD.MSD_DP_DIMENSIONS, object_name:MSD_DP_DIMENSIONS, status:VALID, product: MSD - Demand Planning , description: This table stores the associations between the Demand Plan User Defined Dimensions and the Real Dimensions. , implementation_dba_data: MSD.MSD_DP_DIMENSIONS ,
Table: MSD_DP_DIMENSIONS 12.2.2
owner:MSD, object_type:TABLE, fnd_design_data:MSD.MSD_DP_DIMENSIONS, object_name:MSD_DP_DIMENSIONS, status:VALID, product: MSD - Demand Planning , description: This table stores the associations between the Demand Plan User Defined Dimensions and the Real Dimensions. , implementation_dba_data: MSD.MSD_DP_DIMENSIONS ,
View: MSD_DP_HIERS_HLP_V 12.2.2
product: MSD - Demand Planning , description: This view associates the demand plan to its dimensions. This is used for Demand Plan forms. The usage of this view for anyother purpose is discouraged. , implementation_dba_data: Not implemented in this database ,
View: MSD_DP_HIERS_HLP_V 12.1.1
product: MSD - Demand Planning , description: This view associates the demand plan to its dimensions. This is used for Demand Plan forms. The usage of this view for anyother purpose is discouraged. , implementation_dba_data: Not implemented in this database ,
View: MSD_DP_HIERARCHIES_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:MSD.MSD_DP_HIERARCHIES_V, object_name:MSD_DP_HIERARCHIES_V, status:VALID, product: MSD - Demand Planning , description: This view stores the Demand Plan Hierarchies Association. , implementation_dba_data: APPS.MSD_DP_HIERARCHIES_V ,
View: MSD_DP_HIERARCHIES_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:MSD.MSD_DP_HIERARCHIES_V, object_name:MSD_DP_HIERARCHIES_V, status:VALID, product: MSD - Demand Planning , description: This view stores the Demand Plan Hierarchies Association. , implementation_dba_data: APPS.MSD_DP_HIERARCHIES_V ,
View: MSD_DP_DIMENSIONS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:MSD.MSD_DP_DIMENSIONS_V, object_name:MSD_DP_DIMENSIONS_V, status:VALID, product: MSD - Demand Planning , description: This view stores the associations between the Demand Plans User Defined Dimensions and the Real Dimensions. , implementation_dba_data: APPS.MSD_DP_DIMENSIONS_V ,
View: MSD_DP_DIMENSIONS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:MSD.MSD_DP_DIMENSIONS_V, object_name:MSD_DP_DIMENSIONS_V, status:VALID, product: MSD - Demand Planning , description: This view stores the associations between the Demand Plans User Defined Dimensions and the Real Dimensions. , implementation_dba_data: APPS.MSD_DP_DIMENSIONS_V ,
View: MSD_DP_SCN_OUTPUT_LEVELS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:MSD.MSD_DP_SCN_OUTPUT_LEVELS_V, object_name:MSD_DP_SCN_OUTPUT_LEVELS_V, status:VALID, product: MSD - Demand Planning , description: This view provides the Levels at which the output Scenario for a demand plan is to be generated. This stores the level values for all the dimension except for the time dimensions as the level values for the time dimension are pre-seeded as , implementation_dba_data: APPS.MSD_DP_SCN_OUTPUT_LEVELS_V ,
View: MSD_DP_SCN_OUTPUT_LEVELS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:MSD.MSD_DP_SCN_OUTPUT_LEVELS_V, object_name:MSD_DP_SCN_OUTPUT_LEVELS_V, status:VALID, product: MSD - Demand Planning , description: This view provides the Levels at which the output Scenario for a demand plan is to be generated. This stores the level values for all the dimension except for the time dimensions as the level values for the time dimension are pre-seeded as , implementation_dba_data: APPS.MSD_DP_SCN_OUTPUT_LEVELS_V ,