You are browsing the archive for ODP.

Oracle Demand Planning Tables

Oracle Demand Planning module – List of database tables:

  • MSD_APP_INSTANCE_ORGS
  • MSD_AUDIT_SQL_STATEMENTS
  • MSD_BACKUP_LEVEL_VALUES
  • MSD_BOM_COMPONENTS
  • MSD_BOOKING_DATA
  • MSD_COMMENTS
  • MSD_CS_CLMN_DIM_DTLS
  • MSD_CS_CLMN_IDENTIFIERS
  • MSD_CS_CLMN_IDENTIFIERS_TL
  • MSD_CS_DATA
  • MSD_CS_DATA_HEADERS
  • MSD_CS_DEFINITIONS
  • MSD_CS_DEFINITIONS_TL
  • MSD_CS_DEFN_COLUMN_DTLS
  • MSD_CS_DEFN_DIM_DTLS
  • MSD_CURRENCY_CONVERSIONS
  • MSD_DELETED_LEVEL_VALUES
  • MSD_DEMAND_PLANS
  • MSD_DP_CALENDARS
  • MSD_DP_DIMENSIONS
  • MSD_DP_EVENTS
  • MSD_DP_EXPRESS_SETUP
  • MSD_DP_HIERARCHIES
  • MSD_DP_PARAMETERS
  • MSD_DP_PLANNING_PERCENTAGES
  • MSD_DP_PRICE_LISTS
  • MSD_DP_SCENARIOS
  • MSD_DP_SCENARIO_ENTRIES
  • MSD_DP_SCENARIO_EVENTS
  • MSD_DP_SCENARIO_INTRODUCTIONS
  • MSD_DP_SCENARIO_OUTPUT_LEVELS
  • MSD_DP_SCENARIO_REVISIONS
  • MSD_EVENTS
  • MSD_EVENT_DETAILS
  • MSD_EVENT_PRODUCTS
  • MSD_EVT_PRODUCT_DETAILS
  • MSD_EVT_PROD_RELATIONSHIPS
  • MSD_HIERARCHIES
  • MSD_HIERARCHY_LEVELS
  • MSD_INTRODUCTION_EVENTS
  • MSD_INTRODUCTION_PLANS
  • MSD_ITEM_LIST_PRICE
  • MSD_LEVELS
  • MSD_LEVEL_ASSOCIATIONS
  • MSD_LEVEL_VALUES
  • MSD_LOCAL_ID_SETUP
  • MSD_MFG_FORECAST
  • MSD_NEW_PRODUCTS
  • MSD_ODPTIME
  • MSD_ORG_CALENDARS
  • MSD_PRICE_LIST
  • MSD_REASON_CODES
  • MSD_SALES_FORECAST
  • MSD_SALES_OPPORTUNITY_DATA
  • MSD_SCN_ENTRY_COMMENTS
  • MSD_SETUP_PARAMETERS
  • MSD_SHIPMENT_DATA
  • MSD_ST_BOOKING_DATA
  • MSD_ST_CS_DATA
  • MSD_ST_CURRENCY_CONVERSIONS
  • MSD_ST_EVENTS
  • MSD_ST_EVENT_PRODUCTS
  • MSD_ST_EVT_PRODUCT_DETAILS
  • MSD_ST_EVT_PROD_RELATIONSHIPS
  • MSD_ST_ITEM_LIST_PRICE
  • MSD_ST_LEVEL_ASSOCIATIONS
  • MSD_ST_LEVEL_VALUES
  • MSD_ST_MFG_FORECAST
  • MSD_ST_ORG_CALENDARS
  • MSD_ST_PRICE_LIST
  • MSD_ST_SALES_FORECAST
  • MSD_ST_SALES_OPPORTUNITY_DATA
  • MSD_ST_SETUP_PARAMETERS
  • MSD_ST_SHIPMENT_DATA
  • MSD_ST_TIME
  • MSD_ST_UOM_CONVERSIONS
  • MSD_TIME
  • MSD_UOM_CONVERSIONS

Oracle Demand Planning Forms

Oracle Demand Planning Forms

FORM SHORT CODE ORACLE FORM NAME
MSDDPEXS Demand Plan Express Setup
MSDDPHRS Demand Plan Hierarchies
MSDDPLNS Demand Plans
MSDDPPRS Demand Plan Parameters
MSDDPSCS Demand Plan Scenarios
MSDHIERS Hierarchies
MSDHRLVS Hierarchy Levels
MSDLEVLS Levels
MSDSTNPI Standard Events
MSDFPUSH Push Forecast
MSDLVVAL Demand Planning Level Values
MSDLVASC Demand Planning Level Associations
MSDCSCOL Custom Stream Collection/Pull
MSDCSDFN Define Data Stream
MSDCSDFA Custom Stream Advanced Setup
MSDCSIDN Define Data Stream Column Name
MSDAUDIT Audit Statements
MSDHUTIL Hierarchies and Levels Utilities
MSDDEMRH Returns History
MSDDEMNPI New Products List
MSDDEMCAL Demand Management Calendars
MSDDEMPRL Price Lists

Demand Planning Concurrent Programs

Oracle Demand Planning Concurrent Programs

