My Oracle Support Banner

ERROR: Could not find the value:0 in the value set code values (Doc ID 2746978.1)

Last updated on JANUARY 26, 2021

Applies to:

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

Symptoms

On : 11.13.20.10.0 version, Setup, Rapid Impl and Security

When attempting to upload the related values, user has the following error messages


ERROR
-----------------------
ERROR: Could not find the value:0 in the value set code values for row:


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Manage Dependencies Between Chart of Accounts Segments Using Related Value Sets
2. Task: Manage Chart of Accounts Value Sets
3. Import Related Values action from the Manage Chart of Accounts Value Sets page.
4. As a first step, prepare the appropriate .csv files. The first row in the file is the header. The subsequent rows are the relationship records to upload. Values for VALUE_SET_CODE1, VALUE_SET_CODE2 and ENABLED_FLAG must be separated using a vertical bar ( | ).

https://www.oracle.com/webfolder/technetwork/tutorials/tutorial/cloud/r13/wn/fin/releases/20D/20D-financials-wn.htm#F6193


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot upload related values with 0 for a chart of accounts value set.
Customer needs to upload thousands of values and cannot do it manually.

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.