My Oracle Support Banner

E1: TDA: Frequently Asked Questions on Table Triggers (Doc ID 1552330.1)

Last updated on NOVEMBER 08, 2019

Applies to:

JD Edwards EnterpriseOne Tools - Version SP24 and later
Information in this document applies to any platform.

Purpose

 This document provides answers to some frequently asked questions about Table Triggers.

Questions and Answers

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Questions and Answers
 Question 1: What is a Table Trigger?
 Question 2: Why does my table trigger not execute when a record is inserted into the table outside EnterpriseOne?
 Question 3: Are native database triggers supported with EnterpriseOne?
 Question 4: With a Table Trigger that is initiated by an action from a UBE report, why does the system value ReportName variable not contain the UBE report name?
 Question 5: Why does an update to the TK fields in the table using a Table Trigger on the event "Before Insert" not work?
 Question 6:  Why is a Table Trigger defined on the Delete Events not working and the TK values are not populated?
 Question 7: Can a report be launched from a Table Trigger using table event rules?
 Question 8: What is the process to remove the table trigger from the table?
 Question 9: Is a Table Trigger on a System Table supported?
 Question 10: How does the Enterprise Server know to execute a Table Trigger when the Table IO is done by the runtime code on the Web Client?
 Question 11: Can a Table Trigger be defined to occur when a specific field changes values within a Table?
 Question 12:  After creating a new Table Trigger, why does it only work locally?
 Question 13: How is a Table Trigger executed when Initiated on the Web client
 Question 14: If a batch job fires table triggers repeatedly, how are they called, Synchronously or Asynchronously?
 Question 15: How can I troubleshoot an error with a Table Trigger?
 Question 16:  Is there a WebDev tool or report that could easily list out all tables in an environment that have E1 triggers?
 Question 17:  Why do Table Event Rules for Date reference as Null, fail to evaluate?
 Question 18:  How to disable the business function calls added under "Currency Conversion is On" event in any delivered TERs?
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.