1. Configuring and Extending Applications
  2. Import Related Value Sets

Import Related Value Sets

You can import related value sets to your application by creating separate text files containing the related value set and related values. You can then upload these files to the Oracle Fusion Cloud WebCenter Content document repository.

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 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 related value set. You can see the header values at the beginning of the file, followed by the line entries of the two value set codes to be imported.

VALUE_SET_CODE1|VALUE_SET_CODE2|ENABLED_FLAG
FLEX_KFF1_IND_CHR_L10_ZEROFILL|FLEX_KFF1_IND_NUM_P6_S0|Y
FLEX_KFF1_IND_CHR_L10_ZEROFILL|FLEX_KFF1_IND_CHR_L2_STATES|N

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

VALUE_SET_CODE1|VALUE_SET_CODE2|VALUE1|VALUE2|ENABLED_FLAG
FLEX_KFF1_IND_CHR_L10_ZEROFILL|FLEX_KFF1_IND_NUM_P6_S0|1234567890|0|Y
FLEX_KFF1_IND_CHR_L10_ZEROFILL|FLEX_KFF1_IND_CHR_L2_STATES|1234567890|AK|Y

To import related value sets, do these tasks:

  1. Create flat files containing the values and the related values in the value set that you want to add or update.

    When creating the files, you must specify an existing value set code and values. If the related value sets don't exist, add the related value sets using the appropriate Manage Value Sets task in the Setup and Maintenance work area.

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

  3. Import the files 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.

If you upload the related value set file along with the related values file, first the related value set file is processed and then the related value file is processed. If the relationship between two value sets doesn't exist then a new relationship is created in the FND_VS_RELATED_VALUES table. Otherwise, the Enabled column is updated.

Related Topics