We’ll talk about the Oracle cloud utility, which makes it easy to bulk upload lookup information to already-running systems. We may also generate a new Oracle Fusion lookup with the aid of this tool. Maintaining hundreds of lookup values in the current system lookup manually would be a laborious and time-consuming task, so Oracle Cloud provided us with the FBL capability as a solution (File based loader). To import the script into the Oracle cloud application, we only need to prepare it in the FBL .CSV file format. Bulk Import Lookup values are immediately imported into Oracle cloud after file import. This is a good way to bulk upload lookup values to Oracle Fusion. The specific steps to upload lookup values in bulk to Oracle Fusion are listed below.
1. Before starting import process one basic steps needs to perform to avoid error while importing FBL CSV file with lookup values.
- a. Go to ‘Control Panel’ > view by ‘Small Icon’ > Click ‘Region’ > Click tab ‘Formats’ > Click ‘Additional Settings…’ > Tab ‘Numbers’ > Set List Separator field as ‘|’ and choose Measurement System as ‘Metric’
2. Create CSV file with below text in notepad and save it as .CSV and make sure file type is ‘All Types’ during saving.
LookupType|LookupCode|DisplaySequence|EnabledFlag|StartDateActive|EndDateActive|Meaning|Description|Tag
- a. open the csv file and prepare the data to import, make sure no extra blank rows in csv file
3. Once the CSV file is ready go to > Tools > File Import and Export
4. click on ‘+’ icon to create new upload > select csv file from your local system > select appropriate account name from the list > click ‘Save and Close’ button
5. Click on Setup and Maintenance > Click on Global Search
6. Search for > Manage%Standard%Lookups%
7. Search for Lookup type in which you want to import new values > LEGAL ENTITY
- Select “Import” option from search result to import CSV file.
8. Select appropriate account name from list > enter lookup code file, enter file name which you imported in step-4 > click on “upload” button
Once file is uploaded it will show you log file to download, log file has success or error record information.
Congratulation you are now strong enough to load FBL CSV file to import bulk Lookup values in Oracle Fusion:)