My Oracle Support Banner

Exception Raised During Import Segment Values And Hierarchies Using DRM Log Indicates "Details Not Available" (Doc ID 2263875.1)

Last updated on NOVEMBER 02, 2019

Applies to:

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


On : version, Set Up FCR-Define Ledgers

The Import segment values and hierarchies process ends in error when using a csv file exported from DRM (not using the excel template in OER)


Updating tree version: XYZ
Creating Tree Version Nodes for Tree Structure Code:GL_ACCT_FLEX, Tree Code:XYZ, Tree Version ID:4580624C4FE6608DE053A46F230A0151
An Exception was raised during processing of hierarchy. Details not available
Segment hierarchy import ended in FAILED at Mon Apr 24 18:44:48 UTC 2017
Values Interface table cleared for value set XYZ
Hierarchy Interface table cleared for value set XYZ
Interface tables cleared for value set XYZ
Job completed at Mon Apr 24 18:44:49 UTC 2017
Job Completion Status: Error

Load of segment values and hierarchy data from DRM failed with errors. (GL-781710)

The issue can be reproduced at will with the following steps:
0. Generate the cvs file from the DRM (Data Repository not from the excel template).
1. Upload the file into UCM.
2. Navigator > Scheduled Processes > Load Interface File for Import > Import Segment Values and Hierarchies process and Select the zip file.

The issue has the following business impact:
Due to this issue, users are unable import hierarchies.


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

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