My Oracle Support Banner

Error "The segment value cannot be Essbase restricted reserved word" in Import Segment Values And Hierarchies (Doc ID 2772739.1)

Last updated on APRIL 29, 2021

Applies to:

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

Symptoms

On : 11.13.21.01.0 version

Error in Import Segment Values and Hierarchies

When running Import Segment Values and Hierarchies to refresh COA, the following error occurs

it fails for GEOGRAPHY segment for one value "AND". with below error message.

ERROR
-----------------------
ERROR: The segment value cannot be Essbase restricted reserved word: AND
ERROR :: Validation failed for value:AND
There were some invalid values found during processing of imported value set values.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Submit Import Segment Values and Hierarchies to refresh COA
2. check the log

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot refresh the chart of account hierarchies and values.

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