Cannot Update A Basic Data Definition: ORA-00001: unique constraint (UNIFIER.SYS_DATA_OPTION_UNIQUE) violated

(Doc ID 2169590.1)

Last updated on SEPTEMBER 01, 2016

Applies to:

Primavera Unifier Cloud Service - Version to [Release 16.1]
Primavera Unifier - Version to [Release 16.1]
Information in this document applies to any platform.


When trying to add to the Data Set for a specific Data Definition in the Unifier environment, receiving a Generic System error:
"Unifier Notification - The system could not process your request. Logging in again may help in some cases. Contact your System Administrator if you are still having problems."

The following is captured to the Unifier log files: ORA-00001: unique constraint (UNIFIER.SYS_DATA_OPTION_UNIQUE) violated

The issue can be reproduced at will with the following steps:
1. Log into the Unifier environment as a user with Administrative permissions/access.
2. Navigate to the Company Workspace > Data Structure Setup > Basic > Open the Data Definition > Data Set Tab > Add > Enter the new Value and Label > Re-sort Value Header > Click Update Order > click OK > Receive error.


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