Search Results dimension_code

Overview

MSD_CS_DEFINITIONS_V1 is a VALID dictionary view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It belongs to the MSD (Demand Planning) product family and is documented as providing "Data Stream Definition and its dimension properties." In the ETRM/Advanced Supply Chain Planning data model, a data stream (internally a "CS definition," where CS denotes collection stream) represents a logical partition of planning data — such as demand history, shipments, or forecasts — that is collected from source systems and staged for the planning server. This view presents the header attributes of each stream definition alongside up to eight pre-defined dimension collection slots, each of which carries a collect level and a collection flag.

The view serves reporting, integration, and diagnostic purposes. Because it joins the stream header to its dimension detail rows and resolves lookup codes to human-readable meanings in a single query, it is a convenient interface for administrators validating the configuration of streams before or after a data collection run, and for custom reports that enumerate the dimensions that a given stream is configured to collect.

Underlying Base Objects

The documented referenced base objects are MSD_CS_DEFINITIONS (SYNONYM), MSD_CS_DEFN_DIM_DTLS (SYNONYM), and FND_LOOKUP_VALUES_VL (VIEW). The view text confirms this: the driving table is MSD_CS_DEFINITIONS, aliased CSD, one row per stream definition. MSD_CS_DEFN_DIM_DTLS is joined eight times — aliased DFDIM1 through DFDIM8 — each time on CS_DEFINITION_ID with an outer join and a fixed DIMENSION_CODE filter. The first two aliases restrict on 'PRD' (product) and 'GEO' (geography) respectively, with the remaining aliases covering the other configured dimension codes.

FND_LOOKUP_VALUES_VL is joined twice through outer joins to translate stored lookup codes into meanings. LOK1 resolves CS_TYPE against lookup type MSD_CS_STREAM_SOURCE_TYPE, and LOK2 resolves MEASUREMENT_TYPE against lookup type MSD_CS_MEASUREMENT_TYPE. Because both dimension detail joins and both lookup joins are outer joins, a stream definition is never dropped from the result set even when its dimension rows or lookup values are missing.

Key Columns

CS_DEFINITION_ID — primary identifier of the stream definition; the join key to all dimension detail rows.
NAME, DESCRIPTION — user-facing identity of the stream.
CS_CLASSIFICATION, CS_TYPE, CS_TYPE_DESC — classification and source type of the stream, with the decoded type meaning from the MSD_CS_STREAM_SOURCE_TYPE lookup.
MEASUREMENT_TYPE — the measure the stream carries, decoded against MSD_CS_MEASUREMENT_TYPE.
VALID_FLAG, SYSTEM_FLAG, STRICT_FLAG, LOWEST_LEVEL_FLAG — status and behavioral indicators controlling whether the stream is active, system-seeded, and how rigorously its levels are enforced.
AGGREGATION_ALLOWED_FLAG, ALLOCATION_ALLOWED_FLAG, STREAM_EDITABLE_FLAG, MULTIPLE_STREAM_FLAG — capability flags governing aggregation, allocation, editability, and whether more than one instance of the stream may exist.
PLANNING_SERVER_VIEW_NAME, SOURCE_VIEW_NAME, CS_LOV_VIEW_NAME — the database views used by the planning server, the collection source, and the LOV, respectively.
COLLECTION_PROGRAM_NAME, COLLECT_ADDTL_WHERE_CLAUSE, PULL_ADDTL_WHERE_CLAUSE — the concurrent program that collects the stream and the SQL predicates appended to collection and pull queries.
DFDIMn.COLLECT_LEVEL_ID and DFDIMn.COLLECT_FLAG — per-dimension collect level and collection indicator for each of the eight dimension slots, where n ranges from 1 to 8.
CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — standard EBS WHO and concurrent program audit columns.

Common Use Cases and Queries

Typical usage includes verifying which dimensions a given stream collects, identifying streams whose type or measurement lookups are unmapped, and listing collection programs by stream.

Listing valid streams with decoded type and measurement:

SELECT cs_definition_id, name, cs_type_desc, measurement_type, valid_flag FROM apps.msd_cs_definitions_v1 WHERE valid_flag = 'Y';

Inspecting the eight dimension collect levels and flags for one stream:

SELECT name, dfdim1_collect_level_id, dfdim1_collect_flag, dfdim2_collect_level_id, dfdim2_collect_flag, dfdim3_collect_level_id, dfdim3_collect_flag FROM apps.msd_cs_definitions_v1 WHERE cs_definition_id = :p_id;

