Not Able To Create User And Getting The Error: Duplicate Key Value Violates Unique Constraint

(Doc ID 2370685.1)

Last updated on APRIL 16, 2018

Applies to:

Oracle Warehouse Management Enterprise Edition Cloud Service - Version 8.0.0 and later
Information in this document applies to any platform.


On : 8.0.2 version, Security

When attempting to create a new User, the following error occurs.

duplicate key value violates unique constraint "cw_user_univ_id_key" DETAIL: Key (company_id, univ_id_1)=(1, 1) already exists.

The issue can be reproduced at will with the following steps:
1. Go to Users UI
2. Try Creating a new User with new Data
3. Click on Save,
- encounter the above mentioned 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