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:
Oracle General Ledger - Version 12.0.0 and laterInformation in this document applies to any platform.
GLDASF: Compile Definition Access Sets
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
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
Symptoms |
Changes |
Cause |
Solution |
References |