CONCURRENT PROGRAM SHORT CODE CONCURRENT PROGRAM NAME
MSDPSD Pull Shipment Data
MSDPBD Pull Booking Data
MSDPCC Pull Currency Conversion Data
MSDPUC Pull UOM Conversion Data
MSDPMF Pull Manufacturing Forecast
MSDPSF Pull Sales Forecast
MSDPSO Pull Sales Opportunity Data
MSDPFD Pull Fact Data
MSDPTD Pull Time Data
MSDPLV Pull Level Values
MSDCSD Collect Shipment Data
MSDCBD Collect Booking Data
MSDCCC Collect Currency Conversion Data
MSDCUC Collect UOM Conversion Data
MSDCMF Collect Manufacturing Forecast
MSDCSF Collect Sales Forecast
MSDCSO Collect Sales Opportunity Data
MSDCFD Collect Fact Data
MSDCTD Collect Time Data
MSDCLV Collect Level Values
MSDORG Collect Organizations
MSDPSH Publish Forecast
MSDVALEALL Audit Statements Report
MSDDPVAL Demand Plan Validation Process
MSDXRCF Receive Forecast/History from Customer
MSDXPCF Publish Forecast to Customer
MSDCPD Collect Pricing Data
MSDPPD Pull Pricing Data
MSDPFCT Purge Fact Data
MSDPEV Pull Events Data
MSDPSTUP Push Seup Data to Source Instance
MSDPDP Demand Planning Setup Data Collect
MSDPDC Demand Planning Setup Data Pull
MSDVALE Run Audit Report
MSDFVAL Validate Fact Data
MSDDPPURGE Purge Demand Plan
MSDDPDEL Demand Plan Delete
MSDCSCL Custom Stream Collection/Pull Program
MSDBDP Oracle Demand Planning BOM Data Pull
MSDBDC Demand Planning BOM Data Collect
MSDBCP Demand Planning BOM Data Post Processing
MSDDPROL Demand Plan Rolling Process
MSDPUR Purge Interface Tables
MSDBGC Collect Time Data
MSDWFSTART Starts the Demand Planning Engine Master Workflow Process
MSDWFBG Runs a procedure to manage the use of wf_engine.background for DPE WF processes
MSDPPM Pre-Processor for Legacy data for DP
MSDLDM Launch Flat File Loaders for Data Upload into DP/ASCP Staging Table
MSDSUPSN Update Supersession Events
MSD_DISTRIBUTE Starts the Demand Planning Distribution to Assignments
MSDCGR This program is for suggesting composite grouping based on stream data.
MSDCLVEL Collect Level Values
MSDPLVEL Pull Level Values
MSDRESTORE Restore demand plan
MSDRLF Run Liability Flow
MSDARCHIVE Archive demand plan
MSDPLVSP Pull Level Values
MSDCLVSP Collect Level Values
MSDSPFD Pull S&OP Fact Data
MSDSCFD Collect S&OP Fact Data
MSD_SOP_MASTER S&OP Master Workflow Engine
MSDDEMRSCH Request Set for Collect Shipment and Booking History
MSDDEMLFD Request Set for Collect Shipment and Booking History – Flat File
MSDDEMLD Launch Flat File Loaders for Data Upload into Demantra Staging Table
MSDDEMSPR Collect Service Parts Return History
MSDDEMCSP Collect Returns History
MSDDEMCFS Collect Returns History
MSDDEMCSD Collect Data from Supply Chain Intelligence
MSDDEMRH Collect Returns History
MSDDEMPRL Collect Price Lists
MSDDEMCLT Collect Level Type
MSDDEMCIH Collect Returns History
MSDDEMCCONV Collect Currency Conversions
MSDDEMULC Update Level Codes
MSDDEMLOADS Self Service File Load
MSDDEMSDP Sales Data Pre Processor
MSDDEMPSP Push Setup Parameters
MSDDEMSCI Load Supply Chain Intelligence Data into Staging Tables.
MSDDEMARD Launch EP LOAD
MSDDEMRUNRS Flat File Load for Booking and Shipment History Legacy – Self Service
MSDDEMDC Download Calendars
MSDDEMDELPRL Delete Price Lists
MSDDEMUOM Collect UOM Conversions
MSDDEMCTD Collect Time
MSDDEMCHD Collect Shipment and Booking History
MSDDEMCSH Collect Shipment and Booking History
MSDDEMSPFLD Collect Service Parts Usage History – Field Service
MSDDEMCDR Collect Returns History
MSDSRPFLD Request Set for Collect SRP Streams – Flat File
MSDSRPFFLD Request Set for Collect SRP Streams through Flat File
MSDDEMRSPSP Request Set Stage Push Setup Parameters – Request Set Collect History
MSDDEMRSCHD Request Set Stage Collect History Data – Request Set Collect History
MSDDEMRSPST Request Set Stage Populate Staging Tables – Request Set Collect History
MSDDEMRSLH Request Set Stage Launch EP LOAD – Request Set Collect History
MSDSRPLD Launch Flat File Loaders for Data Upload into Tables
MSDDPTRUH Collect Depot Repair Usage History
MSDSRPLOADS Self Service File Load for SRP Streams
MSDSRPRUNRS Flat File Load for SRP Streams – Self Service
MSDAPN Assign Plan Name
MSDPCSD Purge Unused Custom Stream Data
MSDSRPPP SRP Data Pre Processor
MSDDEMUPDSYN Update Synonyms
MSDDEMCENTI Cleanup Entities Inuse
MSDDEMRSCSHB Request Set for Collect Shipment and Booking History (CTO)
MSDDEMRSCSBHFFCTO Request Set for Collect Shipment and Booking History – Flat File (CTO)
MSDDEMPCD Purge All Data from CTO GL Tables
MSDDEMCBD Collect Option Only BOM Data
MSDDEMPST Populate Staging Table
MSDDEMCMB Collect CTO Level Data
MSDDEMLPF Configure Legacy Profiles
MSDDEMULCC Update Location level codes from descriptive to number format.