Purge Shipping Exceptions

Use the Purge Shipping Exceptions scheduled process to delete the shipping exceptions in Closed and No action required statuses.

The exceptions are selected based on a range of parameters. The shipping exceptions with severity as Error is backed up in WSH_EXCEPTIONS_PURGE_BKP table before being purged. The number of days of shipping exception records to store in backup table is defined in the Number Of Days Of Purged Data To Retain In Shipping Purge Backup Tables profile option (ORA_WSH_PURGE_BACKUP_RETENTION_DAYS). This profile option value is set to 1095 by default.

When to Use

Use this process when you want to delete shipping exceptions at predefined times and intervals. Consider running the Purge Shipping Exceptions process periodically to delete old exceptions that aren't required. Keeping the size of the shipping exceptions table small will improve the system performance and enhance the performance of the Review Shipping Exceptions page.

Privileges Required

• Purge Shipment Exceptions (WSH_PURGE_SHIPMENT_EXCEPTIONS_PRIV)

Specifications

Review the following before setting up this process:

Specification	Description
Job Type	Ad hoc job Scheduled
Frequency	As required, usually depends on shipping exceptions data volume. It is recommended that you purge shipping exceptions at least once every six months or more often if your organization generates millions of exceptions each month. Keeping the size of the shipping exceptions table small will improve system performance.
Time of Day	Any time
Duration	Runtime of this process varies based on the number of exceptions to process. If you run the process for the first time and have millions of records to process, consider using the available parameters to delete exceptions in smaller batches. Once the initial purge is done, you can schedule the process more often to delete records in smaller batches. For example, you can schedule the process to run every month to delete records older than six months
Compatibility	There should be only one instance of the process running at a time. The process is incompatible with itself, thus preventing multiple instances of the process running at the same time.

Parameters

Parameter	Optional or Required	Description	Parameter Values	Special Combinations Required	Notes
Review Only	Optional	Indicates if the process needs to delete the selected records or only print the number of selected records in the output file of the process.	Yes (If check box is selected) No (If check box is not selected)	None	By default, the Review Only check box is selected.
From Creation Date	Optional	Starting creation date when using a range of creation dates to select shipping exception records for purge.	Date	None	N/A
To Creation Date	Optional	Ending creation date when using a range of creation dates to select shipping exception records for purge.	Date	None	N/A
Purge Cutoff Days	Optional	Indicates the number of days of shipping exception records to keep. Only records older than the entered number of days will be selected for purge.	Number	None	N/A
Exception Name	Optional	Name of the shipping exception you want to select for purge.	Single value from list of values, which contains the list of exceptions defined in Manage Shipping Exceptions page.	None	N/A
Type	Optional	Type of shipping exception you want to select for purge.	Single value from list of values, which contains the list of exception types. Shipment: exceptions that are logged against shipments. Picking: exceptions that are logged during the picking process. Batch: exceptions logged to store the messages generated during the automated shipping processes such as automatically pack and ship confirm.	None	N/A
Severity	Optional	Severity of the shipping exception you want to select for purge.	Single value from list of values, which contains the list of exception severity levels. Error: Requires resolution before the transaction can be closed. Warning: Can be superseded and doesn't require resolution to close the transaction. Information: Provides information on a particular transaction. The user isn't required to act on the information exception to close the transaction.	None	N/A
Status	Optional	Status of the shipping exception you want to select for purge.	Closed No action required Closed and no action required	None	The default value is Closed and no action required.

Troubleshooting Information

• You can view the status of the process in the Scheduled Processes work area.
• Once the process is complete, it will have a log file and an output file.
• The output file will have a summary with the number of exception records selected by the process based on the input parameters.
• Error and warning messages encountered while running the process will be displayed in the log file.
• When the process is submitted, you can Resubmit, Put on Hold, Cancel Process, and Release Process as provided by the Scheduled Processes work area.