Events Alerts

SCREENSHOTS FOR GETTING EMPLOYEE ASSIGNMENT DETAILS (WHEN WE CHANGE THE POSITION/JOB/GRADE/PAYROLL……THEN FOR GETTING CMPLT DATE TRACK DETAILS)

HR Super User-->  People-->Enter and Maintain--> Enter Employee Number/Name/-->Find

 

 

Assignment--> Date Track history

 

Full History(In this screen if we change any field in Assignment Screen then here we find new record having all details.

 

Requirement:

When ever the position of the employee changes the alert has to be fired and it has to send a mail to the higher authorities.

Event Based Alert Process and Example

Position Change Alert: ()

Alert Manager Responsibility-->Alert-->Define

Application: Either Custom Application/Standard

Name: Name of the Alert

Type of Alert: Event

Event Details:

Application: Table Application Name

Table: Table Name on which the Event Trigger will Fire

After Insert: Enable/Disable Based on Requirement

 After Update: Enable/Disable Based on Requirement

Query: (For Event Alerts we have to give Rowid Condition)

select ppos.NAME Current_Position,

       (select ppos.NAME

          from apps.per_all_positions ppos,

               apps.per_all_assignments_f paaf 

         where

               1=1

               and paaf.position_id=ppos.position_id(+)       

               and (paaf_new.EFFECTIVE_START_DATE-1) between paaf.EFFECTIVE_START_DATE and paaf.EFFECTIVE_END_DATE

               and paaf.assignment_id=paaf_new.assignment_id

               )OLD_Position,

           nvl(employee_number,NPW_NUMBER)Emp_number ,

           full_name Emp_name    

into   &Current_Position,&OLD_Position ,&Emp_number,&Emp_name

  from apps.per_all_positions ppos,

       apps.per_all_assignments_f paaf_new,

       apps.per_all_people_f    ppf 

  where

        1=1

        and paaf_new.position_id=ppos.position_id

        and ppf.person_id =paaf_new.person_id

        and ppf.business_group_id in(922,942)

        and sysdate between ppf.EFFECTIVE_START_DATE and ppf.EFFECTIVE_END_DATE     

        and sysdate between paaf_new.EFFECTIVE_START_DATE and paaf_new.EFFECTIVE_END_DATE     

        and paaf_new.rowid=:rowid

and paaf_new.position_id <>

        (select position_id

           from apps.per_all_assignments_f paaf 

         where

               1=1

               and (paaf_new.EFFECTIVE_START_DATE-1) between paaf.EFFECTIVE_START_DATE and paaf.EFFECTIVE_END_DATE

               and paaf.assignment_id=paaf_new.assignment_id)

and exists (select 1 from apps.pfcpo_approval_limits pal

where pal.employee_id = ppf.person_id)

-----------------------------------------

Then Verify and Save the Alert then Click on RUN option here we will know how many records the query is getting.

 Then

Actions -->

Action Name: (PFC_POSITION_CHANGE)

Action Level: Summary/Detail based on Requirement

(Summary means mail(depends on mail ids) for all records

Detail means mail will go for each record whatever the query is getting)

Action  --> Action Details

Action Type : Message

To: To Mail ID

Subject: Subject for the mail

In Text Area: we will give the format whatever they need

Then

Action Sets -->

Action Set Name: here we have to give Action Name only

Then

Action Sets --> Action Set Details -->Membersà

Action: (Same Action Name)

 

Then

Alert Details --> Installations -->

Depends on Application we will give Operating Unit Names(Not Mandatory)

Running Process:

Whenever we Update or insert a record in the table that time Event alert will defaultly Fire and send the mail.