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
Table of Contents
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.
Top 10 Popular Posts from our Knowledgebase
- DataFusing FREE Cloud based SQL Developer like tool for Oracle Cloud
- Core HR Entity Relationship Diagram (ERD) for HCM Cloud
- Most Frequently used Document IDs from Oracle Support
- FREE Oracle Training & Accreditation with Oracle Learning Explorer
- How HDL Transformation Formula works with ElementEntry Sample
- FREE Oracle Fusion Demo Instance (VISION) Access
- Top 10 FREE useful tools for Fusion Consultants
- Learning Fusion HCM Technical Skillset
- Sample HCM Data Loader (HDL) files for all Business Objects
- Most frequently used Tables list in Fusion HCM