You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

In Oracle Alert SQL expression not Working

Summary:I have created an alert where it needs to be triggered when anyones work schedule got changed.


I have created sql filter in alert section but my alert is taking time to run and fails.


please find below query expression


EXISTS (select 'X' from per_all_people_f papf , per_all_assignments_m paaf, ZMM_SR_SCHEDULES_VL adr1, PER_SCHEDULE_ASSIGNMENTS pa1 where paaf.person_id =papf.person_id and sysdate between papf.effective_start_date and papf.effective_end_date and pa1.resource_id=paaf.assignment_id and sysdate between paaf.effective_start_date and paaf.effective_end_date and paaf.PRIMARY_FLAG='Y' and paaf.assignment_status_type='ACTIVE' and pa1.SCHEDULE_ID = adr1.SCHEDULE_ID aND trunc(pa1.last_update_date) = trunc(sysdate)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!