Purge Inventory Transactions Interface

When to Use

When loading large volumes of inventory transactions during data migration or external integrations, a simple data entry mistake could be replicated in thousands of lines. Whether you catch this mistake before the lines are processed or after, you need a quick way to delete a large number of lines with incorrect data. The Purge Inventory Transactions Interface process enables you to purge data from the INV_TRANSACTIONS_INTERFACE, INV_TRANSACTION_LOTS_INTERFACE, and INV_SERIAL_NUMBERS_INTERFACE tables. The content of these tables displays collectively on the Manage Pending Transactions page.

Privileges Required

Purge Inventory Transactions Interface Process (INV_PURGE_INVENTORY_TRANSACTIONS_INTERFACE_PROCESS_PRIV)

Specifications

Review the following before setting up this scheduled process:

Specification	Description
Job Type	Adhoc Scheduled
Frequency	As required, usually after the Load Interface File for Import scheduled process has been submitted or after transactions have been created using the Staged Inventory Transactions REST Resource. It's recommended to periodically purge inventory interface transactions in error to keep the number of interface transactions below 1000.
Time of Day	Any time.
Duration	Run time of this process will vary based on the number of inventory transactions and type of inventory transactions requiring processing. For example, inventory transactions for lot and serial controlled items can take additional processing time.
Compatibility	The process is incompatible with itself, thus preventing multiple instances of the process running at the same time. Consider other scheduled processes that are being submitted at the same time. For example, resource intensive processes such as Transfer Transactions from Inventory Costing shouldn’t be submitted at the same time.

Parameters

Parameter	Optional or Required	Description	Parameter Values	Special Combinations Required	Notes
Review Only	Optional	By default, the Review Only check box is checked. The log file indicates the total number of eligible records, number of records with pending status, and number of records with error status.	Yes (check box selected) No (check box not selected)	None	N/A
Load Request ID	Optional	Field to enter the Load Request ID.	Load request identifier	None	N/A
Organization	Optional	Indicates the inventory organization in which you intend to purge inventory transactions.	Inventory organization	None	N/A
Processing Status	Required	Purge error, pending, or both error and pending records.	1 (Error) 2 (Pending) 3 (Error and Pending)	None	N/A
Error	Optional	Indicates the error in which you want to search.	Error number	None	N/A
From Creation Date	Optional	Indicates the inventory transaction from creation date and time in the user-preferred time zone.	Date	None	N/A
To Creation Date	Optional	Indicates the inventory transaction to creation date and time in the user-preferred time zone.	Date	None	N/A
Created By	Optional	Allows selection by the user who created the inventory transaction.	Created by name	None	N/A

Note: When running the Purge Inventory Transactions process, you must provide a value for at least one parameter from Load Request ID, Organization, Error, From Creation Date, To Creation Date, or Created By.

Troubleshooting Information

Supports only those inventory transaction types that are allowed through FBDI or staged inventory transactions REST resource.
It's recommended to submit the process in review mode initially. Once you have confirmed the number of eligible transactions for purge, you can deselect the Review Only check box and purge the inventory transactions.
It's recommended to periodically purge inventory interface transactions in error to keep the number of interface transactions below 1000.
You can view the status of the process on the Scheduled Processes page.
You can manage pending transactions by navigating to the Manage Pending Transactions page. For additional details, please see the Pending Transactions topic in the Oracle Fusion Cloud SCM: Using Inventory Management guide.
When the process is submitted, you can Resubmit, Put on Hold, Cancel Process, and Release Process as provided by the Scheduled Processes page.