1. Configuring and Extending Applications
  2. Import Value Set Values

Import Value Set Values

You can import a file containing values that you want to edit or add to a given independent or dependent value set.

For example, uploading hundreds of values might be more efficient than creating them individually using the Manage Value Sets task. However, for just a few values, it might be quicker to perform the relevant tasks. Here are a few things you need to keep in mind while creating these files:

  • Use a vertical bar or pipe ( | ) as a delimiter between fields for both the header and the value rows.

  • As per the Oracle Fusion Cloud WebCenter Content specification, set the file encoding to UTF-8 without the Byte Order Mark (BOM).

  • Make sure that the first line in the file is a header line, and the files look exactly the same as shown in the sample file.

Here's a sample file for value set value. You can see the header values at the beginning of the file, followed by the line entries of the two value set codes that are to be imported.

VALUESETCODE|VALUE|ENABLEDFLAG
FLEX_KFF1_IND_CHR_L10_ZEROFILL|5000|Y
FLEX_KFF1_IND_CHR_L10_ZEROFILL1|5001|N

To import value set values, do these tasks:

  1. Create a flat file containing the values in the value set that you want to add or update.

    When creating the file, you must specify an existing value set code to which you want to add values or edit existing values. If the value set does not exist, add the value set using the appropriate Manage Value Sets task in the Setup and Maintenance work area.

  2. Upload the flat file to the content repository using the File Import and Export page.

  3. Import the file using the appropriate Manage Value Sets task in the Setup and Maintenance work area. To import the file, do these tasks:

    1. In the Manage Value Sets page, click Actions > Import Related Values.

    2. In the Account field, select the user account containing the flat file.

    3. In the Related Value Set File Name field, enter the name of the related value set file you uploaded using the File Import and Export page.

    4. In the Related Values File Name field, enter the name of the related values file you uploaded using the File Import and Export page.

    5. Click Upload.

    Note:
    Alternatively, you can import the file using either of the following methods:

    • Run the Upload Value Set Values scheduled process.

    • Use the Applications Core Metadata Import web service. For more information on the Applications Core Metadata Import web service, see the SOAP Web Services guide for your cloud services.

Related Topics