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

Last updated on AUGUST 01, 2016

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

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