You are browsing the archive for Oracle Demand Planning.

Collect Returns History

 

NAME: Collect Returns History
SHORT CODE: MSDDEMRH
MODULE: Oracle Demand Planning

Description: Collect Returns History
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_collection_group : Collection Group
  • p_collection_method : Collection Method
  • p_date_range_type : Date Range Type
  • p_collection_window : History Collection Window
  • p_from_date : Date From
  • p_to_date : Date To
  • p_entity_name : p_entity_name

 

Flat File Loader

 

NAME: Flat File Loader
SHORT CODE: MSDLDM
MODULE: Oracle Demand Planning

Description: Launch Flat File Loaders for Data Upload into DP/ASCP Staging Table
Navigation: Oracle Demand Planning Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • Instance : Instance
  • pTIMEOUT : Time Out Duration (min)
  • pPathSeparator : File Path Separator
  • pCtlPath : Control File’s Directory
  • pDirectoryPath : Data File’s Directory
  • pTotalWorkerNum : Total Number of Workers
  • pCalendars : File Name: Calendar
  • pWorkdayPatterns : File Name: Workday Patterns
  • pShiftTimes : File Name: Shift Times
  • pCalendarExceptions : File Name: Calendar Exceptions
  • pShiftExceptions : File Name: Shift Exceptions
  • pDemandClass : File Name: Demand Classes
  • pTradingPartners : File Name: Trading Partners
  • pTradingPartnerSites : File Name: Trading Partner Sites
  • pPriceList : File Name: Price List
  • pCategorySets : File Name: Category Sets
  • pItems : File Name: Items
  • pItemCategories : File Name: Product Category
  • pBomHeaders : File Name: Bill of Material Headers
  • pBomComponents : File Name: Bill of Material Components

 

SRP Data Post Processor

 

NAME: SRP Data Post Processor
SHORT CODE: MSDSRPPP
MODULE: Oracle Demand Planning

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

Report Parameters:

  • pInstance : Instance
  • pStream : Type of Stream