Slide 3 - Oracle Project Portfolio Management Cloud
Release 10
Slide notes
Hello, my name is Bryan. Welcome to training for Release 10. In this session, we will talk what’s coming in Oracle Project Portfolio Management Cloud for Project Financial Reporting .
Notes
Slide 4 - Agenda
Slide notes
For the enhancements covered in this training, we’ll give an overview, followed by more detail to explain how you can use them, and what business value they bring.
Then we’ll walk you through a demonstration.
Next we’ll explain what you need to consider before enabling these features in your business, and what you need to know to set them up.
Notes
Slide 5 - Enhancements Overview
Slide notes
In this release, we are introducing several new features to enhance your reporting capabilities.
First, you can now analyze project performance using Oracle Smart View for Office. Smart View is a common Microsoft Office interface for Oracle Hyperion Essbase and provides robust and flexible reporting capabilities.
Next, a new subject area is available in Oracle Transaction Business Intelligence (or OTBI) for capital projects. This subject area covers all aspects of capital projects, including expenditures, asset lines, and asset capitalization. This information is available in real time, so the information is always up to date and accurate.
Finally, we’ve enhanced our project costing subject area so you can report on expenditures by project contract, and we’ve enhanced our invoice and revenue subject areas so you can report on billing events.
Notes
Slide 6 - Analyze Project Performance Using Oracle Smart View for Office
Slide notes
Using Oracle Smart View for Office, you can analyze planned and actual costs by project, task, resource, and period.
Since the data is stored in Oracle Hyperion Essbase, you can easily slice and dice the data and drill down to lower levels of detail as needed. Project accountants who are familiar with Microsoft products and with Oracle Hyperion Essbase will welcome the additional flexibility to perform ad hoc or free-form analysis and to investigate and understand complex data.
Smart View also allows you to view, import, manipulate, distribute, and share project data using Microsoft Excel, Word, Outlook, and PowerPoint.
Notes
Slide 7 - Analyze Capital Assets Using Oracle Transactional Business Intelligence
Slide notes
The new Project Costing – Assets Real Time subject area in OTBI enables you to track capital expenditures and assets as never before. You will be able to:
Identify possible exceptions by comparing expensed and capitalizable costs
Review asset details and see how the assets are assigned to projects and tasks
Track capitalizable costs as they are grouped into asset lines, assigned to assets, transferred to Oracle Fusion Assets, and capitalized
Analyze amounts charged to construction-in-progress accounts.
Several sample reports are also provided to highlight various ways you may want to analyze your capital projects. You can use them immediately for data analysis or leverage them as a starting point to create your own customized reports.
Notes
Slide 8 - Analyze Billed and Unbilled Project Cost by Contract Using Oracle Transactional Business Intelligence
Slide notes
The Project Costing – Actual Cost Real Time subject area is enhanced to make it easier to view and analyze billable costs by contract and contract line. The new dimensions also allow you to create ad hoc reports that combine information across project costing and project billing subject areas. Some of the key business questions you’ll be able to answer include:
Where is a cost transaction in the billing lifecycle?
What percentage of a cost transaction is invoiced or recognized for revenue?
Is the correct bill rate applied to the cost transaction?
Which cost transactions are invoiced for a contract or contract line?
Which cost transactions are billed on a particular invoice?
Notes
Slide 9 - Analyze Billing Events for Invoicing and Revenue Recognition Using Oracle Transactional Business Intelligence
Slide notes
The Project Billing – Invoices Real Time subject area and the Project Billing – Revenue Real Time subject area are enhanced so you can report on the invoices and revenue related to billing events. Some of the key business questions you’ll be able to answer include:
Which events are billed on a particular invoice?
Which events were invoiced for a particular contract line?
Notes
Slide 10 - Enhancing Financial Reporting Capabilities
Slide notes
Businesses must be able to quickly and easily access data in real time to make informed decisions.
With the reporting enhancements made in Release 10, you’ll be able to analyze planned and actual costs using Smart View and then distribute the information using Microsoft products.
You can track capital asset and capital expenditures as they proceed through the capitalization process using Oracle Transactional Business Intelligence.
Finally, you can report on expenditures, billing events, and invoice events by contract or contract line to ensure all costs are billed appropriately and revenue is maximized.
All of these enhancements deliver real value by making it easier to create and report on key information that directly impacts your business.
Notes
Slide 131 - Summary of Enhancement Capabilities
Slide notes
Here is the summary of the features we have talked about today. The new enhancements are:
Use Oracle Smart View for Office to access planned and actual cost by project, task, resource, and period. Then use Microsoft Office applications to share the data.
Track assets and capital expenditures in OTBI from the time the costs are captured to the time they are capitalized in Oracle Fusion Assets.
Notes
Slide 132 - Summary of Enhancement Capabilities (continued)
Slide notes
Analyze project costs in OTBI to ensure costs are invoiced and revenue is recognized for a specific contract or contract line.
Report on invoice and billing events in the invoice and revenue subject areas in OTBI.
Notes
Slide 133 - Implementation Advice
Slide notes
In this implementation advice section we will go through what you need to consider before enabling these features in your business, and what you need to know to set them up.
Notes
Slide 134 - Feature Impact Guidelines
Slide notes
All of these new reporting features are automatically available to the user and are included with the shipped job roles. You can use these OTBI features right out of the box as there is no set up required.
To use Oracle Smart View for Office feature, you will have to get the shared connection information from your application administrator.
Notes
Slide 135 - Setup Summary
Slide notes
To use the Oracle Smart View for Office feature to analyze project cost data, you must obtain the shared connection information for the project cube from your application administrator. Open the shared connection options from the Smart View panel and enter the information in the Shared Connections URL field.
Notes
Slide 136 - Job Roles
Slide notes
This table details the shipped job roles that will access the new capabilities covered in this training. The Project Accountant and Grants Accountant can access project cost data using Oracle Smart View for Office. The Project Manager, Project Administrator, Project Accountant, Principal Investigator, Grants Administrator, and Grants Accountant can access capital asset data using the Project Costing – Assets Real Time subject area.
Notes
Slide 137 - Job Roles (continued)
Slide notes
The Project Manager, Project Administrator, Project Accountant, Principal Investigator, Grants Administrator, and Grants Accountant can also access project costs by contract and contract line using the Project Costing – Actual Cost Real Time subject area and event details in Project Billing – Invoices Real Time and Project Billing – Revenue Real Time subject areas. In addition, the Billing Specialist can access event details in the Project Billing – Invoices Real Time subject area.
Notes
Slide 138 - Business Process Model Information
Slide notes
The business processes associated with the new capabilities covered in this training are detailed here.
The Oracle Smart View for Office enhancement is associated with the Control Project business process and the activity Manage Project Performance
The capital asset subject area enhancement is associated with the Manage Project Costs business process and the activity Manage Capital Project
The project cost by contract reporting enhancement is associated with the Manage Project Costs business process and the activity Review Expenditure Item Details
Notes
Slide 139 - Business Process Model Information (continued)
Slide notes
The invoice and billing events reporting enhancement is associated with the Manage Project Contracts business process and the activities Manage Project Contract Billing and Manage Project Contract Revenue.
Notes
Slide 140 - Related Reports & BI Analytic Information
Slide notes
Five new reports that cover the new capital assets subject area features.
The first four reports are:
Capital Asset Assignments, which shows how projects are assigned to projects and tasks
Capital Asset Lines, which focuses on how expenditure items are grouped into asset lines
Capital Assets, which provides additional details about each asset
Capital Expenditures, which shows where expenditures are in the capitalization process
Notes
Slide 141 - Related Reports & BI Analytic Information (continued)
Slide notes
The Uncapitalized Cost for Capitable Tasks report lists the noncapitalizable expenditure items that are charged against capitalizable tasks
Notes
Slide 142 - Related Reports & BI Analytic Information (continued)
Slide notes
The four enhanced subject areas in OTBI are shown here along with the associated dimensions in each subject area. Take a few minutes to read through this information.
This concludes this presentation, thank you for listening. You can easily pause and rewind any of these slides if you require additional time to take in the detail.
Notes
Page 1 of 21