Prepare Supply Chain Planning Data for Export
The Prepare Supply Chain Planning Data for Export scheduled process extracts plan output data related to analytics into a set of files for external reporting and analysis.
The following plan types use this scheduled process:
- Supply Plan
- Demand and Supply Plan
- Replenishment Plan
- Sales and Operations Plan
- Demand Plan
The extract process exports plan data to Oracle WebCenter Content in a comma-separated values (CSV) data format. The extract is based on the measure catalog and dimension catalog assigned to the plan, and includes user-defined hierarchies and levels.
When to Use
When analyzing a plan, you can extract detailed supply-chain-planning multidimensional plan output data, including measures and hierarchies.
The extract is based on the extract-measure and dimension catalogs assigned to the plan. This extract contains measure data, which include any measures that you configured that are either stored or calculated. For calculated measures, the planning process extracts the data after evaluating the measure expressions.
Privileges Required
- Prepare Supply Chain Planning Data for Export (MSC_EXTRACT_PLANNING_DATA_PRIV)
Specifications
Review these specifications before setting up this scheduled process:
| Specification | Description |
| Duration | Typically, less than two minutes when run independently. However, expected completion time depends on performance of the sequence of jobs executing in the queue before the job. |
| Compatibility | There should be only one instance of the job running at any time, and there’s no current functional need to run multiple instances of this process simultaneously. |
Parameters
| Parameter | Optional or Required | Description | Parameter Value | Notes |
| Plan Name | Required | Select the plan name for which the Prepare Supply Chain Planning Data Export scheduled process needs to be performed. | A valid plan name | Only one plan name is defined for each job. |
Troubleshooting Information
- To improve the performance, ensure the extract measure catalog contains only the required measures.
- You can view the status of the Prepare Supply Chain Planning Data for Export process in the Scheduled Processes work area.
- The validation errors and warning messages that prevented the Prepare Supply Chain Planning Data for Export scheduled process from completing display in the error log.
- Any interactive warning validations are not performed.
- After you submit the scheduled process, you can perform any of these tasks in the
Scheduled Processes work area:
- Resubmit it
- Put it on hold
- Cancel the process
- Release the process