Loading Bulk Values into a Value Set in Oracle Fusion

Managing large volumes of values in a Value Set can be time-consuming if done manually. Oracle Fusion provides a convenient way to bulk load values using the File Import/Export functionality. This guide walks you through the step-by-step process.

Step 1: Prepare the CSV File

Create a .csv file with the following structure:

Format Requirements:

• File type: .csv
• Delimiter: |
• Columns:

ValueSetCode|Value|Description|EnabledFlag

XXAB_VALUE_SET|AB Care Mgmt|AB Care Management|Y

XXAB_VALUE_SET|AB Heart Dx|AB Heart Center Diagnostics|Y

XXAB_VALUE_SET|AB Strat Plan|AB Strategic Planning|Y

XXAB_VALUE_SET|AB Hou Adm|AB Houston Administration|Y

XXAB_VALUE_SET|AB A&I|AB A&I Services|Y

Make sure:

• The ValueSetCode matches exactly with the existing Value Set
• EnabledFlag is either Y or N

Step 2: Upload File Using File Import/Export

1. Login to the Oracle Fusion Application (Prod)
2. Navigate to:
   Tools → File Import and Export  
3. Click on the ( + ) icon to upload a file

1. Select your prepared .csv file
2. Enter the account as:
   hcm/dataloader/import
3. Click Save and Close

Step 3: Navigate to Value Sets

1. Go to Setup and Maintenance
2. Search for the task: Manage Value Sets

Step 4: Import the Values

1. Select the Value Set
2. Click on Actions → Import
3. Enter:
   • File Name: Same as uploaded in Step 2
   • Account: hcm/dataloader/import
4. Click Upload

Step 5: Monitor the Upload

• The system will process the file and display the progress
• Once completed, a log file will be generated