MSD — Demand Planning
78 documented tables · 138 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
MSD_DEMAND_PLANS |
Demand Plan definition. | hub |
MSD_EVENTS |
This table stores the Marketing Events. This defines the types of Events and is the header to the MSD_EVENT_PR | hub-leaning |
MSD_LEVEL_VALUES |
This table stores all the level values Information including the system generated primary key and the level va | hub |
MSD_EVENT_PRODUCTS |
This table is a child to MSD_EVENTS. This stores the information about the various products. | hub-leaning |
MSD_HIERARCHIES |
This table provides the Hierachies, their corresponding State (Valid or Not) and the Dimension to which it be | hub-leaning |
MSD_DP_SCENARIO_ENTRIES |
This fact table has all the detail scenario entry information. | link |
MSD_CS_CLMN_IDENTIFIERS |
This table has Column identifiers for Custom Data Stream. | standalone |
MSD_SETUP_PARAMETERS |
This table stores Demand Planning application parameters setup information. | standalone |
MSD_CS_DEFINITIONS_TL |
This table holds translatable data for MSD_CS_DEFINITIONS. | standalone |
MSD_CS_DEFN_DIM_DTLS |
This table has Data Stream's Dimension details. | standalone |
MSD_DP_SCENARIO_REVISIONS |
Header Table for Scenario Entries Table | standalone |
MSD_DP_EXPRESS_SETUP |
This table stores the Express related Setup information for a Demand Plan. | satellite-leaning |
MSD_CS_CLMN_DIM_DTLS |
This table has Data Streams Column Dimension specific details. | standalone |
MSD_EVT_PROD_RELATIONSHIPS |
This table is a child to the MSD_EVENT_PRODUCTS and holds the relationship information for New Product Introd | satellite-leaning |
MSD_CS_DATA_HEADERS |
Stores Custom Stream Fact Headers | standalone |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.
Key public APIs
| Package | Class | Procedures | Used by |
|---|---|---|---|
MSD_FCST_PUB |
PUB | 2 | 0 packages |