Unable To Import Lookup & Related Value Map
(Doc ID 2203723.1)
Last updated on JUNE 08, 2023
Applies to:
Oracle Fusion Sales Cloud Service - Version 11.1.11.1.0 to 11.1.11.1.0 [Release 1.0]Information in this document applies to any platform.
Symptoms
Need to import lookup & related value map of Parent Choice List for address-province/city/county
In some cases, need to input massive code manually (ie. province/city/county), also with the value map of Parent Choice List.
Now, need to input address (province/city/county) information to opportunity.
In this case, need to input 3 Fixed Choice List fields (that's 3000+ city data) and config 2 value maps of Parent Choice List all manually.
So is it possible to find a way to import value map of Parent Choice List using file-based import?
Already checked the KM article - <Note 2127385.1> - Oracle Sales Cloud: How to Import Lookup Types and Lookup Codes Using File-Based Import
However it never succeeds
a. Lookup Type file ===>
LookupType|Meaning|Description|ModuleKey|ModuleType
CPROVINCE|c province|¿¿¿¿¿¿|APPLICATION|FND
And in the Lookup Codes file, used only 4 rows for testing ===>
LookupType|LookupCode|DisplaySequence|EnabledFlag|StartDateActive|EndDateActive|Meaning|Description|Tag
CPROVINCE|110000|1|Y|01/1/1900|31/12/4712|¿¿|¿¿|Province_1
CPROVINCE|120000|2|Y|01/1/1900|31/12/4712|¿¿|¿¿|Province_2
CPROVINCE|130000|3|Y|01/1/1900|31/12/4712|¿¿¿|¿¿¿|Province_3
CPROVINCE|140000|4|Y|01/1/1900|31/12/4712|¿¿¿|¿¿¿|Province_4
b. Followed exactly the steps as is in the attachment document in the <Note 2127385.1> - Import_Lookup_Values_Using_File-Based_Import.pdf
c. In the "File Import and Export" > Upload > choosing the Account field value as "setup/functionalSetupManager/import"
d. And in the Setup and Maintenance, trying to import inside "Manage Standard Lookups" Task
Still do not see this import completing successfully.
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 |