Extract Data Load Errors

Use the Extract Data Load Errors scheduled process to extract error messages from failed records when loading CSV files with the Load Planning Data from Files scheduled process.

The process is applicable to these products:

• Supply Planning
• Demand and Supply Planning
• Demand Planning
• Replenishment Planning
• Global Order Promising
• Backlog Management

When to Use

Use the process when you want to extract error messages from failed records when loading CSV files with the Load Planning Data from Files scheduled process.

The Load Planning Data from Files scheduled process status will display either a warning or an error, which indicates that you must run the Extract Data Load Errors scheduled process to extract messages to review.

Privileges Required

• Perform Order Orchestration and Planning Data Collection (MSP_PERFORM_ORDER_ORCHESTRATION_AND_PLANNING_DATA_COLLECTION_PRIV)

Specifications

Review these specifications before setting up this scheduled process:

Specification	Description
Job Type	Ad hoc job, but can be scheduled based on requirements.
Frequency	When required, on an as-needed basis.
Time of Day	After work hours is preferred. It's recommended that you run the job after the Load Planning Data from Files scheduled process finishes.
Duration	Typically, a few minutes. However, the time might vary across processes based on data and other conditions.
Compatibility	There should be only one instance of the job running at any one time for a specific collection cycle ID.

Parameters

Parameter	Optional or Required	Description	Parameter Value	Special Combinations Required	Notes
Collection Cycle ID	Required	The refresh number from the load-entity log file of any entity’s collection during the Load Planning Data from Files scheduled process.	User-entered value for refresh number.	None	The refresh number is available in the load-entity log file, which ends in a warning or error. You can download log file from the Scheduled Processes work area.

Troubleshooting Information

• You can view the status of the Extract Data Load Errors process in the Scheduled Processes work area.
• The validation errors and warning messages that prevented the Extract Data Load Errors from completing display in the error log.
• 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
• For a long-running Extract Data Load Errors scheduled process that is not finishing and appears to be stuck, click the Cancel Process button and then resubmit the job.
• 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.