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
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.
|
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.
|
None |
N/A |
Status |
Optional |
Status of the shipping exception you want to select for purge. |
|
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.