You are browsing the archive for ODP.

Demand Planning Profile Options

Oracle Demand Planning Profile Options:

PROFILE OPTION SHORT CODEPROFILE OPTION NAME
MSD_DEFAULT_DP_SCENARIOMSD: Default DP Scenario
MSD_EOL_CATEGORY_SET_NAMEMSD: Excess and Obsolescence, Liability Category Set Name
MSD_DEM_CONVERSION_TYPEMSD_DEM: Conversion Type
MSD_DEM_CURRENCY_CODEMSD_DEM: Currency Code
MSD_DEM_CUSTOMER_ATTRIBUTEMSD_DEM: Customer Attribute
MSD_DEM_DEBUG_MODEMSD_DEM: Debug Mode
MSD_CATEGORY_SET_NAMEMSD: Category Set Name
MSD_MASTER_ORGMSD: Master Org
MSD_CUSTOMER_ATTRIBUTEMSD: Customer Attribute
MSD_CONVERSION_TYPEMSD: Conversion Type
MSD_CURRENCY_CODEMSD: Currency Code
MSD_ONE_STEP_COLLECTIONMSD: One Step Collection
MSD_USER_INIT_PAGEPOOLMSD: OLAP Initial Page Pool
MSD_USER_MAX_PAGEPOOLMSD: OLAP Maximum Page Pool
MAX_WF_MAX_PAGEPOOLMSD: OLAP Workflow Page Pool
MSD_TWO_LEVEL_PLANNINGMSD: Two-Level Planning
MSD_DIR_ALIASMSD: OLAP Directory Alias
MSD_CLIENT_DEBUGGINGMSD: Client Debugging
MSD_DEM_TRUNCATE_STG_TABLEMSD_DEM: Truncate Staging Table
MSD_DEM_VERSIONMSD_DEM: Version
MSD_DEM_PLANNING_PERCENTAGEMSD_DEM: Calculate Planning Percentage
MSD_DEM_INCLUDE_DEPENDENT_DEMANDMSD_DEM: Include Dependent Demand
MSD_DEM_EXPLODE_DEMAND_METHODMSD_DEM: Explode Demand Method
MSD_DEM_SR_INSTANCE_FOR_GLOBAL_FCSTMSD_DEM: Source Instance for Global Forecast
MSD_DEM_SITE_CODE_FORMATMSD_DEM: Use new Site code format
VIEW_SCOPE_MEAS_EDITABLEMSD:View Scope measures are editable
MSD_DEM_CATEGORY_SET_NAMEMSD_DEM: Category Set Name
MSD_DEM_FISCAL_CALENDARMSD_DEM: Fiscal Calendar
MSD_DEM_MASTER_ORGMSD_DEM: Master Org
MSD_DEM_MAX_PRLMSD_DEM: Maximum seeded units available for price lists
MSD_DEM_PRICE_LIST_PROFILEMSD_DEM: Data Profile for Price Lists
MSD_DEM_SCHEMAMSD_DEM: Schema
MSD_DEM_TWO_LEVEL_PLANNINGMSD_DEM: Two-Level Planning
MSD_DEM_HOST_URLMSD_DEM: Host URL
MSD_USE_CLASSIC_WORKSHEETMSD: Use Classic Worksheet
MSD_USE_EVEN_ALLOCMSD: Use Classic Even Allocation
MSD_ITEM_ORGMSD: Enabled Organization for Item Collections
MSD_TABLESPACEMSD: AW Tablespace
MSD_PLANNING_PERCENTAGEMSD: Calculate Planning Percentages

Oracle Demand Planning Overview

Oracle Demand Planning (ODP) is a advanced forecasting module available as part of Advanced Planning & Scheduling (APS) suite. Oracle Demand Planning pulls the data from source ERP instance and does the forecasting. The final forecast output can be either be used as input to Advanced Supply Chain Planning (ASCP) or published back to source ERP instnace.

Demand Planning Cycle:

  • Data Collection: All the data needed for forecasting (items, boms, shipments, sales orders, safet stocks etc) can be imported from source ERP instance using standarad data collections programs supported by Oracle or can be imported from legacy systems through flat files.
  • Define demand plan: Demand Plan definition is the starting plan where scope of demand plan and expected outputs are defined.
  • Download demand planning data: In this step data relevant to the demand plan is downloaded into a shared database and systematic forecast is generated by system for further anaysis and updates.
  • Distribute to Planners: The generated forecast is distributed to multiple planners as for forecats review and further manual changes.
  • Creating and mofiying forecasts: Planners can view system generated forecast or they can generate their own versions of forecast, they can compare different variations of forecast.
  • Submit the forecast: Finally planner submits one of the forecasts he generated as final forecast.
  • Review forecast: Demand plan manager collects the individual forecasts submitted by planners and consolidates into one final forecast. Deman plan manager have the authority to make any final changes to forecast.
  • Upload and publish: Demand plan manager uploads the final forecast into demand planning server and later either this will be consumed by oracle ASCP or published to source instance.