You are browsing the archive for Oracle Inventory.

7.3 View Demand History

 

  • Form Application: Inventory
  • Form Name: INVDVFDH
  • Form Path: /oracle/apps/r12/visr12/apps/apps_st/appl/inv/12.0.0/forms/US/INVDVFDH.fmx

Demand History is used in forecast generation. Demand History is summarized form of historical demand. Demand can be summarized in to days, weeks or any periods. Concurrent program ‘summarize demand history’ consolidates the demand history. Using ‘View Demand History’ form you can view the compiled demand history.

Navigation: Inventory responsibility -> Planning -> Demand History

  • Enter the search criteria
    • Category Set
    • Category
    • Items From
    • Item To
    • Item Description
  • Click ‘FIND’
  • Output shows the compiled demand history
    • Item
    • Description
    • Unit of measure
    • Compiled bucket type – Day, week, period
  • Click on ‘History’ to see additional details

This is just view only screen and you can’t make any changes.

View Demand History

View Demand History

 

 

 

 

 

 

 

 

7.2 Compile Demand History

 

Compile Demand History generates the demand history based sales orders and other types of demand. Compiles demand history is used in forecast generation. Demand history can be consolidated into days, buckets or specific periods.

Navigation: Inventory responsibility -> Planning -> Compile Demand History.

Concurrent Request ‘Summarize Demand Histories‘ Opens up. Enter the parameters

  • Period Type: Days, Weeks, Buckets
  • Selection: All inventory items or specific item or specific category set / category
  • Specific Item: Enter specific item
  • Specific category Set: Enter specific category set
  • Specific Category: Specific category for which demand history will be compiled

Click ‘OK’ to submit the concurrent request. Once concurrent request completed open and view the compiled demand history

Compile Demand History

Compile Demand History

 

 

 

 

 

 

 

 

7.1 Generate Safety Stock Automatically

 

Safety Stocks are buffer inventory that is kept to meet any fluctuations in demand. Safety Stock can be system generated or manually entered. System generated safety stock can be based on percentage of total demand.

Navigation: Inventory responsibility -> Planning -> Safety Stock Update

Concurrent program ‘Reload Safety Stock’ opens up, enter the parameters.

  • Selection: Specific item or all items
  • Item: Enter item for specific item
  • Method: Safety stock calculation method
  • Forecast: Forecast that should be used for safety stock calculation
  • Category Set: Specific category set of that items to calculate safety stock
  • Safety Stock %: Percentage of safety stock
  • Service Level %: Percentage of service level
  • Starting Date: Effective date since safety stock is activated

Submit the request. Once concurrent request finishes you can view the calculated safety stocks by opening the safety stock screen.

Generate Safety Stock Automatically

Generate Safety Stock Automatically