MSD Tables (78)
MSD - Demand Planning — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.
| Table | Columns | Description |
|---|---|---|
MSD_APP_INSTANCE_ORGS |
27 | This table resides in Source Instance. It hold the list of organizations for which data must be brought in to the planning Server. ODP sourc |
MSD_AUDIT_SQL_STATEMENTS |
40 | This table forms the basis for the Audit Statements architecture. Each row can be interpreted as a valid sql query. A concurrent program p |
MSD_BACKUP_LEVEL_VALUES |
4 | This table stores level value pks during a level value collection. After a level is collected (in msd_level_values) it's pks are reverted to |
MSD_BOM_COMPONENTS |
18 | Contains Model to Component Relationships |
MSD_BOOKING_DATA |
40 | Fact Table that stores the Booking Data. |
MSD_COMMENTS |
15 | This table stores comments for a particular scenario revision |
MSD_CS_CLMN_DIM_DTLS |
15 | This table has Data Streams Column Dimension specific details. |
MSD_CS_CLMN_IDENTIFIERS |
13 | This table has Column identifiers for Custom Data Stream. |
MSD_CS_CLMN_IDENTIFIERS_TL |
15 | This table holds translatable data for MSD_CS_CLMN_IDENTIFIERS. |
MSD_CS_DATA |
76 | This table is fact table for Custom Data Stream. |
MSD_CS_DATA_HEADERS |
14 | Stores Custom Stream Fact Headers |
MSD_CS_DEFINITIONS |
47 | This table stores Custom Stream Definitions |
MSD_CS_DEFINITIONS_TL |
14 | This table holds translatable data for MSD_CS_DEFINITIONS. |
MSD_CS_DEFN_COLUMN_DTLS |
19 | This table has Data Stream's Column mappings. |
MSD_CS_DEFN_DIM_DTLS |
17 | This table has Data Stream's Dimension details. |
MSD_CURRENCY_CONVERSIONS |
13 | Fact table that stores the Currency Conversion information. |
MSD_DELETED_LEVEL_VALUES |
16 | This table stores all the deleted level values Information including the system generated primary key and the level value attributes. This i |
MSD_DEMAND_PLANS |
75 | Demand Plan definition. |
MSD_DEM_ITEMS_GTT |
4 | |
MSD_DEM_LOCATIONS_GTT |
5 | |
MSD_DEM_PRICE_LISTS_GTT |
12 | |
MSD_DEM_UOM_CONVERSIONS_GTT |
8 | |
MSD_DP_CALENDARS |
15 | This table stores Demand Plan related Calendars. |
MSD_DP_DIMENSIONS |
15 | This table stores the associations between the Demand Plan User Defined Dimensions and the Real Dimensions. |
MSD_DP_EVENTS |
15 | This table stores Demand Plan related Events. |
MSD_DP_EXPRESS_SETUP |
23 | This table stores the Express related Setup information for a Demand Plan. |
MSD_DP_HIERARCHIES |
15 | This table stores the various hierarchies that are associated to the Demand Plan. |
MSD_DP_PARAMETERS |
45 | This table stores the Parameters (both Input as well as Output) to be used by a Demand Plan. This will be used by Oracle Express to load the |
MSD_DP_PLANNING_PERCENTAGES |
24 | Planning Percentages Data Published by DPE |
MSD_DP_PRICE_LISTS |
15 | This table stores Deman Plan's Price Lists. |
MSD_DP_SCENARIOS |
58 | This table specifies the Scenarios to be generated from a particular Demand Plan. [To actually generate this scenario from Oracle Express, |
MSD_DP_SCENARIO_ENTRIES |
68 | This fact table has all the detail scenario entry information. |
MSD_DP_SCENARIO_EVENTS |
16 | This tables stores the associations between a scenario and the events associated with this scenario. |
MSD_DP_SCENARIO_OUTPUT_LEVELS |
15 | This table specifies the levels in the various dimensions except for the time dimension at which the Scenario needs to be generated from the |
MSD_DP_SCENARIO_REVISIONS |
11 | Header Table for Scenario Entries Table |
MSD_EVENTS |
68 | This table stores the Marketing Events. This defines the types of Events and is the header to the MSD_EVENT_PRODUCTS table. |
MSD_EVENT_DETAILS |
39 | |
MSD_EVENT_PRODUCTS |
19 | This table is a child to MSD_EVENTS. This stores the information about the various products. |
MSD_EVT_PRODUCT_DETAILS |
47 | This table is a child to the MSD_EVENT_PRODUCTS. This stores all the detail events information. |
MSD_EVT_PROD_RELATIONSHIPS |
22 | This table is a child to the MSD_EVENT_PRODUCTS and holds the relationship information for New Product Introductions. |
MSD_HIERARCHIES |
32 | This table provides the Hierachies, their corresponding State (Valid or Not) and the Dimension to which it belongs. |
MSD_HIERARCHY_LEVELS |
21 | This table provides the Level Associations within a Hierarchy for a Real Dimension. |
MSD_ITEM_LIST_PRICE |
20 | This is a fact table that stores the list price, Base UOM and the average discount for each of the Product that is used in the Demand Planni |
MSD_LEVELS |
40 | This tableI provides the Levels, their Owning Dimension. It also specifies the Level Type. The possible values for Level Type are : |
MSD_LEVEL_ASSOCIATIONS |
23 | This table maintains association information between levels. |
MSD_LEVEL_VALUES |
30 | This table stores all the level values Information including the system generated primary key and the level value attributes. This is not st |
MSD_LOCAL_ID_SETUP |
33 | This table is used by Legacy Collection to generate Local ID. |
MSD_MFG_FORECAST |
36 | This table stores the fact data for Manufacturing Forecast. |
MSD_ODPTIME |
2 | |
MSD_ORG_CALENDARS |
13 | This table stores Associations between Organizations and Calendars. |
MSD_PRICE_LIST |
34 | This table has Price Lists. |
MSD_REASON_CODES |
10 | This table stores comment reason codes for scenario revisions. |
MSD_SALES_FORECAST |
41 | |
MSD_SALES_OPPORTUNITY_DATA |
38 | |
MSD_SCN_ENTRY_COMMENTS |
27 | This table stores the comments for scenario entries. |
MSD_SETUP_PARAMETERS |
3 | This table stores Demand Planning application parameters setup information. |
MSD_SHIPMENT_DATA |
41 | This is the fact table that stores the Shipment Information. |
MSD_ST_BOOKING_DATA |
49 | Staging table that stores the booking data. |
MSD_ST_CS_DATA |
92 | This is staging table for Custom Stream Data. |
MSD_ST_CURRENCY_CONVERSIONS |
22 | Staging table that stores the currency conversion information. |
MSD_ST_EVENTS |
16 | Staging table for events |
MSD_ST_EVENT_PRODUCTS |
17 | Staging table for events |
MSD_ST_EVT_PRODUCT_DETAILS |
42 | Staging table for events |
MSD_ST_EVT_PROD_RELATIONSHIPS |
22 | Event product relationsships staging table |
MSD_ST_ITEM_LIST_PRICE |
23 | Staging table that stores the item information like the base UOM, list price, and average discount. |
MSD_ST_LEVEL_ASSOCIATIONS |
32 | Staging table that specifies the value level associations for a level with its parent level in a hierarchy. This is not stripped by Demand P |
MSD_ST_LEVEL_VALUES |
32 | Staging table that stores all the level information; the attributes and the value. This is not stripped by the Demand Plan Id. |
MSD_ST_MFG_FORECAST |
44 | Staging table that stores the data for manufacturing forecast. |
MSD_ST_ORG_CALENDARS |
13 | This staging table stores Associations between Organizations and Calendars. |
MSD_ST_PRICE_LIST |
57 | Staging table for price list data |
MSD_ST_SALES_FORECAST |
41 | Staging table that stores the sales forecast data. |
MSD_ST_SALES_OPPORTUNITY_DATA |
38 | Staging table that stores the sales opportunity data. |
MSD_ST_SETUP_PARAMETERS |
18 | This table is used by Legacy Collection for Staging Setup Parameters |
MSD_ST_SHIPMENT_DATA |
50 | Staging table that stores the shipment information. |
MSD_ST_TIME |
38 | Staging table that stores the calender information. |
MSD_ST_UOM_CONVERSIONS |
25 | Staging table that stores the Unit of measurement conversion information. |
MSD_TIME |
32 | This is the fact table that stores the Time Information. |
MSD_UOM_CONVERSIONS |
21 | This is the fact table that stores the UOM conversions information. |