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 ***


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(
at oracle.apps.fnd.framework.server.OAPlsqlViewRowImpl.callAPI(
at oracle.apps.fnd.framework.server.OAPlsqlViewObjectImpl.callAPI(
at oracle.apps.fnd.framework.server.OAPlsqlViewObjectImpl.beforeCommit(
at oracle.jbo.server.DBTransactionImpl.commitInternal(

plus more


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

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