E1: 17: Changing Issue QTY Causes Unique Constraint F40UI74 Primary Key Violations (Doc ID 2125131.1)

Last updated on AUGUST 22, 2016

Applies to:

JD Edwards EnterpriseOne Service Management - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

When changing the Order Quantity on the Issues Program (P31113)to '0' and
tabbing out of the field then back in and changing it back, the logs will
generate a Duplicate Unique Constraint Error. According to the client is will
also periodically cause the COK (Call Object Kernel) go to a zombie status

Error:
OCI0000178 - Unable to execute - INSERT INTO PRODDTA.F40UI74
OCI0000179 - Error - ORA-00001: unique constraint (PRODDTA.F40UI74_PK) violated
JDB9900401 - Failed to execute db request
JDB3400009 - Failed to perform Insert for F40UI74

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