GLSTFL : General Ledger Accounting Setup Errors With ORA-01427 FLATTEN_SEG_VAL_HIER FLAT0002 When There Are Different Summary Flags for the Same Flex Value (Doc ID 2060124.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.
Concurrent Program: GLSTFL - General Ledger Accounting Setup Program

Symptoms

After making changes to values in a dependent value set of an accounting flexfield segment, the system automatically launches the General Ledger Accounting Setup Program (GLSTFL) that finishes with error.
The errors are the same as described in Oracle <Note 1277333.1>. Installed the patch 9836341:R12.GL.B, but this issue still occurs.

Error
--------
The log file of GLSTFL module: General Ledger Accounting Setup Program shows:
.......
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() 13-AUG-15 11:15:49
>> GL_FLATTEN_SETUP_DATA.Release_Lock() 13-AUG-15 11:15:49
<< GL_FLATTEN_SETUP_DATA.Release_Lock() 13-AUG-15 11:15:49
FLAT0002: Fatal error encountered in routine GL_FLATTEN_SETUP_DATA.Main()
<x GL_FLATTEN_SETUP_DATA.Main() 13-AUG-15 11:15:49

Steps
------
The issue can be reproduced with the following steps:

1. Go to Responsibility = General Ledger Super User
2. Navigate to Setup > Financials > Flexfields > Values > query the dependent value set > make a change to a value
3. Save
4. GLSTFL module: General Ledger Accounting Setup Program is kicked off
5. Check its log, as 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