1. Administering and Working with Oracle Enterprise Data Management Cloud
  2. Administration
  3. Working with Properties
  4. Editing Property Parameters
  5. Defining Allowed or Invalid Values for a Property

Defining Allowed or Invalid Values for a Property

Some data types let you specify that a property is restricted to a set of values (Allowed Values) or cannot be equal to one of a set of values (Invalid Values). The following example shows an Account Type property configured to allow only values of Asset, Equity, Expense, Liability, and Revenue:


The allowed values for an Account Type property.
You specify the values that are allowed or invalid for a property from the property parameters page in the property inspector. See Editing Property Parameters.

Note:

For custom properties in Universal applications only, you can also specify allowed values on the Property for Dimension Node Type page, which displays when you are adding or modifying a property. See Creating a Custom Property.

To specify that a property allows only certain values or cannot have a certain value:

  1. (Allowed Values only) To enable the use of allowed values, perform these actions:
    1. Select the Use Allowed Values List check box.
    2. The Include Blank Entry option is selected by default. This adds a blank to the list. If you do not want to include a blank entry for users to select, clear this option.
  2. To specify the Allowed or Invalid values, in the Allowed Values or Invalid Values text box, perform the following steps for each value that you want to specify:
    1. Click Add new row + and then enter the value and display text in the new row.
      When you press Enter or Tab, the Remove allowed value button button appears next to the value. Click the button to remove that entry.

      The following example shows how the Account Type property is defined to allow only values of Asset, Equity, Expense, Liability, and Revenue:


      The list of allowed values for the Account Type property.
    2. Optional: Click Sort by sort by button to perform a one time sort of the Allowed Values list alphanumerically by either Value or Label.
    3. To reorder items in the list, in the Action column click Action select icon and then select the position for the item.
    4. To clear all items from the list, click Action select icon and then click Clear.
    5. To import or export a list of allowed or invalid values, click Action select icon and then click the appropriate option. You can import and export values to an Excel file.