Purge Inventory Transactions Interface
Use the Purge Inventory Transactions Interface scheduled process to purge pending transactions from the inventory interface tables.
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
Specification | Description |
---|---|
Job Type | Ad hoc job 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 | Runtime 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 |
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 in the Scheduled Processes work area.
- 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 work area.