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 MARCH 23, 2017

Applies to:

Oracle General Ledger - Version 12.1.3 and later
Information in this document applies to any platform.
GLDASF: Compile Definition Access Sets

Symptoms

On : 12.1.3 version, Setup forms and programs

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

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

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
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

 

Cause

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