My Oracle Support Banner

GLDRMLDR: Load Segment Values and Hierarchies Erroring with ORA-0142 Error (Doc ID 2270609.1)

Last updated on FEBRUARY 23, 2019

Applies to:

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

Symptoms

Running the GLDRMLDR: Load Segment Values and Hierarchies program and the following error is being seen in the log file:

:- >>GL_DRM_INTEGRATION_PKG.gl_drm_import_process
 Validating segment values and hierarchies...
 Fetching value_set properties...
 Validating segment values exported from DRM...
 Number of segment values : XXXX
 Number of segment values in error : 0
 Validating exported hierarchy relationships...
 Number of hierarchy relationships : XXXX
 Number of relationships in error : 0
 Segment values are all valid.
 Hierarchy relationships are all valid
 Calling GL_COA_SEGMENT_VAL_PVT.COA_SEGMENT_VAL_IMP...
 >>GL_DRM_INTEGRATION_PKG.gl_translate_segvalues
 Translating for installed language: ESA
 GL_DRM_INTEGRATION_PKG.gl_translate_segvalues >> Unexpected EXCEPTION
 Handling exception in GL_DRM_INTEGRATION_PKG.
 ORA-01422: exact fetch returns more than requested number of rows

Due to this error, the program fails and the loading does not complete.



Changes

 

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!


In this Document
Symptoms
Changes
Cause
Solution
References


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