IT Audit - Governance, Risk, and Compliance Topic for Oracle Applications - page 287

4. In the Default Value field, type an entry appropriate for the selection that

you made in the Default Type listbox:
° If you select Static , type the value that serves as the default.
° If you select Form , identify the field that returns a default value.
Use the format BLOCK_NAME.FIELD_NAME —the internal
names for the block that contains the field and the field itself.
° If you select SQL , type a SQL statement that returns values for use
as defaults.

5. Ensure that the Active checkbox is selected.

Creating and modifying lists of values
You can both alter existing lists of values or create new LOVs. Before you do so, you
must run the Event Tracker on fields for which you want to create or modify LOVs.

Altering an existing LOV
In order to alter an existing List of Value (LOV) select the field and then modify the
SQL statement that compiles the values displayed in the field. However, you cannot
modify the SELECT portion of the SQL statement, which identifies the database
columns that return values to the LOV.

You can alter only the where and sort by portions of the statement, which specify
the conditions under which records are selected to be returned, and the order in
which they are arranged.

1. In Form Rules, ensure that you have created a rule and rule element that

you want to use to modify the LOV. The element must select, as a target, the
form on which the LOV exists. (It is often the case that this element would
use When New Form as an event. If so, the form is all you need to select as a
target. If you choose an event that requires you to do so, also choose a block
and/or a field).

2. Navigate to the form that contains the LOV you want to change, and click in

the LOV.