Cannot Update A Basic Data Definition: ORA-00001: unique constraint (UNIFIER.SYS_DATA_OPTION_UNIQUE) violated
Last updated on SEPTEMBER 01, 2016
Applies to:Primavera Unifier Cloud Service - Version 18.104.22.168 to 22.214.171.124 [Release 16.1]
Primavera Unifier - Version 126.96.36.199 to 188.8.131.52 [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