Purge Inventory Reservations Interface

Use the Purge Inventory Reservations Interface scheduled process to purge the error, pending, or both error and pending records populated in the reservations interface table (INV_RESERVATIONS_INTERFACE) by file-based data import (FBDI) or Inventory Staged Reservations REST resource.

You can purge records populated by a specific load request number when the records are created using FBDI.

When to Use

Use the process when the number of records in the reservations interface is over 100,000 records.

Privileges Required

  • Purge Inventory Reservations Interface (INV_PURGE_INVENTORY_RESERVATIONS_INTERFACE_PRIV)

Specifications

Review the following before setting up this scheduled process:
Specification Description
Job Type Ad hoc job.

Scheduled

Frequency Minimum of once a year to purge all the error records.
Time of Day Any time.
Duration The process should complete within a few minutes if there are a few thousand records.
Compatibility This process purges records for all the organizations, thereby preventing a need to run it multiple times for different organizations. There can be multiple instances of the process running, but it’s recommended to schedule the process so that only one instance of the process is running at a time.

Parameters

Parameter Optional or Required Description Parameter Values Special Combinations Required Notes
Purge Data Before Optional Purge any records in the reservation interface created before the date you specify here.

Date

None N/A
Status Optional Purges records in Error, Pending, or Error and pending status. Error: Purges only the records in error status.

Pending: Purges only the records in pending status.

Error and pending: Purges the records in both error and pending statuses.

None N/A
Load Request ID Optional Purges records populated using a specific load request ID. Value of the process ID which inserted records in the reservations interface. None The Load Request ID is only populated when the records are inserted using FBDI. This field isn’t populated when the records are inserted using the REST resource.

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.
  • When the process is submitted, you can use the Cancel Process button as provided by the Scheduled Processes work area.
  • The log file provides a summary of the input parameters for which the Purge Inventory Reservations Interface process is run and provides a summary of the eligible records which were picked for processing, records processed and, the number of failed records.
  • The status code in the log file has a value of 1 for records in Pending status, 3 for records in Error status and 0 for records in Error and Pending status.