oaug r12 projects overview

Release 12 Oracle Projects Overview

David LipinskiSolution Architect

• Purpose:This document provides an overview of features and enhancements included in

Release 12. It is intended solely to help you assess the business benefits of

upgrading to Release 12.

•Disclaimer:This document in any form, software or printed matter, contains proprietary

information that is the exclusive property of Oracle. Your access to and use of

this confidential material is subject to the terms and conditions of your Oracle

Software License and Service Agreement, which has been executed and with

which you agree to comply. This document and information contained herein

may not be disclosed, copied, reproduced or distributed to anyone outside

Oracle without prior written consent of Oracle. This document is not part of

your license agreement nor can it be incorporated into any contractual

agreement with Oracle or its subsidiaries or affiliates. This document is for

informational purposes only and is intended solely to assist you in planning for

the implementation and upgrade of the product features described. It is not a

commitment to deliver any material, code, or functionality, and should not be

relied upon in making purchasing decisions. The development, release, and

timing of any features or functionality described in this document remains at

the sole discretion of Oracle. Due to the nature of the product architecture, it

may not be possible to safely include all features described in this document

without risking significant destabilization of the code.

Project Costing & Project Billing

Initial release - Jan 1992

Manage ProjectFinancials

ResourceManagement

May 2001

Manage ProjectResources

Manage Projects, Enable Collaboration

ProjectManagement

& CollaborationMay 2003

Manage the Right Projects

ProjectPortfolio Analysis

May 2005

Provide Enterprise Insight

ProjectIntelligence

Oct 2002

Project Accounting to Project Management

• Objectives• Scenarios• Portfolios• Project Approval

• Updates• Forecasts • Changes• Billings• Capitalization

• Progress• Documents• Issues • Actuals

• Workplans• Resources• Budget

• Exceptions• KPI’s• Reports• Accounting Closeout

GlobalProject

Repository

GlobalProject

Repository

Enterprise Project Management with Fp.MManage Full Lifecycle, For All Project Stakeholders

Project Selection & Initiation

Project Reporting & Closeout Project Planning

Project Control Project Execution

Project Intelligence

Resource Management

Accounting & OperationsCollaboration

Project

Management

ProjectInitiatives

Personalized

Role-Based Views

Global

Project

Repository

Global

Project

Repository

Integration to E-Business Suite

Oracle Projects Suite

Portfolio ManagementSalesDelivery

Research

ProductDevelopment

InformationTechnology

Construction

Marketing

Financials

HR

Time & Labor

Sales

Supply Chain

Documents

MS Project& Excel

Integration to Desktop Tools

Integrated Work, Resource, and FinancialsStreamline Planning, Execution & Control

ResourceSchedule

Rollup people resources to create team roles

Budget

Generate budget based on workplan resources*

Generate budget based on team roles

ActualsWorkplanProgress

Actuals can be used to determine progress

Update forecast based on revised budget

Update forecast based on progress (ETC, % Complete)

Update forecast based on actuals

Workplan Financial Forecast

Generate forecast based on workplan

or scheduled team roles

Performance

Analyze metrics, Comparing Actuals vs. Budget vs. Forecast

Standardize Project Creation ProcessFrom Very Simple to Complex Projects

Key Capabilities:

• Leverage project templates or past projects

• Assign resources (both labor & non-labor) at the task level

• Unlimited WBS

• Integration with Microsoft Project for Scheduling and Progress Tracking/Updates

• Track Project Deliverables

• Use workflow to streamline approvals and phase gate processes

• Email Notifications

• Audit History

• Alerts of Exceptions out of Threshold

• Configurable Process based on Type of Project, Change, Task, etc.

• Status Reports

CreateWorkplan

Approve

Publish and

Version

Workplans

WBSTemplate

DeliverablesWork

EstimatesResources

Project Creation in HTML

Get Projects into Oracle Earlier – Gain Insight Faster!

NEW World

• Project Managers create projects themselves

• PM’s plan work, budget, resources

• Standardize business processes with templates

• Workflow enable project approval processResources

Time Scope

Pla

nP

lan

Execu

teE

xecu

te

ControlControl

Forms/Old World

• Project Accounting/Finance has to create projects based on requests from Project Managers – email, paper form requests, Excel spreadsheets, etc.

Project Creation in HTMLAllow Project Managers to Request & Plan Project

Work Breakdown Structure MaintenanceFinancial Task Details in HTML

Workplan TasksAdd’l Task Details enabled with Project Management

Project Budgeting & ForecastingImprove Forecast Accuracy and Efficiency

• Generate budgets based on resource plan, workplanschedule & commitments

• Automatically create forecasts, pull in Actuals-To-Date

• Compare variances to prior forecasts

• Create ETC based on:- Earned value- Percent complete- Future budget amounts- Future resource schedule- Open Commitments- Open Change Orders

• Adjust in summary or detail, Task or Resources

• Edit in Excel

• Create and compare “what if” scenarios

• Route for Approval via Workflow

Iexplore.exe

Adjustvia Excelor Web

ActualCosts

InitialBudget

Resources

Changes

Workplan

Forecast

Forecast (EAC) = Actuals + Estimate to Complete (ETC)

Forecast EntryFlexible Planning Levels & Entry Methods

Forecast Edit in ExcelBi-Directional, for Easy Updates

Project Performance ReportingAccurately Assess Project Health and Drilldown to Root Causes

• Define, view and investigate exceptions to performance; drill down to details

• Exceptions flagged based on Business-Defined Thresholds

• Review project performance via multiple reports

- By Tasks of WBS

- By Resource Hierarchy

- By Period and Trend, Graphs

- By Currency

- Earned Value

• Rollup Program Information from Subprojects

• Schedule: Dates, Effort/Cost, Resources

• Financials: Actual, Budget, Forecast, Billings & Collections

Project

Program

Project

TasksTasksTasksTasks

Resource Resource Resource Rep

ort

at

An

y L

evel

Transactions

Performance ReportingPSI Next Generation! Self-Service Project Mgr Access

Performance ReportingBy WBS, Drilldown to Expenditures & Commitments

Performance ReportingFlexible Resource Breakdown Structure Hierarchies

Performance ReportingPeriodic Data

Invoice ReviewDrilldown, Approve Invoices Online!

Project Portfolio AnalysisAlign Organizational Goals and Resources

PlanPortfolio

PlanPortfolio

ExecutePortfolio

MonitorPortfolio

Portfolio Management

Define Standard Objectives

Determine Project Costs

and Requirements

Score and Rank All Projects

Balance Portfolio

Approve & Launch Portfolio

R12 GoalsThe Global Business Release

3

• Think Globally to make the right decisions•“I can make more informed decisions with a global view of customer / supplier / partner / operations”

• Work Globally to be more competitive•“My business will be more competitive with better support for work that crosses applications, divisions, and regions”

• Manage Globally to lower cost and increase performance

•“R12 makes it easier and less expensive for me to implement, manage, and scale global applications”

WORK GLOBALLY

To Be More Competitive

WORK GLOBALLY

To Be More Competitive

THINK GLOBALLY

To Make the Right Decisions

THINK GLOBALLY

To Make the Right Decisions

MANAGE GLOBALLY

To Lower Cost & Increase Performance

MANAGE GLOBALLY

To Lower Cost & Increase Performance

How Release 12 Projects ContributesThe Global Business Release

Subledger Accounting

Multi-Org Access Control

(MOAC)

Standardized Data Model

for MRCProgram Management

Portfolio Management XML Publisher

Fusion MiddlewarePerformance Management

Supplier Cost

Management

Subcontractor Payment

Management Uptake

Revenue in a Foreign

Currency

Oracle Projects Specific

BPEL

Release 12 Financial Initiatives

(Projects Uptake)

• Subledger Accounting Uptake

• Multi-Org Access Control (MOAC)

• Legal Entity / Ledger Architecture

• Standard Data Model for Multiple Reporting Currencies –MRC Migration

• Budget Controls and Public Sector Accounting – Funds Management

• TCA Uptake

• eTax Uptake

Release 12 Projects Initiatives

• Supplier Cost Management

• Improved Project Costing with Cash Basis Accounting

• Removal of Supplier Cost Adjustment Restrictions

• Mass Adjust Concurrent Processing

• Aids for Oracle Payables and Project Costing Reconciliation

• Flexible Derivation of Expenditure Item Date

• Subcontractor Payment Management Uptake

• Revenue in a Foreign Currency





• Standard Data Model for Multiple Reporting Currencies – MRC Migration


• TCA Uptake

• eTax Uptake

• What is Subledger Accounting?

• SLA is an intermediate step between subledger products and the Oracle General Ledger

• Journal entries are created in Subledger Accounting and then transferred to Oracle General Ledger

• Each subledger transaction that requires accounting is represented by a complete and balanced subledger journal entry stored in a common data model

Subledger Accounting

Release 11i

Accounting model and

transaction model are tightly

integrated

Release 12.0

Accounting model is separated

from the transaction model

Subledger

Products

Projects

Payables

Receivables

General

Ledger

Subledger

Products

Projects

Payables

Receivables

Subledger

Accounting

AR Rules &

journal entries

PA Rules &

journal entries

AP Rules &

journal entries

General

Ledger

Subledger Accounting Upgrade / Setup

• Infrastructure to centralize accounting setup

• Subledger Accounting is the engine used to store the rules for accounting transactions from various applications across the Oracle E-Business Suite

• Infrastructure to standardize accounting policies

• Business users can extend predefined accounting rules or create their own rules allowing organizations to react immediately to change.

• Extensible list of sources to derive accounts

• Projects will be seeding over 300 sources to help customers derive accounts and account descriptions



• Upgrade process seeds SLA with rules to automatically accept the accounts that Projects sends (derived from AutoAccounting)

• Existing Customers:

• If the accounting provided in Release 11i is satisfactory, then it is recommended that customers leave their AutoAccounting and SLA setups untouched.

• May utilize SLA setups if AutoAccounting did not fully meet their needs.

Release 11i Release 12

Subledger Accounting Flow Comparison for Expenditures

Enter or import expenditures

Distribute costs

Interface Costs to GL

Journal Import (Oracle GL)

Tieback Cost Distributions from GL Journal Import (Oracle GL)

Create Accounting

Generate Cost Accounting Events

Enter or import expenditures

Distribute costs

Release 11i Release 12

Generate Revenue for a Single/ Range of

Projects

Review Revenue

Release Revenue

Interface Revenue to GL



Create Accounting

Generate Revenue Accounting Events

Generate Revenue for a Single/ Range of

Projects

Review Revenue

Release Revenue

Subledger Accounting Flow Comparison for Revenue