Program GLDASF: Compile Definition Access Sets Fails with ORA-00001: Unique Constraint (GL.GL_DEFAS_ASSIGNMENTS_U1) Violated (Doc ID 2078551.1)

Last updated on FEBRUARY 21, 2024

Applies to:

Symptoms

When updating the definition access sets, by changing any of the privileges Use, View, Modify, the GLDASF: Compile Definition Access Sets program is triggered and it completes with the following error in the log file:

ERROR
ORA-00001: unique constraint (GL.GL_DEFAS_ASSIGNMENTS_U1) violated

STEPS TO REPRODUCE
1. Go to General Ledger responsibility
2. Navigate to Setup : Financials : Definition Access Sets : create new Definition Access Set : Save
3. Requery the definition access set create at step 2
4. Alter any privilege, by adding or removing one of the privileges: Use, View, Modify.
5. Save
6. GLDASF: Compile Definition Access Sets is triggered and it completes in error

Changes

 Setup changes for definition access sets.

Cause

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