How to Create a Value Set in Oracle Fusion

Open Setup and Maintenance

1. From the Oracle Fusion home screen, open the navigation menu.
2. Select Setup and Maintenance. This area lets you configure and manage application settings.

Switch to the Procurement functional area

1. In Setup and Maintenance, find the functional area dropdown at the top left of the screen.
2. Open the dropdown and select Procurement.

Search for value set tasks

1. In the Search Tasks field, enter Value Set.
2. Review the results. They list value set management tasks grouped by application context, such as Financial Reporting Structures, Suppliers, Purchasing Foundation, and Self Service Procurement.

Select the Self-Service Procurement value set task

Self-Service Procurement offers two tasks, and either one can create a value set:

• Manage Requisition Value Sets
• Manage Information Template Value Sets

This guide uses Manage Information Template Value Sets. Select it to open its management screen.

Start a new value set

The management screen contains:

• A search panel with the fields Value Set Code, Validation Type, Value Data Type, Module, and Description.
• A results table for existing value sets.
• A toolbar with Actions, View, Format, and a plus (+) icon.
• Tabs for Key Flexfield Usages, Descriptive Flexfield Usages, Extensible Flexfield Usages, Value Set Usages, and Related Value Sets.

To create a value set, choose one of these methods. Both open the form for a new value set.

• Click the plus (+) icon above the results table.
• Open the Actions dropdown and select Create.

Enter the value set code and description

1. In the Value Set Code field, enter a code that matches the length of the attribute column in your database table. You can expand the code for clarity. For example, enter 150_CHARACTERS.
2. In the Description field, enter a meaningful description, such as 150 Characters.

Associate a module with the value set

1. Optionally, click the dropdown next to the Module field.
2. In the module selection dialog, search for the module. For example, use the User Module Name search box.
3. Select the module, such as Self Service Procurement Common Components, and click OK.

Set the validation type, data type, subtype, and maximum length

Configure the format of the value set:

• Set Validation Type to Format Only if you do not want to store any values in this value set.
• Set Value Data Type to Character.
• Set Value Subtype to Text.
• In Maximum Length, enter 150.

Set optional minimum, maximum, and zero fill options

1. If needed, specify minimum and maximum values. This guide leaves them blank.
2. To pad entered values with zeros up to the maximum length, select the Zero fill checkbox. This guide leaves it unchecked.

Review the value set configuration

Confirm that the Create Value Set screen shows these values:

• Value Set Code: 150_CHARACTERS
• Description: 150 Characters
• Module: Self Service Procurement Common Components
• Validation Type: Format Only
• Value Data Type: Character
• Value Subtype: Text
• Maximum Length: 150
• Minimum Value: blank
• Maximum Value: blank
• Uppercase only: unchecked
• Zero fill: unchecked

Save the value set

Choose one of these options:

• Click Save to save your work and stay on the form.
• Click Save and Close to save the value set and exit the form.
• Click Cancel to discard your changes.

You cannot manage values for the value set until you save it.

Return to Manage Information Template Value Sets

After saving, go to the Manage Information Template Value Sets screen. Use its search panel to confirm that your new value set exists. The results area is empty until you run a search.

Search by value set code

1. In the Value Set Code field, enter the code you want to find, such as 100 or 100_CHARACTERS.
2. Click Search.
3. If no results appear, adjust your search criteria.

Use wildcards or a partial code

If an exact code returns nothing, try a wildcard such as 100% or a partial code. Click Search again to refresh the results.

Search by module

If you still do not see the value set, use the Module dropdown to select or enter Self Service Procurement Common Components. This narrows the search to value sets associated with that module.

Confirm the value set in the results

Check that your value set appears with these details:

• Value Set Code: 150_CHARACTERS
• Description: 150 Characters
• Module: Self Service Procurement Common Components
• Validation Type: Format Only
• Value Data Type: Character

This confirms that the value set was created and is available in the system.

Review value set usages

1. Select 150_CHARACTERS in the search results.
2. Review the tabs in the lower section: Key Flexfield Usages, Descriptive Flexfield Usages, Extensible Flexfield Usages, Value Set Usages, and Related Value Sets.
3. The Key Flexfield Usages tab is active by default. It shows columns for Application, Key Flexfield Name, Key Flexfield Code, Description, and Deployment Status.

Every usage tab shows "No data to display". This means the value set is not yet used in any flexfield or related value set.

If the value set is used later, its usages appear in the matching tab, such as Key Flexfield Usages or Descriptive Flexfield Usages.