My Oracle Support Banner

R12 GLSTFL General Ledger Accounting Setup Program Fails With ORA-01427 After Adding Values to Dependent Segment Value Set (Doc ID 1110676.1)

Last updated on APRIL 04, 2025

Applies to:

Oracle General Ledger - Version 12.1.2 and later
Information in this document applies to any platform. EXECUTABLE: GLSTFL module: General Ledger Accounting Setup Program

Symptoms

When attempting to add values to a dependent value set, the system automatically launches the General Ledger Accounting Setup Program (GLSTFL) that finishes with error.

ERROR
-----------------------
SHRD0203: Error de Oracle detectado en GL_FLATTEN_SEG_VAL_HIERARCHIE.Flatten_Seg_Val_Hier() - ORA-01427: la subconsulta de una sola fila devuelve m�s de una fila
(Translation: SHRD0203: Oracle error detected in GL_FLATTEN_SEG_VAL_HIERARCHIE.Flatten_Seg_Val_Hier() - ORA-01427: single-row subquery returns more than one row)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
General Ledger Responsability:
1) Setup > Financials >Structures > Key > Values
2) Define values for a DEPENDENT segment
3) Compile

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!

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