You are browsing the archive for Oracle Demand Planning.

Custom Stream Collection/Pull Program

 

NAME: Custom Stream Collection/Pull Program
SHORT CODE: MSDCSCL
MODULE: Oracle Demand Planning

Description: Custom Stream Collection/Pull Program
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_collection_type : Collection Type
  • p_validate_data : Validate Data
  • p_definition_id : Custom Stream Definition ID
  • p_cs_name : Stream Name
  • p_comp_refresh : Complete Refresh
  • p_instance_id : Instance ID
  • p_parameter1 : Parameter 1
  • p_parameter2 : Parameter 2
  • p_parameter3 : Parameter 3
  • p_parameter4 : Parameter 4
  • p_parameter5 : Parameter 5
  • p_parameter6 : Parameter 6
  • p_parameter7 : Parameter 7
  • p_parameter8 : Parameter 8
  • p_parameter9 : Parameter 9
  • p_parameter10 : Parameter 10

 

Collect Time

 

NAME: Collect Time
SHORT CODE: MSDDEMCTD
MODULE: Oracle Demand Planning

Description: Collect Time
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_auto_run_download : Launch Download

 

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