You are browsing the archive for Oracle Inventory.

7.6 Generate Forecast Automatically

 

  • Application: Master Scheduling/MRP
  • Program Name: INCFIF

Forecasts are used to forecast future demand (typically sales orders). By using forecasts any business can plan and manufacture goods. Once sales order is received from customer it can be shipped from stock with less turnaround time. There are various forecasting models available to generate the forecasts automatically based on history. Having predictable history information is crucial for identifying right forecast model and generating forecasting. Forecasting can be done manually using people’s expert knowledge of history or automatically generated. In this tutorial you will learn on how to generate forecast automatically.

Navigation: Inventory responsibility -> Planning -> Forecasts -> Generate

Concurrent program ‘Generate Forecast’ opens up. Enter the parameters

  • Forecast: Select the forecast name. Forecast must be defined first
  • Forecast Rule: Select the Forecast rule. Rules supported by oracle are
    • Focus forecast by day
    • Focus forecast by week
    • Focus forecast by period
    • Monthly
    • Seasonal forecast
  • Selection: Choose – All inventory items, specific item, specific category set or specific category
  • Specific Item: To limit forecast generation for one item enter the item
  • Specific Category set: To limit forecast generation to a category set, enter here
  • Specific Category: To limit forecast generation to a specific category, enter here
  • Overwrite: Choose YES or NO whether to over write the existing forecast or add new forecast
  • Start date: Beginning date of forecast
  • Cutoff Date: Last date of forecast

Click ‘Submit’ to submit the concurrent program. Once concurrent program completed normal, open the forecast you generated to view the results.

Generate Forecast Automatically

Generate Forecast Automatically

 

 

 

 

 

 

 

 

7.5 Enter Forecast Manually

 

  • Form Application: Master Scheduling/MRP
  • Form Name: MRPFFDIF
  • Form Path: /oracle/apps/r12/visr12/apps/apps_st/appl/mrp/12.0.0/forms/US/MRPFFDIF.fmx

Forecast is used to forecast future demand, so that any business can prepare its business plans against it. Accurate forecasting will help in reducing lead times to ship the goods once sales order is received. Forecasts are grouped into forecast sets. Forecasts can be consumed against original sales order once it is received from customer.

Navigation: Inventory responsibility -> Planning -> Forecasts -> Entries

  • Query the ‘Forecast Set’ / ‘Forecast’ name
  • Enter ‘Item’ to which forecast is entered
  • Select the Bucket as ‘Days/Weeks/Periods’
  • Enter the date on which forecast is entered. If bucket is week or period then date will start date of week or bucket
  • Enter ‘end date’ optionally to inactive the forecast
  • Enter the current ‘Quantity’ i.e. forecast quantity

Save the changes

Enter Forecast Manually

Enter Forecast Manually

 

 

 

 

 

 

 

7.4 Create Forecast Sets

 

  • Form Application: Master Scheduling/MRP
  • Form Name: MRPFFDIF
  • Form Path: /oracle/apps/r12/visr12/apps/apps_st/appl/mrp/12.0.0/forms/US/MRPFFDIF.fmx

Forecast Sets consists of group of forecasts, forecast set is mandatory to before any forecast can be created. Forecasts are used to forecast sales volumes (usually by product/item, date/period and quantity of forecast). Forecast is used as input in supply chain planning to plan the supply to meet the forecast demand. Once actual sales order is received from customer you can ship in no time as you already manufactured/procured material against your forecast.

Navigation: Inventory responsibility -> Planning -> Forecasts -> Sets

  • Enter ‘Forecast Set’ name
  • Enter ‘Description’ of forecast set
  • Select ‘Bucket Type’ as Days or Weeks or Period. When you select date, any forecast you entered is specific to that, when you select week this implies any forecast entered in specific to that entire week, similarly is pre-defined period.
  • Select level as ‘Item’ or ‘Category’. Forecast can be at item level or category level.
  • Optionally enter ‘Inactive date’ to end date a forecast set.
  • Enter forecast consumption options (i.e. rules for to consume forecast when a real sales order comes).
    • Consume – Check or Uncheck
    • Outlier Update – in percentage (%)
    • Backward days – No. of days backward to consume
    • Forward days – No. of days forward to consume
  • Enter ‘Forecast’ name. Forecast set is always consists of forecasts. Forecast is always entered against a forecast.
  • Enter ‘Forecast description’
  • Enter ‘Inactive Date’
  • Enter ‘Demand Class’ to which this forecast belongs. This is optional but helps in consuming with correct sales orders of same demand class.

Save the changes. New forecast set and along with forecasts it is associated are saved.

Create Forecast Set

Create Forecast Set