HCM Common lookup Upload

 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.


Post a Comment

0 Comments