OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » Ending Probation Period Alert...

Home » Applications » Oracle Fusion Apps & E-Business Suite » Ending Probation Period Alert... (EBS 11i 11.5.10.2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Code: [Select all] [Show/ hide]

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

Report message to a moderator

Previous Topic:	Report Brazilian Receivables-RI
Next Topic:	(developing)cash management (manual clearing --> clear transactions)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 05 12:21:07 CDT 2025