You are browsing the archive for Concurrent Requests & Reports.

Update Level Codes

 

NAME: Update Level Codes
SHORT CODE: MSDDEMULC
MODULE: Oracle Demand Planning

Description: Update Level Codes
Navigation: Oracle Demand Planning Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • p_sr_instance_id : Instance
  • p_level : Level
  • p_dest_table_name : Destination Table Name
  • p_dest_column_name : Destination Column Name
  • p_src_column_name : Source Column Name

 

DP Pre-Processor

 

NAME: DP Pre-Processor
SHORT CODE: MSDPPM
MODULE: Oracle Demand Planning

Description: Pre-Processor for Legacy data for DP
Navigation: Oracle Demand Planning Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • p_instance_id : Instance
  • p_time_out : Time Out Duration (min)
  • p_batch_size : Batch Size
  • p_total_worker_num : Number of Workers
  • p_ascp_ins_dummy : p_ascp_ins_dummy
  • p_dummy1 : p_dummy4
  • p_dummy2 : p_dummy
  • p_cal_enabled : Process Manufacturing Calendars
  • p_dmd_class_enabled : Process Demand Class
  • p_tp_enabled : Process Trading Partners
  • p_list_price_enabled : Process Price List
  • p_ctg_enabled : Process Category Sets
  • p_item_enabled : Process Items
  • p_item_cat_enabled : Process Product Categories
  • p_rollup_dummy : p_cat_dummy
  • p_item_rollup : Roll up Item to Categories
  • p_bom_enabled : Process Bill of Materials
  • p_uom_enabled : Process Units of Measure
  • p_uom_conv_enabled : Process UOM Conversions
  • p_curr_conv_enabled : Process Currency Conversions
  • p_setup_paramters : Process Setup Parameters
  • p_fiscal_cal_enabled

 

Demand Planning Engine Master Workflow Process

 

NAME: Demand Planning Engine Master Workflow Process
SHORT CODE: MSDWFSTART
MODULE: Oracle Demand Planning

Description: Starts the Demand Planning Engine Master Workflow Process
Navigation: Oracle Demand Planning Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • DEMAND_PLAN_NAME : Demand Plan Name
  • NUMDAYS_TO_COLLECT : Number of days to run the Demand Planning Engine data collection
  • NUMDAYS_TO_DELAYUPLD : Number of days to delay Upload