I recently faced an issue with the Table Event Rules (TER’s) commonly called as Table Triggers(which is wrong. Actually Table Triggers occur outside JDE, like in a Database. Thus, JDE has no knowledge about it. TER’s on the other hand are built within JDE, and have to be generated and compiled to get it working)
Advanced Users please skip directly to the issue
Anyways, coming to the point, I had a scenario to use an Audit Table which would keep track of all changes to a table (like Add/Change/Delete).
So I started up creating the Audit table (say F550006A) by copying the Original Table (say F0006).
Added up couple of fields –
- Sequence Number (SEQ5) so that the primary key is not violated as the Audit records get inserted(This is added to the Primary Key).
- Action Code (ACTN) to specify the type of action performed (Add/Change/Delete)
Now, I started adding up the TER’s in F0006 as follows
- Fetch the Latest sequence number (SEQ5) for the primary key from Audit table (F550006A)
- Up the SEQ5 by 1.
- Insert the Record (TK values of F0006) into F550006A along with the Sequence Number and Action Code
The same code was replicated in the following 3 events with changes to only the Action Code (ACTN)
- Add Action = A, in the “After Insert” event
- Change Action = C, in the “After Updated” event
- Delete Action = D. in the “Before Delete” event. This is so that we get the values before the record is deleted.
Issue:
All events except BEFORE DELETE worked fine. The records were inserted successfully on Add & Change.
I checked the logs which said that Before Record is deleted event was fired. But no values were populated in the Audit table, i.e. the TK values were blank.
On researching I found this document in metalink which said the following
On the Web client, the JDB runtime code will pre-fetch all columns of the table prior to executing the Delete and Update Table Events, provided that the setting triggerAutoFetch is set correctly in the INI configuration file.
Xe/ERP8.0 with SP23 & higher
update jas.ini
[OWWEB]
triggerAutoFetch=true
8.9 & above
update jdbj.ini (in the Environment-INI folder and the OC4J folders)
[JDBj-RUNTIME PROPERTIES]
triggerAutoFetch=all
Oracle Document: SOLUTION ID-201016296
can we have a like button to like the post similar to Facebook
Ratings added 😀
Hi ,
I am facing same problem in Jde Oneworld Xe , i am testing in the thick Client. Can you provide me the solution for thick client also
Hi Bhawesh,
These changes are applicable on thick client as well.
Can you please provide the section within the relevant ini file (e.g. “JDE.INI”) that requires changing for this fix for the Delete Event in JDE Oneworld Xe Thick Client? (jas.ini does not exist)
The section is given in the article itself.
Thank you for your input, however I am using Oneworld Xe, SP24, with no HTML front end (i.e. windows client only, no JAS server etc) so no jas.ini file. The article states to change the jas.ini file for “Xe/ERP8.0 with SP23 & higher”.
So, if the change is to be applied to the jde.ini file, for example, then please can you tell me where and what to change for the solution to work for windows client?
Thanks
..
I am using Oneworld Xe, SP24, with no HTML front end (i.e. windows client only, no JAS server etc) so no jas.ini file. The article states to change the jas.ini file for “Xe/ERP8.0 with SP23 & higher”.
So, if the change is to be applied to the jde.ini file, then please can you tell me where and what to change for the solution to work for windows client?
Thanks
hi ,
i have the same question , my CNC team reply me that they are not using JAS.INI. My delete trigger is still not working
Thanks
Hi,
Recently i worked on table triggers(add,update).In local web its working fine(add,update) but after deployment in DEV web link both are not working( add,update).even redeployment also done.plz Can you help me