Adding Table Event Rules to Table Conversions

Access the Object Management Workbench form.

1. Check out the table to which you want to attach event rules and click Design.

2. On the Table Design form, select the Design Tools tab and click Start Table Trigger Design Aid.

3. Select an event from the Events list.

4. On Event Rules Design, click one of the event rule buttons and complete the event rules.

5. Click Save to save the event rule specifications and then click Close.

6. If you are creating a new table in Oracle's JD Edwards EnterpriseOne Table Design Aid, select the Table Operations tab and click Generate Table.

   Important: Never perform this step on an existing table because it clears all data.

7. On the Generate Table form, complete these fields and click OK:

   • Data Source

   • Password

8. On the Table Design form, select the Design Tools tab and click Build Table Triggers.

9. To review a log of the build, select Generate Header File, and then open the file that the system created.

   The creation of the table event rules is complete. The newly created or modified table event rule is called from the JD Edwards EnterpriseOne database middleware whenever the corresponding event occurs against the table.