You are browsing the archive for ODP.

Demand Planning Profile Options

Oracle Demand Planning Profile Options:

PROFILE OPTION SHORT CODE PROFILE OPTION NAME
MSD_DEFAULT_DP_SCENARIO MSD: Default DP Scenario
MSD_EOL_CATEGORY_SET_NAME MSD: Excess and Obsolescence, Liability Category Set Name
MSD_DEM_CONVERSION_TYPE MSD_DEM: Conversion Type
MSD_DEM_CURRENCY_CODE MSD_DEM: Currency Code
MSD_DEM_CUSTOMER_ATTRIBUTE MSD_DEM: Customer Attribute
MSD_DEM_DEBUG_MODE MSD_DEM: Debug Mode
MSD_CATEGORY_SET_NAME MSD: Category Set Name
MSD_MASTER_ORG MSD: Master Org
MSD_CUSTOMER_ATTRIBUTE MSD: Customer Attribute
MSD_CONVERSION_TYPE MSD: Conversion Type
MSD_CURRENCY_CODE MSD: Currency Code
MSD_ONE_STEP_COLLECTION MSD: One Step Collection
MSD_USER_INIT_PAGEPOOL MSD: OLAP Initial Page Pool
MSD_USER_MAX_PAGEPOOL MSD: OLAP Maximum Page Pool
MAX_WF_MAX_PAGEPOOL MSD: OLAP Workflow Page Pool
MSD_TWO_LEVEL_PLANNING MSD: Two-Level Planning
MSD_DIR_ALIAS MSD: OLAP Directory Alias
MSD_CLIENT_DEBUGGING MSD: Client Debugging
MSD_DEM_TRUNCATE_STG_TABLE MSD_DEM: Truncate Staging Table
MSD_DEM_VERSION MSD_DEM: Version
MSD_DEM_PLANNING_PERCENTAGE MSD_DEM: Calculate Planning Percentage
MSD_DEM_INCLUDE_DEPENDENT_DEMAND MSD_DEM: Include Dependent Demand
MSD_DEM_EXPLODE_DEMAND_METHOD MSD_DEM: Explode Demand Method
MSD_DEM_SR_INSTANCE_FOR_GLOBAL_FCST MSD_DEM: Source Instance for Global Forecast
MSD_DEM_SITE_CODE_FORMAT MSD_DEM: Use new Site code format
VIEW_SCOPE_MEAS_EDITABLE MSD:View Scope measures are editable
MSD_DEM_CATEGORY_SET_NAME MSD_DEM: Category Set Name
MSD_DEM_FISCAL_CALENDAR MSD_DEM: Fiscal Calendar
MSD_DEM_MASTER_ORG MSD_DEM: Master Org
MSD_DEM_MAX_PRL MSD_DEM: Maximum seeded units available for price lists
MSD_DEM_PRICE_LIST_PROFILE MSD_DEM: Data Profile for Price Lists
MSD_DEM_SCHEMA MSD_DEM: Schema
MSD_DEM_TWO_LEVEL_PLANNING MSD_DEM: Two-Level Planning
MSD_DEM_HOST_URL MSD_DEM: Host URL
MSD_USE_CLASSIC_WORKSHEET MSD: Use Classic Worksheet
MSD_USE_EVEN_ALLOC MSD: Use Classic Even Allocation
MSD_ITEM_ORG MSD: Enabled Organization for Item Collections
MSD_TABLESPACE MSD: AW Tablespace
MSD_PLANNING_PERCENTAGE MSD: 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.