How to import lookup values in oracle fusion

How to import lookup values in oracle fusion

In this post, we will be discussing about how to import lookup values in oracle fusion. In Oracle Fusion, we can mass import the lookup values. Oracle fusion has given the tool, which helps to import bulk lookup values in oracle fusion. With the help on this tool, we can also create the new lookup in oracle fusion. If we must 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 methods, to mass upload lookup values in oracle fusion. Here below is the detail steps to import lookup values in oracle fusion.

Step by Step to import lookup values in oracle fusion

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

How to import lookup values in oracle fusion

 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.

How to import lookup values in oracle fusion

Step 6:-  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. 

Step 7:- Verify the Imported data  

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

How to import lookup values in oracle fusion