492 total views
In this article we will look into loading Valueset values for Independent/Dependent type Valuesets.
Normally we have to add them on the application as there is no HDL available for this business object.
Note: We cannot create Valuesets with this approach. We can only load values to existing Valuesets. So, Valuesets needs to be created manually and then we can load values.
Now we will look into the file structure for loading Valuesets. The file should be a pipe (|) delimited format with all required attributes having values in UTF-8 encoding format. The file extension can be any one of these .dat/.txt/.csv
If you don’t know the basics of Value Sets, please go through the below posts:
The requirements for creating flat files vary with the type of Value Sets:
- Independent value sets
- Dependent value sets
File Format for Independent Valuesets:
File Format for Dependent Valuesets:
Sample Files with different options:
ValueSetCode|Value|EnabledFlag|StartDateActive|SortOrder ABC Account Set|12345|Y|1911-01-01|1 ABC Account Set|23456|Y|1911-01-01|2 ABC Account Set|34567|Y|1911-01-01|3
ValueSetCode|Value|EnabledFlag ABC_DEPARTMENT|Finance|Y ABC_DEPARTMENT|Database Technology|Y
ValueSetCode|Value|Description|EnabledFlag|SortOrder|StartDateActive|EndDateActive ABC_LOC_SET|NEW YORK|New York|Y|110|1951-01-01|4712-12-31 ABC_LOC_SET|LOS ANGELES|Los Angeles|Y|111|1951-01-01|4712-12-31
ValueSetCode|IndependentValue|Value|EnabledFlag ABC Account Child Set|12345|ABCDEF|Y ABC Account Child Set|12345|BCDEFG|Y ABC Account Child Set|23456|POIUYT|Y
Once the input file is prepared we can load this file using the below steps:
Upload File to UCM:
Navigate to Tools > File Import and Export
Browse for the input file and select the Account as hcm/dataloader/import and click Save and Close
Now, Navigate to Setup and Maintenance > Manage Value Sets
Create the Value Set “ABC Account Set“. We will have to do this manually as the process just loads the values to this value set.
Now get back to Manage Value Sets task > Click on Actions > Import
Provide the exact input file name, account and click on upload.
Once it is successful, download log file and check if there are any errors.
As the processing is successful without any errors, we can validate the values for the Value Set.
Search for the Value Set Name in Manage Value Set task:
We can see that Value Set values have been loaded successfully.
Note: We can only load the Value Set Values and not the Value Set structure.
Latest posts by Sricharan Monigari (see all)
- Migration of Objects – Valuesets, Lookups, Fast Formula, Payroll Flows from one POD to another - November 30, 2020
- Renaming HCM Extracts is a possibility from 20D - November 24, 2020
- Sangam20 – Oracle Users Group Conference - November 23, 2020
- Passing Parameter values from Flow Instance to HDL Transformation Formula - November 23, 2020