How to load Value Set values using File Import/Export or ESS process in Oracle HCM Cloud environment

Step 1 : Create a text file (example : ABC_Value_Set_Value_Load.txt) with the details as below :
Note : 1st line below is the Header and next line onwards (Data Lines) pass the details of the values for the Value Set Code. File details are as below :

ValueSerCode|Value|TranslatedValue|Description|EnabledFlag|StartDateActive|EndDateActive|SortOrder
ABC|9999 9999 9999 9999||Test ABC1|N|1901-01-01|4712-12-31|1
ABC|9999 9999 9999 9998||Test ABC2|N|1901-01-01|4712-12-31|2
ABC|9999 9999 9999 9997||Test ABC3|N|1901-01-01|4712-12-31|3

Step 2 : Now navigate to Home --> Tools --> File Import and Export

Step 3 : Under the Search Results section click on the "+" button and the Upload File popup will appear.

Step 4 : In the popup, click on the "Choose File" button and select the Value Set value file (ABC_Value_Set_Value_Load.txt) from the correct location.

Step 5 : In the popup, click on the "Account" dropdown and select the UCM location where the file should be uploaded.
         Generally I select "hcm/dataloader/import" location as we are going to import the values in our HCM Cloud environment.

Step 6 : Once the file and the Account details have been selected, click on "Save and Close" button.

Step 7 : Now we have 2 options to load the Value Set values in our HCM Cloud environment.

Option 1 : Using ESS process
 a> Navigate to Home --> Tools --> Scheduled Processes
 b> Click on the "Schedule New Process" button and search for the ESS job named "ESS process for value set values upload".
 c> Select the process and click on "OK" button. Then you will find 2 input parameters.
  1> File Name : Pass the name of the file has been uploaded in UCM (ABC_Value_Set_Value_Load.txt)
  2> Account : Pass the name of the Account of the UCM (hcm/dataloader/import)
 d> Now click on the "Submit" button to submit the process.
 e> Once the process is completed, please check the log file for the load details.

Option 2 : Using "Manage Value Sets" navigation
 a> Navigate to Setup and Maintenance --> Tasks --> Manage Value Sets
 b> Under the "Search Results" section, click on the "Action" button.
 c> Once the "Action" button is clicked, click on the "Import" button.
 d> Pass the File Name (ABC_Value_Set_Value_Load.txt) and Account information (hcm/dataloader/import) as requested.
    Then click the "Upload" button.
 e> Now the import process will start and once the process is completed, check the log file for load details.