Results 1 to 3 of 3

Thread: Best way to do automated alert in JDE

  1. #1
    Join Date
    Jan 2012
    Kerala, India

    Best way to do automated alert in JDE

    What is the best way to do automated notification in JDE. For example, up on terminating one employees, the email administration should receive one alert to disable the company email address.

    It can be done either ways:-
    • Write table trigger ER and check if the employees is terminated on each table update operation. But I think, we should not add table triggers because it will affect performance
    • Prepare a custome report to check on daily basis, if there is any newly terminated employee. Send alert accordingly

    Is there any other easy way to accomplish the functionality.
    JDE Professional
    JDE E1 8.12 | TR 8.96.40 | Windows XP SP 3

  2. #2
    New Member
    Join Date
    Jan 2015

    There is entry created in the address book P01012 for the Employees Number based. There search type would be start E. Once any employee terminated admin person change the search type E to Z(Closed Customer/terminated customer). Once this will change E to Z category , Once customer report will be generated which will send the mail to the admin person.


  3. #3
    Senior Member Adrian_Chimirel's Avatar
    Join Date
    Nov 2000
    Toronto, Canada
    I would customize P01012 to send an eMail to the eMail Administrator when the employee (Address Book record) Search Type changes from E to Z (or whatever code you use for Terminated).
    E1 9.1 TR 08-13-2014_07_7 MSQL 2012 SP1 x64, WebLogic 12c, all on WIntel 2012 x64
    3rd Party Software: All Out Security 3.2, TransForm 5.3, SAP Business Objects Enterprise XI 12
    In the Cloud!

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company and, or Oracle.