Purge Inventory Balance Messages

Use the Purge Inventory Balance Messages scheduled process to purge all successful or error inventory balance records received from sources like the Inventory Balance Message Import file-based data import (FBDI) or the Inventory Balance Transactions REST resource.

Inventory balance messages are created when you interface the inventory balance data using the above FBDI or REST resources and the record is loaded to the Interface tables. After processing, data is loaded to the inventory base tables. It’s recommended to periodically purge the data for better performance.

When to Use

Use the Purge Inventory Balance Messages process to purge all successful or error inventory balance records received from sources like REST or FBDI. For example, you can purge inventory balance messages by providing the organization code as a mandatory input parameter. In addition, you can also purge the inventory balance records by specifying the processing status or message dates. You can purge the error records older than one year, one month, or one week. You can also purge both successful and error records in a specific date range.

Privileges Required

  • Purge Inventory Balance Messages (INV_PURGE_INVENTORY_BALANCE_MESSAGES_PRIV)
Note:

When you enable the Reconcile Inventory Balances with a Third-Party Logistics Provider, Warehouse Management System, or Contract Manufacturer feature, all inventory balance message adjustment records must be reviewed and adjusted accordingly. When this feature is enabled, the processing status input parameter will have the values such as Approved, Rejected, Error, and All. When you select the processing status of All, records with processing status of Error, Approved, and Rejected are deleted. Only Inventory balance adjustment records with a status of Pending for approval or New aren’t considered for the purge.

Specifications

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

Scheduled

Frequency As required.
Time of Day Any time.
Duration Runtime of this process varies based on the number of inventory balance records that selected for the purge process.
Compatibility 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
Organization Required Inventory organization for which you want to run the Purge Inventory Balance Messages process.

Inventory organization

None N/A
Processing Status Optional Processing status of inventory balance records such as successful, error, and all. Successful

Error

All

None N/A
Message Date Optional Message date for which you want to run the Purge Inventory Balance Messages process. Older than year

Older than month

Older than week

Before

Between

After

None N/A
From Date Optional From date for which you want to run the Purge Inventory Balance Messages process. Date None N/A
To Date Optional To date for which you want to run the Purge Inventory Balance Messages process. Date None N/A

Troubleshooting Information

  • You can view the status of the process in the Scheduled Processes work area.
  • Error and warning messages encountered while running the process display in the process 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.
  • Ensure logging isn’t enabled. For example, Application Framework logging shouldn’t be enabled.