Probation Confirmation letter Automation in Oracle fusion HCM

Summary

Probation Confirmation letter Automation in Oracle fusion HCM

Content

Hi Team,

I have to create the bursting report, in which whenever probation status for an employee get confirmed, automatically letter  need to be send to employee and their line manger About the probation  confirmation.

For probation status we have a DFF at manage employment screen, which usually get change to confirm the probation status

Can any one help me ,how can achieve the above requirement. i have tried to create the query which will pick the confirmed status from per_all_assignments_f table ,but unfortunately I am unable to fulfil  the requirement exact requirement .Also please confirm is their any other way except bursting report to achieve the requirement.