Trigger on Table not running from Table Conversion

[andres]

Hi,

I have a Table with a Trigger on the BeforeRecordIsInserted event. I'm using this table on a Table Conversion as the output table, so that event should be executed in every insert.
However, it is not doing this, the table conversion inserts the table but never calls the trigger.
From other places the trigger works normally.

Does Triggers on Table Conversion work?

Regards,
Andrés.

 

[JNI]

Hi Andres,

Is that table.c source file created properly.Compilation & Build Successful.
Did the below steps executed?

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

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

Reference :Section 4.2.2
https://docs.oracle.com/cd/E17984_01/doc.898/e14702/createtableeventrules.htm

Thanks.

 

[andres]

My config is JDE 9.1 Oracle database

About document, I had read it, but I don't understand why under that step "4.2.2 Adding Table Event Rules to Table Conversions" it explains how to add a trigger on a table, where is there anything about Table Conversion?

Regards,
Andrés.

 

[peterbruce]

Andres,

Does the JDE Table Trigger work with inserts from other sources (in JDE) apart from the table conversion? Is the table on which the trigger has been created a standard JDE table or a custom table. Please keep in mind that Oracle advises against using JDE Table triggers on JDE system tables.

 

[andres]

Hi Peter,

The trigger was created on a custom table, and it only run a bsfn to get a value and assign it to a table field to be inserted.
It works well from any insert except when it is done into the table conversion, I don't understand why.

Regards,
Andrés.