This chapter contains the following topics:
You use event rules in Oracle's JD Edwards EnterpriseOne to create logic statements without the difficult syntax required by most programming languages. Event rules process when an event, such as a page break, is encountered.
Events execute in a specific order during the processing of the report. Events are attached to objects, such as fields, sections, and reports. Where the cursor is positioned in the report when you access Event Rules Design determines the set of events that is presented.
When you create the logic that the system uses to manage processing option values, you must consider the purpose of the processing option attached to the report template. The purpose of the processing option helps you to determine on which section and which event to place the logic.
Some processing options must be read before fetching data from the database because they affect which records are fetched. Other processing options might determine whether a level break section appears in the report. You should understand the process in which the system processes sections and events so that the logic provides the intended result.
If the processing option template determines the data to be fetched from the database, you typically place the associated event rules in the Initialize Section event of the affected detail section. For example, if the processing option is prompting for which fiscal year to present, this value must be read before the system fetches any values for that section.
If the processing option determines whether to display a level break section in the report, the processing option needs to be processed before the level break section is processed. The event rules for this processing option are typically placed on the Initialize Section event of the level break section affected.
The section type that you selected and the object on which the cursor is positioned in the report template when you enter Event Rules Design determine the events available. The selection of events is determined by these three levels:
Reports
Sections
Objects
The tables in this section list the events that are available at each of the three levels.
This table describes the events that are available at the report level; Y indicates that an event is supported:
| Event | Description |
|---|---|
| Do Initialize Printer | Y |
| Initialize Report | future functionality |
| End Report | future functionality |
This table lists the events that are available at the section level for each section type; Y indicates that an event is supported while N indicates that an event is not supported:
| Event | Report Header | Page Header | Columnar | Group | Tabular | Child/ Custom (CG) | Level Break Header | Level Break Footer | Page Footer | Report Footer |
|---|---|---|---|---|---|---|---|---|---|---|
| Advance Section | N | N | Y | Y | Y | Y | Y | N | N | N |
| After Last Object Printed | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y |
| Before Level Break | N | N | Y | Y | Y | Y | N | N | N | N |
| Do Balance Auditor | N | N | N | N | Y | N | N | N | N | N |
| Do Section | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y |
| Do Tabular Break | N | N | N | N | Y | N | N | N | N | N |
| End Break Section | N | N | Y | Y | Y | Y | N | N | N | N |
| End Lvl Brk Footer Section | N | N | N | N | N | N | N | Y | N | N |
| End Lvl Brk Header Section | N | N | N | N | N | N | Y | N | N | N |
| End Page Header | N | Y | N | N | N | N | N | N | N | N |
| End Report Header | Y | N | N | N | N | N | N | N | N | N |
| End Report Footer | N | N | N | N | N | N | N | N | N | Y |
| End Section | N | N | Y | Y | Y | Y | N | N | N | N |
| Init Break Section | N | N | Y | Y | Y | Y | N | N | N | N |
| Init Lvl Brk Footer Section | N | N | N | N | N | N | N | Y | N | N |
| Init Lvl Brk Header Section | N | N | Y | Y | N | Y | Even though event rules can be edited in Report Design Aid, this event is not processed by the system. | N | N | N |
| Initialize Page Header | N | Y | N | N | N | N | N | N | N | N |
| Initialize Page Footer | N | N | N | N | N | N | N | N | Y | N |
| Initialize Report Header | Y | N | N | N | N | N | N | N | N | N |
| Initialize Report Footer | N | N | N | N | N | N | N | N | N | Y |
| Initialize Section | N | N | Y | Y | Y | Y | Y | Y | N | N |
| Refresh Section | N | N | N | N | N | Y | N | N | N | N |
| Suspend Section | N | N | Y | Y | Y | Y | Y | Y | N | N |
This table lists the events that are available at the object level for variables in each section type; Y indicates that an event is supported:
| Event | Report Header | Page Header | Columnar | Group | Tabular | Level Break Header | Level Break Footer | Page Footer | Report Footer |
|---|---|---|---|---|---|---|---|---|---|
| Cell Inclusion | N | N | N | N | Y | N | N | N | N |
| Column Inclusion | N | N | N | N | Y | N | N | N | N |
| Do Variable | Y | Y | Y | Y | Y | Y | Y | Y | Y |
| End Column | N | N | Y | Y | Y | N | N | N | N |
| End Variable | Y | Y | Y | Y | Y | Y | Y | Y | Y |
| Initialize Column | N | N | Y | Y | Y | N | N | N | N |
| Initialize Variable | Y | Y | Y | Y | Y | Y | Y | Y | Y |
This table lists the events that are available at the object level for constants in each section type; Y indicates that an event is supported:
| Event | Report Header | Page Header | Columnar | Group | Tabular | Level Break Header | Level Break Footer | Page Footer | Report Footer |
|---|---|---|---|---|---|---|---|---|---|
| Do Column Heading | N | N | Y | N | Y | N | Y | N | N |
| Do Constant | Y | Y | Y | Y | Y | Y | Y | Y | Y |
| End Constant | Y | Y | Y | Y | Y | Y | Y | Y | Y |
| Initialize Const | Y | Y | Y | Y | Y | Y | Y | Y | Y |