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.