Automated Physical Inventory Count Tag Creation Fails from Mobile Apps ORA-00001: Unique Constraint (INV.MTL_PHYSICAL_INVENTORY_TAGS_U2) Violated (Doc ID 2068039.1)

Last updated on DECEMBER 14, 2016

Applies to:

Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Automated physical inventory count tag creation fails from Mobile Apps after desktop users create a new tag. The mobile apps count scans are failing to automatically create new tags (due to count being in a different subinventory, locator, etc.) once the tag sequencing from the MSCA autocreation hits a tag sequence number that has already been used by manual tag entry in the desktop app. No error is displayed to MSCA users and counts appear to take but they do not register in the physical count.

In the log file, see

ERROR


STEPS

The issue can be reproduced at will with the following steps:

1. Setup new Physical Inventory Count
2. Take Snapshot. After snapshot is complete, generate tags.
3. Max tag # after generating tags is XXXX
4. Logon to Mobile Apps scan gun. Select Counting and enter physical inventory count name, serial option.
5. Scan a serial matching the serial/subinventory/locator on the system. Tag already exists. Tag count is updated to 1.
  Mobile Apps parameters:
  a. Physical Inventory Name = XXXXX
  b. Sub = XXXXX
  c. Locator = XXXXX
  d. Serial =XXXXXXX
6. Next scan a serial that does not match the serial/subinventory/locator on the system. A new tag is automatically created by the system.
  Mobile Apps parameters:
  a. Physical Inventory Name = XXXXX
  b. Sub = XXXXX
  c. Locator = XXXXX
  d. Serial = XXXXX
When Save is selected, the existing tag against locator XXXXX is decremented for qty 1 and a new tag (XXXXX) is automatically created against locator XXXXX for qty 1.

Changes

 

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