GLOOAP - Open Period Program Ending in Error: Value does not exist in the value set GL_ROLLUP_GROUP_VALUE_SET (Doc ID 2129102.1)

Last updated on APRIL 28, 2016

Applies to:

Oracle General Ledger - Version 11.5.10.2 and later
Information in this document applies to any platform.
GLOOAP
GL_ROLLUP_GROUP_VALUE_SET

Symptoms

Attempting to open the first period of the new year for one set of books and seeing the following error in the log:

>> gls_fill_seg_info() 13-APR-2016 16:30:44
SHRD0114: Executing Pro*C statement Select hierarchy_id from fnd_flex...

SHRD0043: ERROR: ORA-01403: no data found
SHRD0075: Error in gls_fill_seg_info().
SHRD0075: Error in glsmah().
SHRD0015: glsamn failed:
*****************************************************
sqlcaid: sqlabc: 0 sqlcode: 1403 sqlerrml: 25
sqlerrmc:
ORA-01403: no data found

sqlerrp: sqlerrd: 0 0 0 0 0 538976288
sqlwarn: sqltext:
*****************************************************

oracaid: oracabc: 0
oracchf: 0 oradbgf: 0 orahchf: 0 orastxtf: 0 orastxtl: 0
orastxtc:

orasfnmc: oraslnr: 0 orasfnml: 0
orahoc: 50 ormoc: 13 oracoc: 13
oranor: 0 oranpr: 57 oranex: 59

SHRD0015: glsamn failed:
SHRD0033: Error Status: 3

The following is being seen in the maintain summary template log:
GLSMST module: Program - Maintain Summary Templates

>> gls_fill_seg_info() 13-APR-2016 18:28:50
SHRD0114: Executing Pro*C statement Select hierarchy_id from fnd_flex...

SHRD0043: ERROR: ORA-01403: no data found
  

SHRD0075: Error in gls_fill_seg_info().

SHRD0075: Error in glsmah().

and the following error is being seen when reviewing the summary template definition in the form:
Value XXXX for the flexfield segment Template Value does not exist in the value set GL_ROLLUP_GROUP_VALUE_SET.

Due to these errors, cannot open the current period or run the maintain the summary templates program with success.


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