Material Cost Collection Worker Error ORA-00001: unique constraint (PA.PA_TRANSACTION_XFACE_CTRL_U1) violated
Last updated on MARCH 08, 2017
Applies to:Oracle Installed Base - Version 18.104.22.168 and later
Information in this document applies to any platform.
***Checked for relevance on 15-Oct-2014***
Material Cost Collection Worker request is failing with error:
"CSTPPCCB.pm_insert_pti_pvt(52): ORA-00001: unique constraint
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
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