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

° 0999 : Number, up to four digits, with leading zeros
° DD-MONTH-YYYY : Date, with month spelt out
° DD-MON-YYYY HH24:MI:SS : Date and time, with month
abbreviated

• Height : Sets the vertical dimension of the field. Type a number of pixels.
• Hint Text : Creates a message that provides information about the field
in a status bar at the bottom of the screen. Type the message of up to
30 characters.
• Next Navigation Item : Sets the field to which the cursor moves if the user
presses the Tab key. Select from a list of field names.
• Previous Navigation Item : Sets the field to which the cursor moves if the
user presses Shift + Tab . Select from a list of field names.
• Prompt Text : Creates a display name that identifies the field on screen.
Type the label of up to 30 characters.
• Width : Sets the horizontal dimension of the field. Type a number of pixels.
• X Pos : Sets the horizontal starting point for the field from the left of its block.
Type a number of pixels.
• Y Pos : Sets the vertical starting point for the field from the top of its block.
Type a number of pixels.

Field instance attributes
You can set the following field instance attributes:

• Insert Allowed : Determines whether a user may enter data if the field
instance is blank. Select TRUE or FALSE .
• Navigable : Determines whether a user may select the field instance. Select
TRUE or FALSE .
• Required : Determines whether a user must enter data in a field instance.
Select TRUE or FALSE .
• Update Allowed : Determines whether a user may alter existing data in a
field instance. Select TRUE or FALSE .

Creating SQL procedures
You can create SQL statements that are executed when a user performs an action
corresponding to the event you have chosen for a rule element.

1. In order to do so, click on the SQL tab in the Business Rule Details form.

Create any number of statements, one per row in the grid: