R12: GLSTFL : General Ledger Accounting Setup Errors with ORA-01427 FLATTEN_SEG_VAL_HIER FLAT0002

(Doc ID 1277333.1)

Last updated on MARCH 12, 2018

Applies to:

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

Symptoms

The General Ledger Accounting Setup Program ends with errors. The program is kicked off after making changes to values in the value set of an accounting flexfield segment. The value set is dependent on another segment. 

The log shows:

GLSTFL module: General Ledger Accounting Setup Program
...
SHRD0203: Oracle error detected in GL_FLATTEN_SEG_VAL_HIERARCHIE.Flatten_Seg_Val_Hier() - ORA-01427: single-row subquery returns more than one row
<x GL_FLATTEN_SEG_VAL_HIERARCHIES.Flatten_Seg_Val_Hier() 15-DEC-10 11:48:54
>> GL_FLATTEN_SETUP_DATA.Release_Lock() 15-DEC-10 11:48:54
<< GL_FLATTEN_SETUP_DATA.Release_Lock() 15-DEC-10 11:48:54
FLAT0002: Fatal error encountered in routine GL_FLATTEN_SETUP_DATA.Main()
<x GL_FLATTEN_SETUP_DATA.Main() 15-DEC-10 11:48:54

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