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

Review the following before setting up this scheduled process:

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	N/A
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.