Material Cost Collection Worker Error ORA-00001: unique constraint (PA.PA_TRANSACTION_XFACE_CTRL_U1) violated (Doc ID 1219935.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Installed Base - Version 11.5.10.2 and later
Information in this document applies to any platform.
***Checked for relevance on 15-Oct-2014***


Symptoms

Material Cost Collection Worker request is failing with error:

"CSTPPCCB.pm_insert_pti_pvt(52): ORA-00001: unique constraint
(PA.PA_TRANSACTION_XFACE_CTRL_U1) violated
ORA-06512: at ""APPS.PA_TRANSACTION_INTERFACE_T1"", line 35
ORA-01403: no data found
ORA-06512: at ""APPS.PA_TRANSACTION_INTERFACE_T1"", lin"

There is one transaction with Costed_Flag=Yes, and the error_explanation is:

CSTPACIR:10ORA-01400: cannot insert NULL into
("WIP"."WIP_REQ_OPERATION_COST_DETAILS"."OPERATION_SEQ_NUM")

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