Creating a Dynamic Data Set

To create a dynamic data set:

  1. Go to the Company Workspace tab and switch to Admin mode.
  2. In the left Navigator, click Data Structure Setup > Dynamic Data Sets.
  3. Click New to open the Properties window.
  4. On the General tab, enter a name and description for the data set.

    Use alphanumeric characters only; no special characters or spaces.

  5. In the Master Data Element field, click the Select button and choose the data element (field) that will control the content and behavior of the other data elements (fields) in this set. The Select list will show only those data elements that are pull-downs or radio buttons.

    For example, you could use a radio button for "Attachments" as a Master Data Element to enable additional options for a user to choose. If the user clicks the Attachments button, additional radio buttons become active so the user can choose what type of attachments to include.

    • The Status data element, as well as all standard data elements, cannot be used as a master data element.
    • Data elements based on the Data Picker data definition cannot be used as the master element.
    • You can make the Master Data Element Editable, Editable (Required), or Read-Only in uDesigner.
    • After you have chosen the master data element, uDesigner will show the Data Definition and Form Label of the master element.
  6. Click the Value Set tab.
  7. To add the other elements to the data set, click the Add button.

    The Select Value Set Data Element window opens, showing a list of those elements available for dynamic data sets—pull-downs or radio buttons.

    The elements you select here are the elements whose values will be controlled by the master element. For example, if the master element is "country," then a value set might be a pull-down list of states that belong to the country.

    • The elements you select for a value set cannot be used as part of a behavior set.
    • If any field in the value set is marked "required," the master element must also be marked "required."
    • Data elements based on the Data Picker data definition cannot be used in a value set.
  8. Select In a Business Process, auto-select the value if there is only one value in the Value Set data element so the system auto-selects the data in the Value Set DE, if there is only one possible value. See below for more details.
  9. Select the elements and click OK.
  10. Click the Behavior Set tab, then click the Add button.

    The Select Behavior Set Data Element window opens, showing a list of those elements available for dynamic data sets.

    The elements you select here are the elements whose behavior will be controlled by the master element. These are the elements that will be either required or disabled by the master element, and they must be marked "editable" on the form.

    For example, if the master data element is Attachments, as in the example in step 4, the elements whose behavior is controlled would be Text Files, Video Files, and emails.

    Note: Do not use asset codes in a behavior set.

  11. Click OK.

Before Modifying a Dynamic Data Set

If you need to change a dynamic data set, Oracle recommends that you see where it is used first, as the changes you make can affect business processes in ways you might not expect.

To see where the data set is being used, highlight the data set in the log and click the Usage button in the toolbar. uDesigner displays a list of all business processes and other forms that are currently using the set.

Note: Be aware that if you change a dynamic data set that is already on a form, the changes you make to the set will not cascade to the form. You must delete the set from the form, save the form, then insert the fields again and click the Dynamic Data Set button.

Select In a Business Process, auto-select the value if there is only one value in the Value Set data element Option

If this option is selected, then at runtime the Value Set pull-down DE value will get auto-selected if it has only single value to select. The same function will apply if the Value Set DE has only one value to select. The existing DDS does not have any impact on the existing behavior, unless the user changes the selection at DDS setup level. If the Value Set DE has only one value to select, then the user will not be able to change or clear this selection.

In User mode, all the following BPs that can have DDS on their Upper Form or Detail Form, or both, will be impacted by this selection:

The following BPs will not be impacted by this selection:

The BP Templates that have been created after the 22.10 release will have auto-selection of the Values Set DEs, if the option is selected. The BP Templates created prior to 22.10 will remain unchanged; however, you can edit these templates to have auto-selection of the Values Set DEs.

RESTful Web Service

When the user creates, or updates, a BP record through RESTful web service call, if the input request-file has a value for the Master Data Element field and if the Value Set pull-down value has only one value in the hierarchy of DDS, then the system will auto-select the only value on the BP form. If the Value Set DE has only one value to select, then the user will not be able to change or clear this selection.


Last Published Monday, June 3, 2024