Create and Populate Sustainability Value Sets

For each attribute of an activity type, you must create a value set and then populate its values.

Note: To perform this procedure, you must be assigned a role to access the Manage Sustainability Value Sets task.

1. In the Setup and Maintenance work area, go to the Manage Sustainability Value Sets task:
   • Offering: Manufacturing and Supply Chain Materials Management, Product Management, or Procurement
   • Functional Area: Sustainability

2. On the Manage Sustainability Value Sets page, click the plus icon to create a value set.

3. On the Create Value Set page, enter the required details. The following steps provide sample values for creating a value set for the Fuel Type attribute:

   1. Enter a value set code. For example, FUEL_TYPE.

   2. Optionally, enter a description.

   3. In the Module field, enter Environmental Activities Management.

   4. From the Validation Type drop-down list, select Independent.

      Note: When creating value sets for use with the Emission Factor Map descriptive Flexfield, use only the validation types Table or Independent. If you select Independent, then ensure to populate the acceptable values in the Manage Values page.

   5. From the Value Data Type drop-down list, select Character.

   6. In the Definition section, from the Value Subtype drop-down list, select Text.

   7. In the Maximum Length field, enter 150.

4. Click Save.

5. On the Create Value Set page, click Manage Values.

6. On the Manage Values page, click the plus icon to create a value.

7. In the newly added row, enter the desired values. If a value exceeds the 150-character limit, then capture the extra information in the Description field. Leave the Description field blank unless it differs from the value.

8. Repeat Steps 6 and 7 to add more values. For example, for the Fuel Type value set, you can enter the values Gasoline, Crude Oil, and Diesel.

9. Click Save and Close twice to save the values and its value set.

Tip: If you want to create and populate value sets in bulk, then extract and use the published Oracle Visual Builder Add-in for Excel spreadsheet for value sets from the Published VB Add-in Spreadsheet.zip available on Oracle Cloud Customer Connect.

Before you use this spreadsheet, ensure that you've downloaded and installed Oracle Visual Builder Add-in for Excel from here: https://www.oracle.com/downloads/cloud/visual-builder-addin-downloads.html.