Reduce the Time to Copy Data Between Measures

During your business process, you may sometimes need to copy measure data from one plan to another or within a plan using the REST resource named Load Measures Jobs. In this update, the REST resource, which is a child of the REST resource named Supply Chain Plans, includes a filter to copy measure data for a subset of the plan. Additionally, multiple jobs can be run in parallel. You can use these enhancements to reduce the overall time of the copy by configuring multiple subsets to be run at the same time.

Copying a Subset

Follow these steps to copy measure data for a subset of your plan:

  1. For a combination of a source plan and a target plan, create a measure copy set using the page for the functionality for loading measures from other plans.

The source and target plans can be the same.

  1. Create a table with the required member filter.

This table will be used to filter the source measure for which you created the measure copy set.

  1. Find the ID for the target plan by running this SQL query:

SELECT plan_id AS target_plan_id, compile_designator
FROM fusion.msc_plan_definitions
WHERE compile_designator LIKE '%your_target_plan_name%';
  1. Configure your REST resource call to use the POST method as follows:
/fscmRestApi/resources/11.13.18.05/supplyChainPlans/target_plan_id/child/LoadMeasuresJobs
  1. Include the TableName parameter in the request body in the JavaScript Object Notation (JSON) format, and set the parameter to the name of the table that you created as a filter. For example, see the following:
{
"FromPlanName": "source plan name",
"MeasureCopySetName": "copyset name",
“CreateNewCombFlag”: true,
"TimeLevelRangeStart": -6,
"TimeLevelRangeEnd": 12,
"TableName": "filter table name"
}

Concurrent Copying

To copy a measure concurrently (in parallel), you need to define several filter tables as previously explained. These filter tables, when taken together, need to cover the entire member population you wish to copy. You must also make sure that the filters don’t cover the same members. You will call the REST resource once for each of the filter tables.

For example, you can define three filter tables, each covering a third of the member population that you want to copy, and you will call the REST resource three times, once for each table.

Steps to Enable

You don't need to do anything to enable this feature.

Tips And Considerations

Concurrent calls to the REST resource named Load Measures Jobs shouldn’t copy the same rows of data. The filter tables mustn’t cover the same members. Otherwise, you’ll get a deadlock error from the database.

Key Resources

  • For information on the REST resource named Load Measures Jobs, see the guide named REST API for Oracle Fusion Cloud SCM.

Access Requirements

Users who are assigned a configured job role that contains this privilege can access this feature:

  • Load Measure Data from Other Plans (MSC_LOAD_MEASURES_FROM_OTHER_PLANS_PRIV)

This privilege was available prior to this update.

The access requirements for the REST resource named Load Measures Jobs haven’t been changed.