GLDRMLDR: Load Segment Values and Hierarchies Erroring with ORA-0142 Error
Last updated on MAY 26, 2017
Applies to:Oracle General Ledger - Version 12.1.3 and later
Information in this document applies to any platform.
Running the GLDRMLDR: Load Segment Values and Hierarchies program and the following error is being seen in the log file:
Validating segment values and hierarchies...
Fetching value_set properties...
Validating segment values exported from DRM...
Number of segment values : 4496
Number of segment values in error : 0
Validating exported hierarchy relationships...
Number of hierarchy relationships : 4232
Number of relationships in error : 0
Segment values are all valid.
Hierarchy relationships are all valid
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.
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