Finding streams where a lookup join returned no meaning, indicating a missing lookup value:

SELECT cs_definition_id, name, cs_type, measurement_type FROM apps.msd_cs_definitions_v1 WHERE cs_type_desc IS NULL OR measurement_type IS NULL;

Enumerating collection programs across all streams:

SELECT name, collection_program_name, source_view_name FROM apps.msd_cs_definitions_v1 ORDER BY collection_program_name, name;

View: MSD_CS_DEFINITIONS_V1 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:MSD.MSD_CS_DEFINITIONS_V1, object_name:MSD_CS_DEFINITIONS_V1, status:VALID, product: MSD - Demand Planning , description: This view provides Data Stream Definition and it's dimension properties. , implementation_dba_data: APPS.MSD_CS_DEFINITIONS_V1 ,
View: MSD_CS_DEFINITIONS_V1 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:MSD.MSD_CS_DEFINITIONS_V1, object_name:MSD_CS_DEFINITIONS_V1, status:VALID, product: MSD - Demand Planning , description: This view provides Data Stream Definition and it's dimension properties. , implementation_dba_data: APPS.MSD_CS_DEFINITIONS_V1 ,
View: MSD_LEVEL_ASSOCIATIONS_V1 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:MSD.MSD_LEVEL_ASSOCIATIONS_V1, object_name:MSD_LEVEL_ASSOCIATIONS_V1, status:VALID, product: MSD - Demand Planning , description: This view specifies the Level Value Associations for a level with its parent level value in a hierarchy along with the system generated primary keys for these level values. This view is used only for the Level Associations form. , implementation_dba_data: APPS.MSD_LEVEL_ASSOCIATIONS_V1 ,
View: MSD_LEVEL_ASSOCIATIONS_V1 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:MSD.MSD_LEVEL_ASSOCIATIONS_V1, object_name:MSD_LEVEL_ASSOCIATIONS_V1, status:VALID, product: MSD - Demand Planning , description: This view specifies the Level Value Associations for a level with its parent level value in a hierarchy along with the system generated primary keys for these level values. This view is used only for the Level Associations form. , implementation_dba_data: APPS.MSD_LEVEL_ASSOCIATIONS_V1 ,
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_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_CS_DEFN_DIM_DTLS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:MSD.MSD_CS_DEFN_DIM_DTLS_V, object_name:MSD_CS_DEFN_DIM_DTLS_V, status:VALID, product: MSD - Demand Planning , description: This view provides Data Stream's Dimension Details. , implementation_dba_data: APPS.MSD_CS_DEFN_DIM_DTLS_V ,
View: MSD_CS_DEFN_DIM_DTLS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:MSD.MSD_CS_DEFN_DIM_DTLS_V, object_name:MSD_CS_DEFN_DIM_DTLS_V, status:VALID, product: MSD - Demand Planning , description: This view provides Data Stream's Dimension Details. , implementation_dba_data: APPS.MSD_CS_DEFN_DIM_DTLS_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_CS_CLMN_DIM_DTLS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:MSD.MSD_CS_CLMN_DIM_DTLS_V, object_name:MSD_CS_CLMN_DIM_DTLS_V, status:VALID, product: MSD - Demand Planning , description: This view is provides Data Stream's Dimension-Column specific details. , implementation_dba_data: APPS.MSD_CS_CLMN_DIM_DTLS_V ,
View: MSD_CS_CLMN_DIM_DTLS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:MSD.MSD_CS_CLMN_DIM_DTLS_V, object_name:MSD_CS_CLMN_DIM_DTLS_V, status:VALID, product: MSD - Demand Planning , description: This view is provides Data Stream's Dimension-Column specific details. , implementation_dba_data: APPS.MSD_CS_CLMN_DIM_DTLS_V ,
View: MSD_LEVEL_VALUES_V1 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:MSD.MSD_LEVEL_VALUES_V1, object_name:MSD_LEVEL_VALUES_V1, status:VALID, product: MSD - Demand Planning , description: This view specifies the Level Values along with the system generated primary keys for these level values. This view is used only for the Level Values form. , implementation_dba_data: APPS.MSD_LEVEL_VALUES_V1 ,
View: MSD_LEVEL_VALUES_V1 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:MSD.MSD_LEVEL_VALUES_V1, object_name:MSD_LEVEL_VALUES_V1, status:VALID, product: MSD - Demand Planning , description: This view specifies the Level Values along with the system generated primary keys for these level values. This view is used only for the Level Values form. , implementation_dba_data: APPS.MSD_LEVEL_VALUES_V1 ,