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 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 may 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.