Introduction: This process would overview bulk load of Lookup Type & Lookup Codes in Oracle fusion.
Cause of the issue: When there is a need of entering bulk values in to a Lookup in Oracle fusion how can this be achieved.
How do we solve: Entering all the values of the lookup type and code into the application manually will consume a significant effort during data migration. It may result in wrong data entry which could lead to other application issues. Apart from this, the data entry activity has to be repeated in other instances of applications.
Oracle fusion’s File import and export feature provides a faster way of loading the lookup type and codes which helps consultants overcome the issues that come with manual data entry.
Business Benefits:
- Time and Efforts saved during Data Migration
- Ease of repetition into other instances
- Faster and Correct means of Data Migrated
Step1:
- Prepare the Import file with Lookup data
- The below format contains the information that you should include in your import files for Lookup Types and Lookup Codes.
Sample Lookup File
LookupType|Meaning|Description|ModuleKey|ModuleType
XXX_TYPE| XXX_TYPE_MEANING| XXX_LTYPE_DESC|XXX|XXX_APPLICATION
Sample Lookup Code File
LookupType|LookupCode|DisplaySequence|EnabledFlag|StartDateActive|EndDateActive|Meaning|Description|Tag
XXX_TYPE|XXX_TYPE_CODE|1|Y|04/07/2022|31/12/4712|XXX_TYPE_CODE_MEANING|XXX_TYPE_CODE _DESC|CODE _TAG
Step 2:
- Navigation to upload the files to the UCM Server
Navigation: Navigator >> Tools >> File Import and Export
- Click on the Upload icon and Browse the prepared import file to upload then select ‘setup/functionalSetupManger/import’ from the Account drop-down list.
- Click on save and close
Step 3:
- Import the uploaded data into fusion as lookup data.
- Navigate to Setup and Maintenance >> Global Search >> Manage Common Lookups
- Select import from the Actions menu
- In Import Standard Lookups, select the Account where you imported the files (setup/functionalSetupManger/import).
- Give the Full name of the file to be imported, including the csv extension (For example: XX_Lookup_type.csv) and click on upload
- You can view the progress of the process and you will able to download the process log file when the process has completed.
- Navigate to the lookup field in the user interface to verify that your lookup values imported as expected.
Points to remember:
Create separate files for Lookup Types and Lookup Codes. Files should be of UTF-8 encoding.
