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 CODEORACLE FORM NAME
MSDDPEXSDemand Plan Express Setup
MSDDPHRSDemand Plan Hierarchies
MSDDPLNSDemand Plans
MSDDPPRSDemand Plan Parameters
MSDDPSCSDemand Plan Scenarios
MSDHIERSHierarchies
MSDHRLVSHierarchy Levels
MSDLEVLSLevels
MSDSTNPIStandard Events
MSDFPUSHPush Forecast
MSDLVVALDemand Planning Level Values
MSDLVASCDemand Planning Level Associations
MSDCSCOLCustom Stream Collection/Pull
MSDCSDFNDefine Data Stream
MSDCSDFACustom Stream Advanced Setup
MSDCSIDNDefine Data Stream Column Name
MSDAUDITAudit Statements
MSDHUTILHierarchies and Levels Utilities
MSDDEMRHReturns History
MSDDEMNPINew Products List
MSDDEMCALDemand Management Calendars
MSDDEMPRLPrice Lists

Demand Planning Concurrent Programs

Oracle Demand Planning Concurrent Programs

CONCURRENT PROGRAM SHORT CODECONCURRENT PROGRAM NAME
MSDPSDPull Shipment Data
MSDPBDPull Booking Data
MSDPCCPull Currency Conversion Data
MSDPUCPull UOM Conversion Data
MSDPMFPull Manufacturing Forecast
MSDPSFPull Sales Forecast
MSDPSOPull Sales Opportunity Data
MSDPFDPull Fact Data
MSDPTDPull Time Data
MSDPLVPull Level Values
MSDCSDCollect Shipment Data
MSDCBDCollect Booking Data
MSDCCCCollect Currency Conversion Data
MSDCUCCollect UOM Conversion Data
MSDCMFCollect Manufacturing Forecast
MSDCSFCollect Sales Forecast
MSDCSOCollect Sales Opportunity Data
MSDCFDCollect Fact Data
MSDCTDCollect Time Data
MSDCLVCollect Level Values
MSDORGCollect Organizations
MSDPSHPublish Forecast
MSDVALEALLAudit Statements Report
MSDDPVALDemand Plan Validation Process
MSDXRCFReceive Forecast/History from Customer
MSDXPCFPublish Forecast to Customer
MSDCPDCollect Pricing Data
MSDPPDPull Pricing Data
MSDPFCTPurge Fact Data
MSDPEVPull Events Data
MSDPSTUPPush Seup Data to Source Instance
MSDPDPDemand Planning Setup Data Collect
MSDPDCDemand Planning Setup Data Pull
MSDVALERun Audit Report
MSDFVALValidate Fact Data
MSDDPPURGEPurge Demand Plan
MSDDPDELDemand Plan Delete
MSDCSCLCustom Stream Collection/Pull Program
MSDBDPOracle Demand Planning BOM Data Pull
MSDBDCDemand Planning BOM Data Collect
MSDBCPDemand Planning BOM Data Post Processing
MSDDPROLDemand Plan Rolling Process
MSDPURPurge Interface Tables
MSDBGCCollect Time Data
MSDWFSTARTStarts the Demand Planning Engine Master Workflow Process
MSDWFBGRuns a procedure to manage the use of wf_engine.background for DPE WF processes
MSDPPMPre-Processor for Legacy data for DP
MSDLDMLaunch Flat File Loaders for Data Upload into DP/ASCP Staging Table
MSDSUPSNUpdate Supersession Events
MSD_DISTRIBUTEStarts the Demand Planning Distribution to Assignments
MSDCGRThis program is for suggesting composite grouping based on stream data.
MSDCLVELCollect Level Values
MSDPLVELPull Level Values
MSDRESTORERestore demand plan
MSDRLFRun Liability Flow
MSDARCHIVEArchive demand plan
MSDPLVSPPull Level Values
MSDCLVSPCollect Level Values
MSDSPFDPull S&OP Fact Data
MSDSCFDCollect S&OP Fact Data
MSD_SOP_MASTERS&OP Master Workflow Engine
MSDDEMRSCHRequest Set for Collect Shipment and Booking History
MSDDEMLFDRequest Set for Collect Shipment and Booking History – Flat File
MSDDEMLDLaunch Flat File Loaders for Data Upload into Demantra Staging Table
MSDDEMSPRCollect Service Parts Return History
MSDDEMCSPCollect Returns History
MSDDEMCFSCollect Returns History
MSDDEMCSDCollect Data from Supply Chain Intelligence
MSDDEMRHCollect Returns History
MSDDEMPRLCollect Price Lists
MSDDEMCLTCollect Level Type
MSDDEMCIHCollect Returns History
MSDDEMCCONVCollect Currency Conversions
MSDDEMULCUpdate Level Codes
MSDDEMLOADSSelf Service File Load
MSDDEMSDPSales Data Pre Processor
MSDDEMPSPPush Setup Parameters
MSDDEMSCILoad Supply Chain Intelligence Data into Staging Tables.
MSDDEMARDLaunch EP LOAD
MSDDEMRUNRSFlat File Load for Booking and Shipment History Legacy – Self Service
MSDDEMDCDownload Calendars
MSDDEMDELPRLDelete Price Lists
MSDDEMUOMCollect UOM Conversions
MSDDEMCTDCollect Time
MSDDEMCHDCollect Shipment and Booking History
MSDDEMCSHCollect Shipment and Booking History
MSDDEMSPFLDCollect Service Parts Usage History – Field Service
MSDDEMCDRCollect Returns History
MSDSRPFLDRequest Set for Collect SRP Streams – Flat File
MSDSRPFFLDRequest Set for Collect SRP Streams through Flat File
MSDDEMRSPSPRequest Set Stage Push Setup Parameters – Request Set Collect History
MSDDEMRSCHDRequest Set Stage Collect History Data – Request Set Collect History
MSDDEMRSPSTRequest Set Stage Populate Staging Tables – Request Set Collect History
MSDDEMRSLHRequest Set Stage Launch EP LOAD – Request Set Collect History
MSDSRPLDLaunch Flat File Loaders for Data Upload into Tables
MSDDPTRUHCollect Depot Repair Usage History
MSDSRPLOADSSelf Service File Load for SRP Streams
MSDSRPRUNRSFlat File Load for SRP Streams – Self Service
MSDAPNAssign Plan Name
MSDPCSDPurge Unused Custom Stream Data
MSDSRPPPSRP Data Pre Processor
MSDDEMUPDSYNUpdate Synonyms
MSDDEMCENTICleanup Entities Inuse
MSDDEMRSCSHBRequest Set for Collect Shipment and Booking History (CTO)
MSDDEMRSCSBHFFCTORequest Set for Collect Shipment and Booking History – Flat File (CTO)
MSDDEMPCDPurge All Data from CTO GL Tables
MSDDEMCBDCollect Option Only BOM Data
MSDDEMPSTPopulate Staging Table
MSDDEMCMBCollect CTO Level Data
MSDDEMLPFConfigure Legacy Profiles
MSDDEMULCCUpdate Location level codes from descriptive to number format.