My Oracle Support Banner

11i Duplicate Physical Inventories created, request for clean up script to delete the duplicate Physical Inventory (Doc ID 414595.1)

Last updated on JANUARY 08, 2023

Applies to:

Oracle Inventory Management - Version 11.5.9 to 11.5.10 [Release 11.5]
Information in this document applies to any platform.


Our users created by mistake a duplicate Physical Inventory and took a snapshot of onhand quantities against the duplicate Physical Inventory. No tags were generated for this duplicate PI and no count was done. Users do not want this Physical Inventory.

Can you please give a cleanup script to delete this Physical Inventory?
What would be the impact of this duplicate Physical Inventory?

1) Inventory Super user responsibility
2) Counting --> Physical Inventory --> Physical Inventories. Create a new Physical Inventory
3) Took a snapshot of onhand quantities


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.