Blogroll

Get a website with Godaddy


Logo designer Fiverr Frelancer

Wednesday, July 15, 2015

How to rebuild table event rule trigger after some modification on the table's event rule

Hi,   Let's say you have added some comments or ER into existing table F42119




Below are the steps to rebuild the table trigger :

1. go to OMW
2. Move Eg. table F42119 to available OMW project
3. Design tool > Build Table Triggers
4. Build update/full package

note: F42119.C , F42119.h will be created to have ER.


The C source will have those ER attached to this table.


For reference :

Understanding Table Event Rule Triggers
To create table event rules, you must:

Create the table trigger in Event Rules Design.

Generate the JD Edwards EnterpriseOne table trigger as C code.

Build the table trigger.

When you build table triggers, the system performs these actions:

Converts the event rule to C source code, which creates the files OBNM.c and OBNM.hxx (OBNM = Object Name).

The source file contains one function per table event rule event.

Creates a make file to compile the generated code.

Runs the make file to compile the new functions and to add them into JDBTRIG.DLL.

This consolidated DLL contains table event rule functions.

Adding Table Event Rules to Table Conversions
Access the Object Management Workbench form.

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

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

Select an event from the Events list.

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

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

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.
On the Generate Table form, complete these fields and click OK:

Data Source
Password
On the Table Design form, select the Design Tools tab and click Build Table Triggers.

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.


No comments:

Post a Comment

Amazon store

alidropship plugin

alidropship plugin
alidropship plugin

Total Pageviews

About