Purge Physical Inventory
Use the Purge Physical Inventory scheduled process to remove physical inventory records from the database.
Organizations typically retain several years of inventory data for various business reasons. It’s good practice to purge older physical inventories that are no longer required for audit purposes. This reduces unnecessary data in the application tables.
With the Purge Physical Inventory process, you can choose to purge a physical inventory or only physical inventory tags. When this process is run, Oracle Fusion Cloud Inventory Management deletes all information associated with the physical inventory. The Purge Physical Inventory process doesn't affect any adjustments or adjustment transactions made during the physical inventory.
When to Use
Use the Purge Physical Inventory scheduled process to remove physical inventory records from the database. You can choose to remove the complete physical inventory, only the physical inventory tags, or both. You can purge a physical inventory from the Manage Physical Inventories page or using a scheduled process.
Privileges Required
- Purge Physical Inventory (INV_PURGE_PHYSICAL_INVENTORY)
Specifications
Specification | Description |
---|---|
Job Type | Ad hoc job Scheduled |
Frequency | As required for business or performance requirements. |
Time of Day | Any time depending on requirements. |
Duration | Runtime of this process varies based on the number of items in the physical inventory and whether you’re purging the physical inventory and physical inventory tags or just the physical inventory. |
Compatibility | There should be only one instance of the job running at any time, and there’s no current functional need to run multiple instances of this process simultaneously. |
Parameters
Parameter | Optional or Required | Description | Parameter Values | Special Combinations Required | Notes |
---|---|---|---|---|---|
Organization | Required | The organization where the physical inventory is defined. | Inventory organization | None | N/A |
Physical Inventory | Required | The name of the physical inventory. | Physical inventory name | None | N/A |
Purge Physical Inventory | Required | If you select Yes for the Purge Physical Inventory Setup parameter, the application purges the setup data associated with the physical inventory. | Yes No |
None | When purging a physical inventory, checks are made to determine if the physical inventory has already been posted and if there are any adjustments posted against that physical inventory. If yes, then the physical inventory setup is retained so that it can be used for historical transaction reference. |
Purge Error Records | Optional | If you select Yes for the Purge Error Records field, the process deletes all pending transactions for physical inventory, along with corresponding tags and adjustments. If you select No, only physical inventory tags and adjustments are deleted after all pending transactions are processed. | Yes No |
None | N/A |
Troubleshooting Information
- When the process is submitted, you can Resubmit, Put on Hold, Cancel Process, and Release Process as provided by the Scheduled Processes work area.