Mass/Bulk upload value set values in oracle Fusion

Mass/Bulk upload value set values in oracle Fusion

In this post , We will be discuss about how to Mass upload value set values in oracle Fusion. We can import or upload the mass values set values in oracle fusion. Oracle fusion has give the feature of flat files , which helps to import the mass value set values. We can insert or update the value set values using this feature in oracle fusion. I will share the details steps to import mass value set values in oracle fusion. Please find below the detail about Mass upload value set values in oracle Fusion.

Types of Value sets in Oracle fusion

Dependent Value set 

Independent Value set

We can upload the mass values for both these types of value sets in oracle fusion.

Details Steps to Import Mass 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 Uploading Independent Value Set Values 

Flat Files format for Mass Uploading 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.

Mass/Bulk upload value set values in oracle Fusion