Extract Plan Data
Use the Extract Plan Data scheduled process to export plan data to Oracle Universal Content Management in the comma-separated value (CSV) data format.
When to Use
Use the Extract Plan Data scheduled process to extract detailed Oracle Fusion Cloud Supply Chain Planning multidimensional plan output data, including measures and hierarchies. The extract is based on the measure and dimension catalogs assigned to the plan. The extract includes measure data, including 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
- Extract Planning Data (MSC_EXTRACT_PLANNING_DATA_PRIV)
Specifications
Review these specifications before setting up this scheduled process:
Specification | Description |
Job Type | Can be run at any time or as a scheduled job. |
Frequency | Can be run as needed. |
Time of Day | Can be run as needed. |
Duration | Depends on the size of the selected plan and its associated plan options for extracting. |
Compatibility | No incompatibility. |
Parameters
Parameter | Optional or Required | Description | Parameter Value | Special Combinations Required | Notes |
Plan | Required | Name of plan to extract data from. | Plan Name | None | NA |
Extract Binary Large Objects | Boolean parameter. | None | The engine binary files are extracted if the Boolean parameter is set to 1. |
Troubleshooting Information
- It's recommended that you don't run or copy the same plan. Otherwise, you might get incomplete files.
- You can view the status of the Extract Plan operation in the Scheduled Processes work area.
- The validation errors and warning messages that prevented the Extract Plan scheduled process from completing display in the error log.
- Interactive warning validations aren't 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
- If the job fails:
- Review the error messages in the log file.
- If the reason for the failure isn’t clear from the logs, review the diagnostic logs and contact product support for more help.