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

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

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.