"Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_IN_DP_DMD_TAO4) violated" when Running the 'Picking Confirmation' Process (IN_FUL_CONF) with the Auto Process Option Set to 'Advance to Depleted' (Doc ID 1935975.1)

Last updated on SEPTEMBER 01, 2016

Applies to:

PeopleSoft Enterprise SCM Inventory - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

You experience the following error when attempting to run the 'Picking Confirmation' process (IN_FUL_CONF) (navigation: Inventory, Fulfill Stock Orders, Picking Picking, Confirmation Process) with the Auto Process option set to 'Advance to Depleted':

Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_IN_DP_DMD_TAO4) violated
Failed SQL stmt: INSERT INTO PS_IN_DP_DMD_TAO4)

Process ABENDED at Step IN_DEPLETE.IUPut.Step050 (SQL) -- RC = 805 (108,524)

 

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