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