INCAPP MTL_PHYSICAL_INVENTORY_TAGS Contains Numerous Invalid Records
Last updated on FEBRUARY 26, 2016
Applies to:Oracle Inventory Management - Version 11.5.8 and later
Information in this document applies to any platform.
Running Purge Physical Inventory program INCAPT did not purge tags as expected leaving numerous records in MTL_PHYSICAL_INVENTORY_TAGS table, whereas the corresponding physical inventory was actually purged.
Steps to Reproduce:
Any INV Responsibility > Counting > Physical Inventory > Physical Inventories > Create a physical inventory > Take a snapshot > Generate Tags.
Physical Inventory is created.
Run INCAPT Generate physical inventory tags to create tags.
Upon execution of INCAPT, you determined tags were generated erroneously.
Run INCAPP Purge physical inventory information in attempt to purge unwanted Tags
Expected result is that all tags are purged; however, there are many tags still present, whereas the 'parent' physical inventory is purged.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms