Error "ORA-00001: unique constraint (EMDBO.PS_IN_FL_LOT_TAO4) violated" when Running the 'Pick Confirm' Process (IN_FUL_PFB) for Multiple Inventory Business Units with Lot-Controlled Items (Doc ID 1448261.1)

Last updated on AUGUST 21, 2015

Applies to:

PeopleSoft Enterprise SCM Inventory - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.
***Checked for relevance on 14-Jun-2012***

Symptoms

The 'Pick Confirm' process (IN_FUL_PFB) (navigation: SCM Integrations, Process Transactions, Inventory, Picking) fails with the following error when it is run for multiple Inventory Business Units, each of them containing Lot-Ccontrolled Items:

ORA-00001: unique constraint (EMDBO.PS_IN_FL_LOT_TAO4) violated
Failed SQL stmt:INSERT INTO PS_IN_FL_LOT_TAO4

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