Enable Receipt-Based Forecasting
A typical healthcare supply chain has several Periodic Automatic Replenishment (PAR) inventory locations where inventory isn’t tracked. However, at these PAR locations, receipt transactions are tracked. To accurately forecast and understand the requirement at these PAR locations, receipts are used as a proxy for usage or consumption information.
With this update, historical receipt transactions are collected from Oracle Fusion Cloud Inventory Management and used to generate a receipt-based forecast. The receipt-based forecast is then used as input to generate the PAR inventory levels. Additionally, a new forecast profile is seeded to smooth the demand when receipts are intermittent and to reflect a more reasonable mean absolute percent error (MAPE) value.
The existing Collect Planning Data process has been enhanced to provide the ability to collect receipts history from Oracle Fusion Cloud Inventory Management for both organizations and subinventories. Two new check boxes are now available for this process:
- Collect receipts history for organizations
- Collect receipts history for subinventories
Collect Planning Data Page with New Check Boxes
The date range for collection of receipts is determined by your choices in the Collection Time Frame Options section.
Three new measures have been provided related to the collection of receipts:
- Receipts History: This measure is populated by the collection process when receipt history is collected for organizations and/or subinventories.
- Adjusted Receipts History: This is an editable measure for planners to make manual overrides to the collected receipt history.
- Final Receipts History: This is a calculated measure that returns the Adjusted Receipts History measure value if one exists and otherwise returns the Receipts History measure value.
A new forecasting profile, named Forecast Receipts, has been provided to forecast receipts.
Forecast Receipts Forecasting Profile
This forecasting profile takes the Final Receipts History measure as input and outputs the resulting forecast to a new measure named Receipts Forecast.
This forecasting profile has all intermittent forecast models enabled in order to account for the typically irregular occurrence of receipts.
In addition to the new Receipts Forecast measure, several new measures have been provided related to the forecasting of receipts. These include:
- Adjusted Receipts Forecast: An editable measure for planners to make manual overrides to the generated receipt forecast using a quantity value.
- Adjusted Receipts Forecast Percentage: An editable measure for planners to make manual overrides to the generated receipt forecast using a percentage.
- Final Receipts Forecast: A calculated measure that returns the receipts forecast after applying adjustments made using the Adjusted Receipts Forecast and Adjusted Receipts Forecast Percentage measure values.
- Forecast accuracy metrics: Receipts Forecast MAD, Receipts Forecast MAPE, and Receipts Forecast Bias.
For a complete list of receipts history and forecasting measures, refer to the measure group named Receipts-Based Forecasting.
Steps to Enable
Use the Opt In UI to enable this feature. For instructions, refer to the Optional Uptake of New Features section of this document.
Offering: Supply Chain Planning
Tips And Considerations
If you want to use the Enable Receipt-Based Forecasting feature, then you must opt in to its parent feature: Replenishment Planning. If you’ve already opted in to this parent feature, then you don’t have to opt in again.
Receipts are collected for only items with a planning method of Replenishment Planning.
When collecting receipts for subinventories, receipts are collected for only subinventories that belong to organizations that are enabled for subinventory planning.
The new Receipts History measure is dimensioned by Item, Organization, Customer Site, Demand Class, Sales Representative, and Day. Receipts captured in Oracle Fusion Cloud Inventory Management aren’t associated with a customer site or demand class. As such, when receipt history is collected, the Customer Site and Demand Class levels are populated with a -1 value which appears as Unassigned when viewed in the application.
The following table lists the transactions from Oracle Fusion Cloud Inventory Management that are collected into the Receipts History measure when the Collect receipts history for organizations option is selected.
Transaction Action |
Transaction Source |
Transaction Type |
---|---|---|
Receipt into Stores |
Account |
Account Receipt |
Receipt into Stores |
Account Alias |
Account Alias Receipt |
Receipt into Stores |
Inventory |
Miscellaneous Receipt |
Receipt into Stores |
Movement Request |
Movement Request Put Away |
Receipt into Stores |
Purchase Order |
Purchase Order Receipt |
Direct Organization Transfer |
Inventory |
Direct Organization Transfer |
In-transit receipt |
Inventory |
Intransit Receipt |
In-transit receipt |
Transfer Order |
Transfer Order Interorganization Receipt |
The following table lists the transactions from Oracle Fusion Cloud Inventory Management that are collected into the Receipts History measure when the Collect receipts history for subinventories option is selected.
Transaction Action |
Transaction Source |
Transaction Type |
---|---|---|
Receipt into Stores |
Account |
Account Receipt |
Receipt into Stores |
Account Alias |
Account Alias Receipt |
Receipt into Stores |
Inventory |
Miscellaneous Receipt |
Receipt into Stores |
Movement Request |
Movement Request Put Away |
Receipt into Stores |
Purchase Order |
Purchase Order Receipt |
Subinventory transfer |
Inventory |
Subinventory Transfer |
Subinventory transfer |
Movement Request |
Movement Request Transfer |
Subinventory transfer |
Transfer Order |
Transfer Order Intraorganization Transfer |
Direct Organization Transfer |
Inventory |
Direct Organization Transfer |
In-transit receipt |
Inventory |
Intransit Receipt |
In-transit receipt |
Transfer Order |
Transfer Order Interorganization Receipt |
Intraorganization in-transit receipt |
Transfer Order |
Transfer Order Intraorganization Receipt |
Access Requirements
There are no new roles or security privileges needed to access this feature.
- Users who currently have access to Collect Planning Data will automatically be able to use this feature.
Users who are assigned a configured job role that contains these privileges can access this feature:
- Collect Planning Hierarchies Data (MSC_COLLECT_PLANNING_HIERARCHIES_DATA_PRIV)
- Collect Planning Reference Data (MSC_COLLECT_PLANNING_REFERENCE_DATA_PRIV)
- Collect Planning Transaction Data (MSC_COLLECT_PLANNING_TRANSACTION_DATA_PRIV)
These privileges were available prior to this update.