How to Bulk Import Lookup values in Oracle cloud : Script to mass Upload the Lookup Values in Oracle Fusion

How to Bulk Import Lookup values in Oracle cloud : Script to mass Upload the Lookup Values in Oracle Fusion

In this post , we will be discuss about , the Oracle cloud tool , which helps to upload the mass upload the lookup values in existing system lookup. With the help on this tool , we can also create the new lookup in oracle fusion. If we have to maintain hundreds of lookup value in the existing system lookup , then doing manually is quite long and time consuming job so for this oracle cloud given us the feature of the FBL(File based loader). We just need to prepare the script in the FBL .CSV file format and then import into the oracle cloud application. After importing file , cloud application automatically Bulk Import Lookup values in Oracle cloud. This is one of the fine method , to mass upload lookup values in oracle fusion. Here below is the detail steps to mass Upload the Lookup Values in Oracle Fusion.

Step by Step to Bulk Import Lookup values in Oracle cloud

Step1:-For Example this is the System lookup in which i want to add new values .

 Here below is the script if we want to add new value in the existing system lookup.

Here below is the header of the script which do remain common for single cvs file.

LookupType|LookupCode|DisplaySequence|EnabledFlag|StartDateActive|EndDateActive|Meaning|Description|

Here below is script to add new lookup values. If we want to add 5 values then there will be five lines as per below.

LOCATION_ADDRESS_USAGE_TYPE|WIRE|1|Y|22/5/2015|22/5/4712|Wire Transfer|Wire Transfer

LOCATION_ADDRESS_USAGE_TYPE is the name of the Lookup.

WIRE is the new value to add in this lookup.

LookupType|LookupCode|DisplaySequence|EnabledFlag|StartDateActive|EndDateActive|Meaning|Description|

LOCATION_ADDRESS_USAGE_TYPE|WIRE|1|Y|22/5/2015|22/5/4712|Wire Transfer|Wire Transfer

Here below is the Script and we need to save this script in csv file as below.

Step2:- Once file is ready and verified, upload to the UCM server via the File Import and Export tool.  In the Tools section of the Navigator, click the File Import and Export link. 

Step3:- Click the Upload icon in the Search Results section of the page. 

Select setup/functionalSetupManger/import from the Account drop-down list, and then browse to and select your import file.  4. Click Save and Close. 

Step4:- Now to Import That file 

Go to Setup and Maintenance and search the lookup 'Manage Common Lookups' 

Step5:-  Under 'Manage Common Lookups' 

Click on the Actions and Select the Import Option.

Step6:-  In the small Pop up Window that appears, select the Account where you imported the files (setup/functionalSetupManger/import).  

 Give the full name of the file (or files) to be imported, including the .csv extension. (For example, LookUpType_xxx.csv and LookUpTypeCode_xxx.csv.) 

In our case we need to specify just one file as we are importing the codes for an existing Lookup Type. 

Step7:- Verify the Imported data  

Navigate to the lookup field in the user interface to verify that your lookup values imported as expected.