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.
