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

Last updated on FEBRUARY 02, 2024

Applies to:

Symptoms

On : 11.12.1.0.0 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)

ERROR
-----------------------
56926.log

....
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


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

STEPS
-----------------------
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.

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

Cause

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