In this post you’ll see script to get project project key members details in Oracle Fusion Application, in project module this is a common requirement to show active project manager’s information which is assigned for the project.
Query to get active Project Manager details in Oracle Fusion Application
This query will help you to retrieve project manager’s information of any projects in Oracle Fusion Application, you have to only pass project number as a parameter in below SQL query.
select ppf.list_name as project_manager
from PJF_PROJECTS_ALL_B PPA
JOIN PJF_PROJECT_PARTIES pp ON (ppa.project_id = pp.project_id and trunc(sysdate) between trunc(pp.START_DATE_ACTIVE) and trunc(nvl(pp.END_DATE_ACTIVE,sysdate+1)))
join PJF_PROJ_ROLE_TYPES_TL ppr on (pp.PROJECT_ROLE_ID = ppr.PROJECT_ROLE_ID and ppr.PROJECT_ROLE_NAME = ‘Project Manager’)
join PER_PERSON_NAMES_F ppf on (ppf.person_id = pp.RESOURCE_SOURCE_ID and trunc(sysdate) between trunc(ppf.EFFECTIVE_START_DATE) and trunc(nvl(ppf.EFFECTIVE_END_DATE,sysdate+1)) and ppf.NAME_type=’GLOBAL’)
where ppa.SEGMENT1 =:p_project_number