Subject Areas for Project Management Real-Time Analyses

You can use multiple subject areas to create real-time analyses and dashboards for Oracle Fusion Cloud Project Management as listed below.

Subject Area

Description

Business Questions

Projects - Period Close Exceptions

Analyze project period close exceptions associated to unprocessed costs, expenditures, and revenue. View pending transactions by using dimensions such as project, task, expenditure type, project organization, and message type.

  • Which transactions prevent project period closure?

  • What is the amount of pending transactions?

  • Which projects have pending transactions?

Projects - Billing and Revenue Exceptions Real Time Analyze project billing and revenue exceptions raised during the revenue and invoice generation processes and the integration of project invoices with Oracle Fusion Receivables. View details for the exceptions by using dimensions such as business unit, contract, project, and message type.
  • Which projects have missing labor rate exceptions for revenue or invoicing?
  • Which invoices were rejected during the transfer to Oracle Fusion Receivables?
  • Which events could not be invoiced due to funding limit issues?
  • What are all of the billing and revenue exceptions for a business unit?
Project Billing - Bill Transactions Real Time

Analyze real-time information on project contract bill transactions. View expected revenue and invoice amounts in different currencies for unbilled transactions (work in progress) by dimensions such as customer, contract, project, billing person, unit of measure and unit price.

  • Which contracts, contract lines and bill plans do unbilled transactions relate to?

  • Which transactions are unbilled and what is the expected bill amount?

Project Billing - Event Real Time

Analyze real-time information of project contract billing events. View project contract billing events at an individual transaction level and analyze billing events using dimensions such as contract, contract line, project, and task. You can also analyze billing events by event details such as event type, completion date, invoice revenue and status, and reversal indicator.

  • Which are the billing events for a project or contract and contract line?

  • What's the total amount or number of completed billing events which aren't invoiced or recognized for revenue for a contract and contract line?

  • Which billing events are on an invoice hold or a revenue hold?

  • Which billing events are potentially missing an event completion date?

Project Billing - Funding Real Time

Gain insight into project contract funding information to analyze funds consumed for invoice and revenue, and funds remaining by using dimensions such as customer, organization, contract, billing type, project, task, and time.

  • Which are the contract lines for a contract?

  • How much of the contract line amount is invoiced and recognized for revenue?

  • Which projects are linked to contracts?

  • Which project contracts are active for a business unit?

Project Billing - Invoices Real Time

Gain insight into real-time project contract invoice information at an individual transaction level and analyze invoicing, concessions, and credits by using dimensions such as customer, organization, contract, billing type, project, task, employee, time, and currency.

  • What are the transactions for an invoice line?

  • Which invoices need attention?

  • What are the invoice line details for a particular invoice?

  • Who are the contracted customers for a business unit?

Project Billing - Revenue Real Time

Analyze real-time information on revenue recognized for project contracts. View project contract revenue information at an individual transaction level by using dimensions such as customer, organization, contract, billing type, project, task, employee, time, and currency.

  • Which contracts have actual revenue in the current accounting year?

  • Which contracts have the lowest actual revenue in the current accounting period?

  • What's the actual revenue trend for accounting periods in the selected accounting year?

Project Control - Budgets Real Time

Analyze project budget data such as raw and burdened cost, planned effort, revenue, and margin for current working, submitted, current baseline, and original baseline budget versions. View real-time project budget information by using dimensions such as project, task, employee, time, and planning resource.

  • Which projects are under a business unit and what are the statuses of these projects?

  • What's the budgeted amount for a project for the various budget versions?

  • What's the planned effort and revenue amount for a project for the various budget versions?

Project Control - Forecasts Real Time

Analyze project forecast data for current, submitted, prior, and original forecast versions. View real-time forecast data such as raw and burdened cost, planned effort, revenue, margin, and variance measures such as cost variance, revenue variance, and so on by using dimensions such as project, task, employee, time, and planning resource.

  • What are the raw and burdened costs for a project?

  • What's my cost variance?

  • What's my margin on a project?

  • What's the forecasted revenue for a project?

  • What are the different forecast versions for my project?

Project Control - Financial Project Plans Real Time

Analyze real-time information on financial project plans such as planned raw and burdened cost, planned effort, actual raw and burdened cost, and actual effort for current working and current baseline financial project plans. View high-level planning for your project tasks by using dimensions such as project, task, time, and planning resources.

  • Which planned resources are working on my tasks?

  • What are my project tasks?

  • What are the planned periodic amounts for my resource assignments?

  • Which are my unplanned resources on the project plan?

  • What are my project tasks without any task assignments?

Project Control - Progress Real Time

Analyze project progress and view specific progress details such as actual cost, estimated effort to complete, cost percent spent, physical percent complete, and estimated cost at completion. Measure project performance using earned value metrics, including cost variance, cost performance index, and schedule performance index. Analyze performance trends as progress is captured over time and use that information to estimate and control project outcomes.

  • What's the latest published physical percent complete for all tasks?

  • What's the latest published physical percent complete for summary tasks?

  • What are the planned and actual costs for each task as per the latest published progress?

  • What are the cost and schedule performance indexes on my project?

Project Costing - Actual Costs Real Time

Analyze actual project costs by viewing supplier, labor, nonlabor, and third-party transaction project costs. View specific costs, associated expenditure items, and distribution line details for a specific project, task, task hierarchy, employee, project organization, and expenditure organization for a specific time period.

  • Which capitalizable costs aren't yet capitalized?

  • How much does each transaction source contribute to project costs?

  • Which transactions contribute to the total cost of my projects?

Project Costing - Assets Real Time

Analyze capital projects and identify possible exceptions by comparing expensed and capitalizable costs. Track capitalizable costs throughout the capitalization process and review asset details, view asset assignments to projects and tasks, analyze amounts charged to different accounts, and drill down to cost distribution lines.

  • What's the total capitalized cost of my assets?

  • How's an expenditure item allocated across assets?

  • Which cost distributions are included in an asset line?

  • Which assets are assigned to a task?

Project Costing - Commitments Real Time

Gain insight into project commitment transactions from the procure-to-pay flow. View requisition, purchase order, and supplier invoice measures for a project, task, task hierarchy, project organization, and expenditure organization for a specific time period.

  • What are the requisitions and purchase orders that still have commitment costs for my project?

  • What are the outstanding commitments for my project?

  • Which commitments are associated with my capital projects?

Project Costing - Expenditure Item Performance - Real Time

Analyze expenditure item performance by gaining insight into project expenditure item costs, and billing and revenue details. View expenditure item type and class information for project, task, task hierarchy, employee, project organization, and expenditure organization for a specific time period.

  • What are the billing and revenue details by project?

  • What was the expenditure incurred on a project in a prior week?

  • Which expenditure items are associated with my capital projects?

Project Costing - Unprocessed Transactions Real Time

Analyze unprocessed project transactions sourced from Oracle Fusion Cloud Applications or third-party applications and view general details about pending, failed, and unprocessed transactions including the original source and processing information. View unprocessed transactions for a project, task, task hierarchy, employee, related expenditure types, project organization, and expenditure organization for a specific time period.

  • What unprocessed transactions are waiting to be sent to Oracle Fusion Cloud Project Management?

  • Which transactions weren't successfully imported to Oracle Fusion Cloud Project Management?

Projects - Labor Distribution Cost Analysis Real Time

Analyze real-time information on labor distributions using dimensions like project, task, award, employee, project organization, and general ledger charging instructions for a specific time period.

  • What payroll batches have loaded recently and where did they distribute too?

  • What errors / exceptions exist and what types?

  • How many costs are being distribute to GL vs Projects over time?

Projects - Labor Schedule Analysis Real Time

Analyze real-time information on labor schedules using dimensions like project, task, award, employee, project organization, and general ledger charging instructions for a specific time period.

  • Who has a labor schedule with no costs associated?

  • Labor schedules ending in next 3 months?

  • What labor schedules are likely to fail in the near future? Labor schedules with Awards / Projects Ending Soon.

  • Award / Projects with the most labor Schedules Active?

Project Management - Baseline Versions Real Time

Analyze the multiple baseline versions information for the projects that you manage using dimensions such as project, task, task hierarchy, and baseline version details. View the real-time information through baseline version metrics such as baseline variance with current dates, effort, and costs.

  • What's the baseline history information for my projects?

  • What's the schedule, effort, and cost variance across multiple baselines for my tasks or projects?

Project Management - Change Management Real Time

Analyze real-time project change order information using dimensions such as change order reason, status, impact, participant, time, and project.

  • What's the number of pending change orders grouped by various stages?

  • What are the reasons for change orders?

  • What's the estimated cost and revenue for the change order?

  • What's the current stage and status of the change order?

Project Management - Opportunity Integration Real Time

Analyze specific project opportunity details such as status, win probability percentage, deal amounts, and weighted labor bill and cost amounts. View real-time information through opportunity-related project metrics using dimensions such as opportunity, project, and time.

  • How many projects are in the pipeline for each customer?

  • What's the weighted (adjusted) revenue for all projects under this branch of the enterprise project structure?

  • Which are the projects for this opportunity?

  • How much did it cost to pursue this deal?

  • What are the win probabilities for opportunities on a project?

  • What are the deal and weight labor bill amounts on a project?

Project Management - Planning Real Time

Analyze project plan data and view specific project plan details such as start and finish dates, progress information, planned, actual, and remaining cost, and labor effort. View real-time information through project plan metrics using dimensions such as project, task, employee, progress status, resource, sprint, and time.

  • What are the planned billing amounts for my projects?

  • What are the operating margins for my projects?

  • What are the planned and actual margins and margin percentages for my projects?

  • What are the planned and actual costs for my projects?

  • How much effort is planned per resource role for my projects?

Project Management - Project Issues Real Time

Analyze the issues and related action items that you own or create, or that are related to projects that you manage. View real-time information across different dimensions such as project, owner, issue type, and status.

  • Which issues are open for my projects, along with their details?

  • Which issues are open for an individual owner?

  • What are my action items?

  • What patterns are apparent from historic performance on issues? What can we learn from analysis of issues that could help future project performance?

Project Management - Project Hierarchy Real Time

Analyze project plan data such as cost, schedule, effort, and bill amounts rolled up to enterprise project structure. Analyze real-time information through project hierarchy metrics using dimensions such as project hierarchy, resource, employee, task, task hierarchy, progress status, time, project, and sprint.

  • What are the actual costs for my EPS elements?

  • What are the total costs for my EPS elements?

Project Management - Project Resources Real Time

Analyze real-time project resource allocation information, for example, project labor and expense resource allocations using dimensions such as employee, resource class, resource, project role, project resource assignment status, project, and opportunity.

  • What are the statuses of the resources currently working on my projects?

  • Who are the planned resources assigned to my projects?

  • What are the allocated hours for my project resources?

Project Management - Project Work Items Real Time

Analyze real-time project work item information and view specific project work item details such as deliverables, concepts, proposals, requirements specifications, product change orders, items, and negotiations. View real-time information through work item metrics using dimensions such as project, task, priority, and status.

  • What are the work items for my projects?

  • What are the work item statuses that determine the completion of my project tasks?

  • Which of my project deliverables are overdue, due soon, and yet to start?

  • What are the allocated hours for my project resources?

Project Management - Requirements Real Time

Analyze real-time project backlog information for your project backlog items using dimensions such as requirement hierarchy, sprint, product, release, scrum master, backlog owner, project, and task.

  • What's the total number of backlog items by status for a product in a given sprint?

  • What's the total number of story points achieved in each sprint of a release?

  • Which of my backlog items have exceptions?

  • What are the planned hours for each backlog item?

  • What are the backlog items for my projects in a sprint?

  • What's the remaining effort for my backlog items?

Project Resource Management - Resource Management Real Time

Analyze real-time project resource assignment information, for example, project resource supply, demand (requests and assignments), and utilization using dimensions such as resource, resource pool, role, qualification, time, and project.

  • Which requests are in Open or Resource Proposed status?

  • What's the forecasted revenue and margin for resource requests that are in Open or Resource Proposed status?

Project Resource Management - Resource Pool Real Time

Analyze real-time resource pool information using dimensions such as resource, resource pool, resource pool membership, resource pool hierarchy, department, and location.

  • Which resources belong to a resource pool?

  • What are the dates of pool membership for a resource?

  • What's a resource's pool membership history since the resource was hired?

Project Management - Task Management Real Time

Analyze the tasks that you own or create, including project tasks, to-do tasks, action items, and milestones.

  • Which project tasks are due in 7 days?

  • In how many days are my project tasks due?

  • Which project tasks are incomplete?

  • Which project tasks, milestones, and action items are due?

Projects - Cross Subject Area Analysis - Real Time

Analyze real-time information on project performance, including budgets, forecasts, costs, commitments, revenue, and invoices using dimensions such as award, fiscal calendar, employee, project, task, organizations, and time.

  • Is my project profitable?

  • How much funding has my contract consumed?

  • How much has been invoiced for my contract?

  • How does my budgeted cost compare against my actual and forecast costs?

  • What are my committed costs for a project?

  • How does my budgeted revenue compare against my actual and forecast revenue?

Projects - Grants Management - Award Analysis Real Time

Analyze real-time award information using dimensions such as award, award project, keyword, certification, reference types, and time.

  • What are the awards for a specific keyword, for example, awards on diabetes research?

  • Which award certifications expire in the next 30 days?

  • What are the proposal numbers for the awards?

  • Which are the certifications awarded for various projects?

Projects - Grants Management - Award Funding Real Time

Analyze real-time award funding information using dimensions such as award, award project, budget period, funding source, sponsor, personnel, keyword, organization credits, and time.

  • Which awards are currently active?

  • Which awards are past their end dates but weren't closed?

  • What's the allocated funding amount for each project of an active award?

  • What's the total funding by department year over year?

  • What awards have funding not allocated to projects?

Projects - Performance Reporting Real Time

Measure project performance using various summary reporting metrics such as total cost, ITD actual cost, revenue, billed amount, and so on at the project, task, and resource levels. Analyze project performance measures by fiscal periods to gain insight into holistic project health. You must submit the Update Project Performance Data process for different data sources so that your analyses and dashboards display accurate data.

  • What's the project expenditure for a specific task and resource?

  • Which tasks and resources don't have correct expense estimates?

  • Which project generates the most revenue for my organization?

  • Which task and resource have the highest costs? What's my budgeted profit and actual profit?

  • What are my planning and actual cost amounts grouped by expenditure category and expenditure type?

Projects - Program Performance Reporting Real Time

Analyze real-time information for programs and program performance. Measure program performance using various reporting metrics for billing, capitalization, costs, earned value, effort, margin, and revenue.

  • Is the program on schedule and budget now and at completion?
  • What’s the operating margin for my program?
  • How well did we plan for the program (current and original baselines)?
  • What are the program's capitalizable costs?

Projects - Award Distribution Funding Pattern Reporting Real Time

Analyze real-time information on funding patterns using dimensions like project, task, and award charging instructions for a specific time period.

  • What costs were "potentially" processed using a funding pattern?
  • What funding patterns are likely to fail in the near future?

The following table lists the currencies supported by each subject area.

Subject Area

Ledger Currency

Entered Currency

Project Currency

Contract Currency

Projects - Period Close Exceptions

Yes

No

No

No

Project Billing - Event Real Time

Yes

Yes

Yes

Yes

Project Billing - Funding Real Time

No

No

No

Yes

Project Billing - Invoices Real Time

Yes

Yes

Yes

Yes

Project Billing - Revenue Real Time

Yes

Yes

Yes

Yes

Project Control - Budgets Real Time

Yes

Yes

Yes

No

Project Control - Forecasts Real Time

Yes

Yes

Yes

No

Project Control - Financial Project Plans Real Time

Yes

Yes

Yes

No

Project Control - Progress Real Time

Yes

No

Yes

No

Project Costing - Actual Costs Real Time

Yes

Yes

Yes

The project currency is valid for all measures except for the Transfer Price measures.

No

Project Costing - Assets Real Time

Yes

Yes

Yes

No

Project Costing - Commitments Real Time

Yes

Yes

Yes

No

Project Costing - Expenditure Item Performance - Real Time

Yes

Yes

Yes

No

Project Costing - Unprocessed Transactions Real Time

Yes

Yes

Yes

No

Projects - Labor Distribution Cost Analysis Real Time

Yes

Yes

Yes

No

Projects - Labor Schedule Analysis Real Time

No

No

No

No

Project Management - Baseline Versions Real Time

No

No

Yes

No

Project Management - Change Management Real Time

No

No

Yes

No

Project Management - Opportunity Integration Real Time

No

No

Yes

No

Project Management - Planning Real Time

No

No

Yes

No

Project Management - Project Issues Real Time

No

No

No

No

Project Management - Project Hierarchy Real Time

No

No

Yes

No

Project Management - Project Resources Real Time

No

No

No

No

Project Management - Project Work Items Real Time

No

No

No

No

Project Management - Requirements Real Time

No

No

No

No

Project Resource Management - Resource Management Real Time

No

No

Yes

No

Project Resource Management - Resource Pool Real Time

No

No

No

No

Project Management - Task Management Real Time

No

No

No

No

Projects - Cross Subject Area Analysis - Real Time

Yes

Yes

Yes

Yes

The contract currency is valid only for invoice and revenue related measures.

Projects - Grants Management - Award Analysis Real Time

No

No

No

No

Projects - Grants Management - Award Funding Real Time

Yes

Yes

Yes

Yes

Projects - Performance Reporting Real Time

Yes

No

Yes

No

Note: For the Projects - Program Performance Reporting Real Time subject area, you should use the Program Budget or Enterprise currency.