My Oracle Support Banner

R12 - Changing Project Status in SSWA Gets Error SQLException: ORA-00001: Unique Constraint (Doc ID 1311066.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Project Foundation - Version 12.0.4 and later
Information in this document applies to any platform.
***Checked for relevance 04-Nov-2011 ***

*** Checked for Relevance 09-Apr-2013 ***

Symptoms

After applying <Patch 8255159> users encounter the following error when changing a project status in the SSWA screen:

Error Page
Exception Details.
oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-00001: unique constraint (PA.PA_OBJ_STATUS_CHANGES_U2) violated
ORA-06512: at &quot;APPS.PA_PROJECTS_MAINT_PUB&quot;, line 3748
ORA-06512: at line 1

at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:896)
at oracle.apps.pa.project.server.ProjectStatusVORowImpl.updateRow(ProjectStatusVORowImpl.java:458)
at oracle.apps.fnd.framework.server.OAPlsqlViewRowImpl.callAPI(OAPlsqlViewRowImpl.java:111)
at oracle.apps.fnd.framework.server.OAPlsqlViewObjectImpl.callAPI(OAPlsqlViewObjectImpl.java:163)
at oracle.apps.fnd.framework.server.OAPlsqlViewObjectImpl.beforeCommit(OAPlsqlViewObjectImpl.java:430)
at oracle.jbo.server.DBTransactionImpl.commitInternal(DBTransactionImpl.java:2009)

plus more

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.