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

3. Run a trace file:
i. Click on Help in the menu bar, then Diagnostics in the Help
menu, and then click on Trace in the Diagnostics submenu. Select
the Regular Trace radio button. If you have not already used a
Diagnostics option, an Enable Diagnostics dialog prompts you for
your Oracle password. Enter it and click on the OK button to clear the
dialog. A note informs you that tracing is activated and provides the
path and name of a trace file. Click on the OK button to clear the note.
ii. In the LOV that you want to change, select any value.
iii. Click on Help in the menu bar, then Diagnostics in the Help menu,
and then click on Trace in the Diagnostics submenu. Select the No
Trace radio button. (Another message informs you that tracing is
deactivated and provides the path and name of a trace file. Click on
the OK button to clear the note.)
iv. Open Form Rules and use a utility called TKProf to examine your
trace file.
vii. Click on GRC Controls Utilities in the menu bar, and then on Oracle
Rules TKProf Utility in the GRC Controls Utilities menu.
vi. A concurrent request runs, and a message informs you of its
identification number. Make a note of the number and click on the
OK button to close the message.
vii. Click on View in the menu bar, and then on Requests in the
View menu.
viii.A Find Requests form will open. Click on the Specific Requests
radio button and, in the Request ID field, enter the ID number for
your request. Click on the Find button.
ix. A Requests form will appear. Its grid contains an entry for your
request. When its status is set to Completed (you may need to click
on the Refresh Data button), click on the View Log button.
x. In the log file, search for the SQL statement that generates values
for the LOV. (Typically, it begins as "select displayed_
field,description,lookup_code_from" .) Leave the log file open.

4. In Form Rules, select the rule and element you want to use to modify

the LOV.

5. Click on the Details button and in the Business Rule Details form, click on

the List of Values tab: