Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 212 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
BIP report to fetech manager 's manager to send notification for learning

Need help to fetch manager's manager information so that notification is sent manager' manager when course of emp is due date
Answers
-
Presume you mean via sql?
Manager is obtained via table per_assignment_supervisors_f.
Smple query below for an Emps manager
If you want the manager's manager - you just need to add the relevent tables again and do required joins.
(or could also do a hierarchical level query)
select
ppf.person_number,
ppfsup.person_number sup_person_number
from
per_all_people_f ppf,
per_all_assignments_f paf,
per_assignment_supervisors_f pas,
per_all_people_f ppfsup
where sysdate between ppf.effective_start_date and ppf.effective_end_date
and ppf.person_id = paf.person_id
and paf.assignment_type = 'E'
and sysdate between paf.effective_start_date and paf.effective_end_date
and paf.assignment_id = pas.assignment_id
and sysdate between pas.effective_start_date and pas.effective_end_date
and pas.manager_id = ppfsup.person_id
and pas.manager_type = 'LINE_MANAGER'
and sysdate between ppfsup.effective_start_date and ppfsup.effective_end_date1 -
How can we fectch learning due date information . Is there any sample query
0 -
Did you check the learning assignment records table? Please check if below helps:
Thanks.
0