Today we are going to see how to bulk upload lookup values in Oracle Cloud.
Prepare the DAT file
First prepare the DAT file with list of lookup values that needs to be loaded.
Below are the mandatory and optional attributes for the DAT file.
Sample DAT File
Upload the DAT file to the UCM server
Go to Tools > File Import and Export
Click Upload (+) Icon
Upload the file and then do “Save and Close”
Import the uploaded file
Go to Setup and Maintenance > Search for “Manage Common Lookups” task
Search for the lookup type > Select the lookup type which you want to update > Click on “Actions” and then click “Import”
Select the appropriate “Account” and key in the Lookup Code File Name and then click upload.
Below is the log file output and all the 3 records loaded successfully.
Please provide your feedback and suggestions in the comments section.
Comments
Post a Comment