HCM Common lookup Upload
Many times we face a requirement like we need to bulk upload common lookup values in oracle fusion. Below method we can use for bulk upload of lookups.
Step 1: Prepare a .text file with required data and with meaning full lookup type name
LookupType|LookupCode|DisplaySequence|EnabledFlag|StartDateActive|EndDateActive|Meaning|Description|Tag
POSITION|P1|1|Y|01/01/1951|31/12/4712|P1|POSITION01|
POSITION|P2|1|Y|01/01/1951|31/12/4712|P2|POSITION02|
POSITION|P3|1|Y|01/01/1951|31/12/4712|P3|POSITION03|
Step 2: Upload the text file to oracle fusion application
Navigation: Tools >> File Import and Export >> Under Search Results click on "+" icon to add new file
File: Choose the text file
Account: crm/accessGroups/import
Step 3: Now Import the text file which we uploaded
Navigation: Navigate to Manage Common Lookup and select the lookup code for which we need to bulk upload.
Under Actions >> Import and select the file name along with file format(Example: POSITION.txt) >> select the account then click OK.
Now are the lookup values will be uploaded for that particular lookup type.
0 Comments