Purge Supplier On-Hand Quantities
Use the Purge Supplier On-Hand Quantities scheduled process to delete on-hand data when suppliers no longer exist, items may be discontinued, or supplier on-hand records may become too old to be reliable.
When to Use
You can use the Purge Supplier On-Hand Quantities scheduled process to purge the Supply Chain Collaboration supplier on-hand quantity records based on user-defined parameters. You can choose to purge the records based on the number of days since the last publish date, which you can further filter by supplier, supplier site, or item.
Privileges Required
- Purge Supplier On-Hand Quantities (VCS_PURGE_SUPPLIER_ONHAND_PRIV)
Specifications
Review these specifications before setting up this scheduled process:
Specification | Description |
Job Type | Can be run at any time, if required. |
Frequency | As required by your business, usually aligning with the planning cycle. |
Time of Day | After work hours is recommended but can be submitted any time based on your requirements. |
Duration | Varies, based on the number of records to process but should usually only take a few minutes. |
Compatibility | No compatibility issues with other scheduled processes. |
Parameters
Parameter | Optional or Required | Description | Parameter Value | Special Combinations Required | Notes |
Number of Days Since Publish Date | Required |
Number of days since the last publish date to keep supplier on-hand data. All data beyond this number is purged from the database.
|
Select the number of days since the last supplier on-hand publish date. Default is 7 days. | None | NA |
Supplier | Optional | Supplier name for which you want to purge on-hand data. | Select supplier for which you want to delete on-hand data. | None | NA |
Supplier Site | Optional | Supplier site name for which you want to purge supplier on-hand data. | Select supplier site for which to delete on-hand data. | Allows only the supplier site for the given supplier. | NA |
Item | Optional | Item for which you want to purge supplier on-hand data. | Select item for which to delete supplier on-hand data. | None | NA |
Troubleshooting Information
- You can view the status of the Purge Supplier On-Hand Quantities scheduled process in the Scheduled Processes work area. A status notification indicates that the process has completed successfully.
- Validation errors and warning messages that prevented this scheduled process from completing display in the error log.
- The process does not perform interactive warning validations.