Orchestrate Refresh Measures Processes

Use the Orchestrate Refresh Measures Processes scheduled process to refresh data for collected measures in a plan without actually running the plan.

When to Use

These use cases are applicable to the Orchestrate Refresh Measures Processes process:

  • Refreshing a subset of collected measures in your supply chain plans, including shipments and bookings history, sales and marketing forecasts, and financial measures such as such as Budget Value and Financial Forecast Value. This process retains measure data for statistical and simulation demand forecasts that are normally purged when running your plan to refresh with current data.
  • As part of a weekly demand planning cycle where you generate a baseline, statistical forecast once a week but need to get daily updates for recent shipments (or bookings) and the latest sales forecast.
  • The scheduled process considers measures loaded using file-based data import (FBDI) templates for Oracle Fusion Cloud Supply Chain Planning:
    • Supply Chain Planning Measures
    • Supply Chain Planning Shipments History
    • Supply Chain Planning Bookings History
    • Supply Chain Planning Option Shipments History
    • Supply Chain Planning Option Bookings History

Typically, this job is submitted as part of an integrated job set. For example, collect measure data from files, refresh plan measures, then generate measure-based exceptions in the plan.

Privileges Required

  • Run Plan with Snapshot (MSC_RUN_PLAN_WITH_SNAPSHOT_PRIV)

Specifications

Review these specifications before setting up this scheduled process:

Specification Description
Job Type Scheduled as part of an integrated job set is recommended, but it can be submitted on a spontaneous basis if required.
Frequency Frequency depends on the business requirement but typically daily.
Time of Day After work hours is recommended, but it can be submitted any time based on your requirements. It’s recommended not to use the target plan while this process runs.
Duration Duration depends on plan size, the number of measures in the measure catalog, and the level at which measure data is collected. For example, if measure data is collected at aggregate levels, then the process could take longer to disaggregate data to lower levels. Expect the process to run for minutes. See the Troubleshooting section for tips on increasing performance.
Compatibility There should be only one instance of the job running at any time on the plan.

Parameters

Parameter Optional or Required Description Parameter Value Special Combinations Required Notes
Plan Required Select a plan name. Valid plan name. N/A Plans that haven’t run or with error status are excluded.
Measure Catalog Optional Select a measure catalog that contains a subset of collected plan measures. Valid measure catalog. N/A Don’t use a plan’s measure catalog.

Troubleshooting Information

  • You can view the status of the Orchestrate Refresh Measures Processes job in the Scheduled Processes work area.
  • When the program is submitted, you can Cancel Process as provided by the Scheduled Processes work area.
  • See the log file attached to the Refresh Collected Plan Measures child process for details, including warning and error messages.
  • Check plan status in Manage Plans if the plan to refresh doesn’t appear.
  • The Measure Catalog parameter is optional, but should reference a catalog with a subset of plan measures. Don’t use the plan’s measure catalog because it contains many measures that aren’t applicable to this process and will decrease process performance.
  • Include both the Shipments History (or Bookings History) measure and the default measure used to refresh Shipments History in your measure catalog such as:
    • Shipments History + Shipments History: Requested Item by Shipped Date
    • Bookings History + Bookings History: Booked Item by Booked Date
  • Configure the enableParallelDisaggMeasure parameter in either the SCP_PARAMETER_OVERRIDES profile option or in plan options to increase disaggregation performance for this process.
  • Use REST services, not the Orchestrate Refresh Measures Processes job, to update editable measures.
  • New products aren’t added to a plan or price lists refreshed when this process runs. You need to run the plan with data refresh to update plan items and price list data.
  • When introducing a new loaded measure to a plan, you must first run the plan to refresh with current data before you can refresh that measure's data using this scheduled process.
  • Plans created by referring to and copying a base plan can't be refreshed.
  • If the reason for errors isn’t clear from the log or you need help with process performance, contact product support.