Guidelines for Using Scheduled Processes in Order Management

Filter Your Data

Each scheduled process has a set of parameters. We recommend that you set values in these parameters to filter the data that the scheduled process will look at. This helps to make sure you process only the data you need. It also helps to avoid performance problems.

For most scheduled processes, you should use a combination of parameters to filter your data. We recommend that you specify at least two or three parameters. If you don't specify any parameters, the scheduled process might still run but take a long time to finish or affect performance because it's updating data for every instance of every scheduled process that you run.

Example

Assume you need to run the Update Sales Order Totals scheduled process, and your database contains these sales orders:

Sales Order	Creation Date	Source System	Status
50000	June 1	GPR	Open
50001	June 2	LEG	Open
50002	June 3	GPR	Open
50003	June 4	LEG	Closed
50004	June 5	GPR	Closed

Assume you set these values.

Parameter	Value
From Order Number	5000
To Order Number	5005
From Ordered Date	June 1
To Ordered Date	June 4
Source System	GPR
Order Status	Open

The scheduled process will only process sales orders 50000 and 50002.

Another Example

Assume you set these values when you run the Plan Orchestration Processes scheduled process.

Parameter	Value
Item	AS54888
Process Name	ShipOrderGenericProcess
Business Unit	Vision Operations
Warehouse	Denver Manufacturing

The scheduled process will update all plans that involve the AS54888 item, the ShipOrderGenericProcess scheduled process, the Vision Operations business unit, and the Denver Manufacturing warehouse.

Filter According to Date

You can use the date parameters on various scheduled processes to filter data according to date and time.

For example, the Update Sales Order Totals scheduled process includes the From Ordered Date parameter and the To Ordered Date parameter. You can use them to specify the sales orders that you want to process.

If you set only From Ordered Date, then the scheduled process will process all sales orders that you create on or after the date that you specify.
If you set only To Ordered Date, then the scheduled process will process all sales orders that you create on or before the date that you specify.
If you set From Ordered Date and To Ordered Date, then the scheduled process will process a range of sales orders.

Assume your database contains sales orders that you create on these dates:

June 1
June 2
June 3
June 4
June 5

If you set:

From Ordered Date to June 3 and leave To Ordered Date empty, then the scheduled process will process the orders that you created on June 3, June 4, and June 5.
To Ordered Date to June 3 and leave From Ordered Date empty, then the scheduled process will process the orders that you created on June 1, June 2, and June 3.
From Ordered Date to June 1 and To Ordered Date to June 3, then the scheduled process will process the orders that you created on June 1, June 2, and June 3.

Filter According to Other To and From Parameters

You can filter data on some scheduled processes according to various To and From parameters.

For example, the Update Sales Order Totals scheduled process includes the From Order Number parameter and the To Order Number parameter. You can use them to specify the sales orders that you want to process according to the value in the Order Number attribute on the order header.

If you set only From Order Number, then the scheduled process will process all sales orders that are equal to or greater than the value that you specify.
If you set only To Order Number, then the scheduled process will process all sales orders that are equal to or less than the value that you specify.
If you set From Order Number and To Order Number, then the scheduled process will process a range of sales orders.

Assume your database contains these sales orders:

50000
50001
50002
50003
50004

If you set:

From Order Number to 50003 and leave To Order Number empty, then the scheduled process will process orders 50003 and 50004.
To Order Number to 50003 and leave From Order Number empty, then the scheduled process will process orders 50000, 50001, 50002, and 50003.
From Order Number to 50000 and To Order Number to 50002, then the scheduled process will process orders 50000, 50001, and 50002.

Avoid Performance Problems

If you have a large number of records, then use one or more sets of From and To parameters to filter the number of records that you will process, and run the process more than one time. Assume you have a scheduled process that looks at supply orders, and you want to process all the supply orders that you received during the month of March. You received approximately 100 requests on each day. You can run the process three times and process about 1,000 records on each run instead of processing about 3,000 records on a single run.

Run	From Creation Date	To Creation Date
1	March 1	March 10
2	March 11	March 20
3	March 21	March 31

Troubleshoot

If the process is taking a long time to finish, consider adding more filters. The more you filter your data, the less data the process has to consider.
Make sure there isn't some problem that's affecting all scheduled processes. You can tell because every scheduled process that you run will seem really slow. Slow servers, network latency, and other issues like this might affect all scheduled processes.
Use the Scheduled Processes work area to view the status of the scheduled process.
Click View Log on the Overview page of the Scheduled Processes work area to see if there are any validation errors or warnings that are preventing the scheduled process from reaching the Succeeded status. If it isn't clear, work with Oracle Support to examine the finer details in the diagnostic logs.
Use the Resubmit, Put on Hold, Cancel Process, and Release Process actions in the Scheduled Processes work area, as necessary.