Purge Replenishment Requests

Use the Purge Replenishment Requests scheduled process as a controlled mechanism to delete error or success replenishment request records from the database.

Over time, these records accumulate and can impact system performance and data retrieval efficiency.

This scheduled process allows users to specify key parameters such as the Organization, Subinventory, Purge Before Date, and Status (Success, Error, or Both), to identify and purge only the targeted replenishment request records.

The job operates exclusively on the Replenishment Request table and doesn’t affect the related replenishment data or active transactions. Back-end validations ensure that the mandatory parameters are enforced, while the purge process executes in logical batches to avoid rollback segment overflow. On completion, a detailed scheduled process log summarizes the purge count and status.

When to Use

Use the Purge Replenishment Requests scheduled process when:

• The system contains a large volume of completed, errored, or obsolete replenishment request records.
• You want to perform periodic database housekeeping to improve system performance and response time.
• There’s a need to clear historical or redundant replenishment requests after data migration, testing, or month-end processing.
• You observe delays in query or report performance caused by an excessive request history.
• As part of scheduled maintenance, to ensure data hygiene without affecting ongoing replenishment operations.

Administrators and users can schedule the process manually in the Scheduled Processes work area at intervals determined by your business policy (for example, monthly or quarterly). This process runs independently and requires explicit user input for parameters, including Organization, Subinventory, Date, and Status, before execution.

Privileges Required

• Purge Replenishment Record Requests for Existing Records (INV_Purge_Replenishment_Requests_PRIV)

Specifications

Review the following before setting up this scheduled process:

Specification	Description
Job Type	Ad hoc job Scheduled
Frequency	Several times a day (low volume).
Time of Day	Can be done both during and after working hours.
Duration	Typically variable, based on the number of record lines eligible on selected parameters.
Compatibility	There should be only one instance of the job running at any time, and there’s no current functional need to run multiple instances of this process simultaneously.

Parameters

Parameter	Optional or Required	Description	Parameter Values	Special Combinations Required	Notes
Organization	Required	Select the organization name. The job uses this field to select the records of the selected organization that’s going to be purged.	Inventory organization	None	N/A
Subinventory	Optional	Select the subinventory from the list of values as per the organization selected.	Subinventory name	None	N/A
Purge Before Date	Required	Specify the purge record before date. The job uses this date as a reference to purge records before the date specified.	Date	None	N/A
Processing Status	Required	Select the replenishment records status from the list of values. The job uses the selected values as a parameter to be eligible to be purged.	Status	None	N/A

Troubleshooting Information

• You can view the status of the Purge Replenishment Requests scheduled process in the Scheduled Processes work area.
• The validation errors and warning messages that prevented the purge are displayed in the error log.
• This scheduled process applies only to completed PAR requests and doesn’t affect active or in-progress replenishment transactions.