INCAPP MTL_PHYSICAL_INVENTORY_TAGS Contains Numerous Invalid Records (Doc ID 369702.1)

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.
INCAPT
INCAPP

Symptoms

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.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms