Overview
This article delves into the evolution of Project Portfolio Management (PPM) Project Personnel, specifically the transition from legacy systems to Oracle Financials Cloud (OFC) PPM. It provides insights into PPM Project roles, guiding readers on where to find them in OFC and how to navigate relevant reports. Additionally, the article addresses the process of changing PPM Project Personnel within the OFC system.
Essential Information
- Purpose of Transition
-
- Prior to OFC, historically, UCSD used the Chart of Accounts Override functionality in the Cost Center Management Tool (a proprietary application that integrated into IFIS) to assign a Principal Investigator and Fund Managers to individual indexes, which functionally created reporting in various systems.
- This KBA is to create a similar mapping guide for the campus to create accurate reporting and potentially leverage this for another approval routing dependent on OFC product development.
- The best practice is to assign up to one person per Role, per OFC module.
- Recommended Role Mapping
- Assignment of personnel data is to be maintained by departments on an ongoing basis.
- Roles are intended to be "overrides" as the structure becomes more granular/lower-level.
Below are the recommended Role mapping for Sponsored Projects/Awards and Non-Sponsored Projects:
NOTE: Project Roles/Personnel are not equal to Security Roles.
Sponsored Projects (Award & Project) Role Mapping
Name | Description | OFC Module | Use in Upstream and Downstream Systems |
Principal Investigator |
- Controls and monitors the technical direction and academic quality of research projects such as laboratory studies or clinical trials
- Is ultimately responsible for the research award
- Populated from Kuali Research
| Award: Required | SPARCM ECERT |
MSO/DBO/CAO |
- Chief Administrative Officer of Department
- Populated by SPF at the time of Award setup
- Updates by Department
| Award: Recommended Project: Optional | SPARCM |
Project Manager |
- This is generally the PI for Sponsored Projects
- If there are multiple projects, the Project Manager of the Project may not equal the lead PI of the Award
- Initially populated from PI on Award at the time of Award setup
| Project: Required | OFC Budget Notifications |
Fund Manager |
- Fund Manager supporting the administration of an award
| Award: Recommended Project: Optional | SPARCM |
Fiscal Manager |
- Manager of a group of financial activities
- Same as the Clinical Trials Department Supervisor
- This Role may be helpful for departments with more levels of administrative hierarchy than Fund Manager and MSO
| Award: Optional Project: Optional | SPARCM for Sponsor CT |
Task Manager |
- A person responsible for the Task
- This may be a PI or often a Co-Investigator responsible for the Task
- Should only be an override from the Project Manager
| Task: Recommended | |
Task Fund Manager |
- Fund Manager for the Task
- Should only be an override from the Fund Manager
| Task: Recommended | |
Non-Sponsored Projects
Name | Description | OFC Module |
MSO/DBO/CAO |
- Chief Administrative Officer of Department
| Project: Recommended |
Project Manager |
- For Non-Sponsored Projects, this is the responsible administrator; faculty or staff/business administrator
| Project: Required |
Fund Manager |
- Fund Manager supporting the administration of a Project
| Project: Recommended |
Fiscal Manager |
- Manager of a group of financial activities
- This Role may be helpful for departments with more levels of administrative hierarchy than Fund Manager and MSO
| Project: Optional |
Task Manager |
- The person responsible for the Task, which could be a PI or a staff member assigned
- Should only be an override from the Project Manager
| Task: Recommended |
Task Fund Manager |
- Fund Manager for the Task
- Should only be an override from the Fund Manager
| Task: Recommended |
NOTE: SPARCM only uses roles assigned to the Award (not the project).
Next Steps
Validations to ensure clear reporting:
- If a Project Manager exists, no need to update the Project Fund Manager and/or Fiscal Manager to the same person.
- Example:
- Project Manager: Joe Smith
- Project Fiscal/Fund Manager: Joe Smith << not necessary and redundant
- Further validations are in place to prevent redundant personnel roles:
- Example:
- Project Manager can't be the same as Task Manager
- Project Fund Manager can't be the same as Task Fund Manager
- Task Fund Manager can't be the same as Task Manager
- NOTE: These validations are built into PADUA.
View Personnel:
Update Personnel in OFC:
Use the Project and Award Data Update Application (PADUA):
If you have a large number of updates to make, you can submit the Mass Award/Project/Task Personnel Form until the functionality is available in PADUA.
Supplemental Information
Optional Steps to Take to View Personnel in OFC:
- NOTE: Only Award and Project Personnel are visible to department users through the OFC interface and so the Award Project Task Personnel Report is the recommended way to view personnel.
1. Navigate and sign in to Oracle.
2. Search for OFC Role by one of the following options:
- Award Personnel
-
- Navigate to Projects and Awards>Awards
- Select Awards
- Search for the Award
- View Award Details
- Click Personnel on the Details button
b. Project Members
-
- Navigate to Projects and Awards
- Select Project Financial Management
- Search for Project
- Select Manage Financial Project Settings
- Click on Parties
- View Team Members
c. Task Personnel:
Due to Security Role limitations, departments may not be able to view this page and will need to use the Award Project Task Personnel report.
2021 Rollout Plan (Displayed here for historical reference):
- Centrally created spreadsheet of all Awards, Projects, and Tasks for all active Projects and Awards with Project Roles(s) and people in Role(s) was provided to departments to update as a one-time mass update. This was completed in May 2021.
- All future updates will be done online via the Projects & Awards Data Update Application (PADUA).
- PADUA Phase 1: Departments download template, download report of Award/Project/Task with Role and name, update template, submit to Central Office, Central Office processes. Central Office reference KB0033464: How to Use Projects & Award Data Update Application.
- PADUA Phase 2: App/portal for departments to pull all Award/Project Task information, update on screen, and submit. As of June 2022: See here.