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

Last updated on MARCH 22, 2023

Applies to:

Goal

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

Solution

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