How to Mass Update Value Set Values in Oracle Fusion

How to Mass Update Value Set Values in Oracle Fusion

In this post , We will be discuss about how we can Mass Update Value Set Values in Oracle Fusion. Oracle fusion has given the feature to mass updates the value set values informations in oracle fusion. This feature will help to create or update the value set values in oracle fusion. The good part of this feature is , it automatically identify the new and existing value set values and create and update according in oracle fusion. Some time we do require to mass changes the value set values so this is on of the great feature provided by oracle fusion. Please find below the detail steps to Mass Update Value Set Values in Oracle Fusion.

Step by Step to Mass Update Value Set Values in Oracle Fusion

Step1:- Flat Files format to Import Mass/bulk import values set values. We need to prepare the data as per these files.

Flat Files format for Mass update Value Set Values 

Flat Files format for Mass update Dependent Value Set Values 

Step2:- Need to prepare the Value set values as per the above format and then save as .csv file format.

Step3:- 

Upload the flat file created in the above Step 1 to the content repository using the File Import and Export UI. Following are the steps :

 Login to Oracle Fusion and go to 'File Import and Export ' option as below.

Click on the Actions menu and select Upload.

It will launch a popup, choose the flat file and Account.

Click on 'Save and Close' to complete the Upload.

 Browse local drive to select the Value set values flat file save as .csv format.

 Select Account – prc/supplier/import -- We can Select any account-- 

Click Save and Continue.

Step4:- Once the Value set file Imported in Oracle fusion application we need to go to Setup and Maintenance.

Go to Manage Value Sets setup task in the Setup and Maintenance work area. To import the file

1. Search the Value Set .
2. Select the Value Set in Search Results table .
3. Select Import from Actions menu.
4. In the File Name field, enter the name of the flat file you uploaded using the Files for Import and Export page.
5. In the Account field, select the user account containing the flat file. Refer the above step 2.e for the account selected while uploading to content repository.
6. Click on Upload.

In the File Name field, enter the name of the flat file you uploaded using the Files for Import and Export page.

In the Account field, select the user account containing the flat file. Refer the above step 2.e for the account selected while uploading to content repository.