Home » Applications » Oracle Fusion Apps & E-Business Suite » Ending Probation Period Alert... (EBS 11i 11.5.10.2)
Ending Probation Period Alert... [message #419489] Sun, 23 August 2009 02:57
adelshehri
Messages: 12
Registered: July 2009
Junior Member
Hello,

In order to make an alert for "Ending Probation Period" I have created a periodic Alert, this alert will check daily if there is any employee already near to 80 days from hire date to sysdate it will send an e-mail alert to us... using the below query in the alert .... the query is verified and can run but no e-mails received

anybody can help ....

Regards

SELECT distinct
employee_number,
full_name,
original_date_of_hire,
date_of_birth,
national_identifier
INTO
&employee_number,
&full_name,
&original_date_of_hire,
&date_of_birth,
&national_identifier


FROM PER_ALL_PEOPLE_F


where sysdate BETWEEN effective_start_date and effective_end_date
and sysdate - original_date_of_hire < 85
and sysdate - original_date_of_hire > 80
Previous Topic: Report Brazilian Receivables-RI
Next Topic: (developing)cash management (manual clearing --> clear transactions)
Goto Forum:
  


Current Time: Thu Dec 08 04:12:59 CST 2016

Total time taken to generate the page: 0.15158 seconds