Troubleshoot Production Scheduling Performance Issues

If your production scheduling requests take too long to complete, it's possibly because of the schedule or organization configuration. This topic covers best practices and related configuration settings to optimize scheduling performance.

Reduce the Scope

Use the Schedule Options UI to limit the scope of the production schedule to what is essential.

• Specify a short schedule horizon. For example, if a schedule is generated every day, and the longest lead times are less than a week, then having a schedule horizon of several months adds no value, but unnecessarily increases the data volume and the size of the schedule.

• Select only those item categories that need to be included in the schedule.

  Note: In the Product Information Management work area, item categories can be defined with scheduling needs in mind. This would allow for scope definitions with items that are actually relevant to scheduling. Access to the Product Information Management work area is managed by your administrator.

Limit Resource Constraints to Bottleneck Resources

Use the Resource Parameters UI to control the constraint mode of a resource. Use the Constrained value for such cases, and for others use Relaxed or Relaxed for capacity only. The default mode is Relaxed.

Use a Resource Constraint Horizon

In the Schedule Options UI, specify a resource constraint horizon to specify the length of time during which capacity constraints are enforced. The horizon is calculated from the schedule horizon's start date. Beyond the constraint horizon period, constrained resources will be considered relaxed.

Review the Number of Records for Production Scheduling Objects

Use REST services to retrieve and review the volume of data you're working with for specific production scheduling objects, like items, resources, and work orders.

Review Request Logs for Production Scheduling Processes

A log file is created during production scheduling processes, like refreshes, solves, and releases. To view details of any process warnings or errors, copy the process request ID from the Production Schedules page and use it to search for the request log file in the Scheduled Processes UI.

Download Binary Schedule Files to Share with Oracle Support

If you need to file a service request with Oracle Support, you can be asked to attach binary schedule files to your service request. These files help in analysis and troubleshooting for your service request.

You can download the Refreshed Schedule and Solved Scheduled binary schedule files from the Schedule Administration page in the Production Scheduling work area. On the Action menu of a schedule, select Schedule Administration to access the Schedule Administration page of that schedule.