Query Based Data Element (QBDE)

A Query Based Data Element (QBDE) lets you view data from the Upper Form or Detail form of a Business Process. QBDE also lets you view data from:

Other Business Processes
Sheets
Cash Flow

The QBDEs are based on the “SYS Numeric Query Based” Data Definition (DD), and the query for these QBDEs is set in the Business Process Configuration setup. For more information, see Configure a Query for a Query Based Data Element on a BP in the Unifier Modules Setup Administration Guide.

In addition to the Web interface (Unifier application in the browser), the system evaluates QBDE in the following areas:

CSV import for record creation
CSV import for Line Item creation
Web Service methods for record creation along with Line items
Web Service methods for Line Item creation
Web Service methods for record updates
Bulk Edit
Bulk Update
Creating BP records using BP
Note: Oracle recommends that you do not use a Required field to create a query that uses a Data Picker, Cost Breakdown Structure (CBS) Picker, or Fund Breakdown Structure (FBS) Picker. If the data entered in a data element (DE) field with a Required condition is cleared, the system bases the query on the previous value of the field.

Evaluating Query Setups of Data Picker Data Elements

The system supports many types of Data Picker DEs. The Administrator can set up Query conditions on these Data Picker DEs to filter the results. When a Data Picker DE is launched in the Web interface, the system runs the query and displays the records based on the queries defined in uDesigner. The system evaluates the data picker query conditions in the following areas, as well:

CSV import for record creation
CSV import for Line Item creation
Web Service methods for record creation along with Line items
Web Service methods for Line Item creation
Web Service methods for record updates

The following is a list of the supported Data Pickers:

BP Data Picker
Shell Data Picker
User Data Picker
CM Data Picker
Role Data Picker

Note: If a BP Data Picker (BP Picker) or any Data Picker is selected as a trigger element for QBDE and the picker value is automatically populated (auto populated) instead of manual entered, the QBDE element will not be evaluated.

For more information about importing data, see Importing Configuration Packages in the Unifier Modules Setup Administration Guide.

Creating a Record from the Query Based Tab

When creating a record from the Query Based tab of another BP (that auto-populates data to the record being created), the Data Element (DE) of type “SYS Numeric Query Based” Data Definition (any DE of this type) is not updated, unless the user manually changes the trigger element.

If a query condition involves only constant dates, it is not converted based on the user's timezone.

Evaluating Query Setups of Data Picker Data Elements

Creating a Record from the Query Based Tab

See Also