day 2 case management, case costing & billing pm

7/31/2019 Day 2 Case Management, Case Costing & Billing Pm

1/37

Day 2 Case Management, Case Costing &Billing

EBS Project Costing, Billing, Project Management


2/37

CONFIDENTIAL: All capabilities and dates are for planning purposes only and may not be used in any contract

The following is intended to outline our general

product direction. It is intended for information

purposes only, and may not be incorporated into

any contract. It is not a commitment to deliver any

material, code, or functionality, and should not be

relied upon in making purchasing decision. The

development, release, and timing of any features

or functionality described for Oracles products

remains at the sole discretion of Oracle.

Safe Harbor Statement


3/37


Program Agenda

Day 1

EBS Overview

Case Financials (General Ledger)

Federal Administration

Day 2

Case Management, Case Costing & Billing

Purchasing Case Materials & Services

Payables

Day 3 Case Order Entry / Inventory Management

Reporting and Business Intelligence


4/37


Foundation:Unified Information Architecture

Common data modelenables a single sourceof truth

Comprehensive suite ofapplications designed to

work together Robust set of integration

services based on openstandards

Modular deploymentby business flow

Single global instanceimplementations

Customers,

Suppliers,

Products,

Develop

Market

Sell

Order

Plan

Procure

Make

Fulfill

Service

Maintain

Finance

HR

Projects

Contracts


5/37


Silos of information, inefficient processes Limited collaboration and cross-project analysis Lack of management visibility, reactive decision making

Operational ChallengesFragmented Information and Systems

BusinessUnits

Departments

Geographies

OtherProjects

Management

Customers /Partners

ProjectPlans

Forecasts

ResourcesFinancesDeliverables

Changes


6/37

Effectively Plan, Execute, and Control Projects

Leverage Resources Across Global Enterprise

Access Personalized, Secure & Current Project Information

Automate Project Operations

Provide Timely and Critical Information

Enables you to

Oracle Projects



7/37CONFIDENTIAL: All capabilities and dates are for planning purposes only and may not be used in any contract

Project ManagementManage Full Lifecycle with Integrated Project Information

Integrated

Intelligence

Execute

Control

Plan

View progress

Manage changes Forecast at completion

Establish plan Assign resources Automatically

create budget& forecast

Completedeliverables

Share documents Raise issues Update progress

Manage performance& exceptions

Communicate status

ProjectManager

TeamMembers

Executives

FinancialSystems

Scheduling /Estimating

Tools

HRSystem

Role-Based

Access


8/37


Create the WorkplanSet Up Project Plans with Less Effort

Leverage project templates to create plans Assign resources (both labor & non-labor)

at the task level

Support comprehensive deliverables mgmt- Assign at task level and define weight- Integrate with other apps (e.g. purchasing to

automatically create purchase req.)

- Automatically track progress vs. deliverables

Establish dependencies within & across projects

Leverage integration with scheduling tools

Display critical path via Gantt chart

Use workflow to streamline approvals and

task execution Support flexible relationships between work

and financial plan

Enable unlimited project hierarchies

CreateWorkplan

Approve

Publish andVersion

Workplans

WBSTemplate

DeliverablesWork

EstimatesResources


9/37


Manage the Budgeting ProcessStreamline Budget Creation and Approval

Generate cost budget based on resource plan, workplan & commitments

Generate revenue budget based on multiple accrual methods (e.g. timeand material, percent spent, milestones)

Support flexible options for creating budget

Create and compare what if scenarios

Automatically route and approve budgets

Track baseline and multiple versions of project budgets

Cost Budget Resources

Workplan

Commitments

Revenue Budget Time, Materials

% Spent

Milestones

Route andApproveBudgets

Adjustvia Excelor Web

Baseline& VersionBudgets


10/37


Report on numerous items(by percent complete orestimate to complete)

- Tasks

- Deliverables

- Issues and Changes

Rollup individual results tooverall project progress

Rollup task progress using

various methods of taskweighting

Progress Tracking and VisibilityGain Visibility to Project Schedules and Progress

PublishRevised Plan

CommunicateProgress

Revisions

v.3v.2

v.1

Work Plan

ProjectManager

TeamMember

TeamMember

TeamMember


11/37


- Record thechange

- Capturemultiplerequestsinto changeorder

- Impact tobudget

- Conduct multi-threadeddiscussions

- Include inforecasts

- Updatebudgetwith impacts

- Retain history

- Workflow-drivenprocesses

- Enableautomaticnotifications

Change ManagementRapidly Respond to Project Changes

View impact of changes to budget prior to accepting / approving Provide complete audit trail of historical changes

Quickly identify potential areas of risk and take action to mitigate

Executives

ProjectManagers

TeamMembers

DefineChange

EvaluateImpact

Route &Approve

Implement


12/37


Project ForecastingImprove Forecast Accuracy and Efficiency

Automatically create initial forecaston baseline of approved budget

Compare variances to prior forecasts

Create cost ETC based on:- Earned value

-

Percent complete- Future budget

amounts- Future resource

schedule

Adjust forecast in summary or detail

Adjust quantity, rates, cost orrevenue by % across all areas

Adjust

via Excelor Web

ActualCosts

InitialBudget

Resources

Changes

Workplan

Forecast

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

- Work quantity

-

Workplan- Remaining effort- Open commitments- Change documents


13/37


Earned Value ManagementMeasure Cost and Schedule Performance Against Plan

Calculate key metrics- Planned Value

- Earned Value

- Actual Cost

- Budget at Completion

- Estimate at Completion

- Variances (cost, schedule)

- Indices (CPI, SPI, TCPI)

Generated from workplan,resource plan, and budget

Leverages progress anddeliverables management

Include in forecastcalculation & status reports

Time

Cost

Today

Budgeted Cost of Work Performed(BCWP) or Earned Value

Actual Cost

PlannedValue

Estimate atCompletion

(EAC)Budget at

Completion(BAC)

ScheduleVariance

Variance atCompletion

CostVariance


14/37


Project Performance and ExceptionsAssess Project Health and Resolve Problem Areas

Define, view and investigate exceptionsto performance; drill down to details

Review project performance via multiplereports:

- Report financial info and earned value

- Configurability with graphs and drilldown

-

Analysis by program, projects, WBS,RBS, period

- Report project & project functional currencies

Review invoices and revenue

Project

Program

Project

TasksTasksTasksTasks

Resource Resource Resource

ReportatAnyLevel

Report on: Exceptions Earned Value

Project Costs Resources & Dates


15/37


Example:Status ReportsIncrease Visibility and Communicate Status in a Timely Manner

Capture standardized, real-time

updates via online reporting Automatically generate project

status reports

Design reports to include anyfactors such as

- Workplan- Performance metrics- Issues and exceptions- Change orders

Tailor status reports to specificstakeholders

Distribute reports via workflow-driven processes

Progress

ResourcesIssues &Changes

Workplan

Status Reports

Deliverables

Dramatically Reduce Time to Create Status Reports;Provide Visibility for Immediate Action


16/37


Integrate with HR systemsto obtain detailed resourceinformation

- Contact information

- Location

- Resume and skills

- Cost rates

Review contingent workerinformation

View available equipmentand materials

Enable employees to update

information View schedules and

availability for all resources

Global Resource RepositoryProvide Visibility into All Project Resources

HRSystems

Employees

Schedules & Availability

GlobalResource

Repository

ContingentWorkers

Non-Labor


17/37


Resource RequirementsQuickly Determine Critical Project Requirements

DefineRequirements

IdentifyStaffingNeeds

UpdateRequirements

Competenciesand proficiencylevels

Location andschedule

Resource loanagreements forshared resources

Based onindividual projectrequirements

Quantify specificroles to be filled

As projectneeds change

As roles arefilled orvacated


18/37


Monitor Enterprise UtilizationMaximize Productivity and Profitability

Track Utilization of Global Resources- Actual and scheduled time- Personal and organization- Missing time- Time off- Billable time

Support Flexible Calculation Methods- By capacity or actual hours worked- Varied weighting % by work type

Monitor Trends

- By organization, role, job, or project- Switch views, drilldown to details


19/37


Coordinate work

Complete deliverables

Share documents

Resolve issueswith deliverables

Structured ProjectWorkspace

Customers

Subcontractorsand Partners

Employees

CollaborationAccess Personalized, Secure, and Current Information

ProjectManagers


20/37


Provide visibility intolatest information

- Work to the most currentproject plans

- Review all assigned tasks &overall schedule

Update tasks & deliverables- Provide progress status

- Update % complete andestimated dates

Update action items Raise and review issues

View Personalized Project Informationin a Single Location

Take action onassignments


21/37


Provide secure, role-basedcollaboration on all projectinformation (deliverables,documents, tasks, etc.)

Share information real-timewith customers and suppliers

Track status of all projectdeliverables & associated tasks

Store files on a secure projectdocument repository

- Oracle Files Online or any systemusing WebDav protocol

- Enable file foldering, versioning,and locking

Coordinate Work Across TeamEnable Real-Time Communication and Updates

ExecutivesProject

Managers

TeamMembers

Documents

Deliverables Tasks

Customers

Suppliers


22/37


Collaborate and Share DocumentsShorten Review Cycles for Deliverables and Documents

* Requires Oracle CADView-3D

Support On-Demand, Real-Time,Multi-User Collaboration

- Threaded reviews & discussions

- Mark-up controls

- Interactive control transfer

Attach Technical Documentsto Projects

Co-Browse CAD Files- View 2D and 3D

Technical Documents*- Supports Major CAD Systems*


23/37


Issue ResolutionIncrease Visibility of Critical Issues

Define Resolve Approve

- Owner- Priority- Due date- Documents

- Assign actions

- Conduct threaded discussion

- Record resolution

- Create change order

- Streamlined withworkflow

Executives

ProjectManagers

TeamMembers

Capture issues early in project lifecycle to mitigate schedule / budget overruns

Empower team members to raise concerns and participate in resolution


24/37


Accounting and OperationsAutomate Project Operations with Back-Office Systems

Manage to Budget

Accrue Revenue

Invoice Customer

Cross-Charge Resources

Capitalize Assets

Collect and Manage Costs

Time & Expense

Material Costs

Supplier Invoices

Commitments

Allocations


25/37


Consolidate Project CostsDetermine the True Cost of Business

Capture labor costs and expenses forall personnel

- Define flexible labor rates based onemployee, job, organization or time

- Submit timecards with OTL

Capture material costs- Calculate burdened cost of inventory and WIP

transactions

- Interface inventory item and BOM resourceattributes with Project Manufacturing

Upload expenditures with Excel

Integrate with financial systems to capture

other expenses and commitments Allocate costs to tasks and projects

Support transactions in multiple currencies

FinancialSystems

WebBrowser Excel

AssignOverhead &Allocate Costs

CaptureTotal Costs

Labor Costs Material Costs


26/37


EstablishTransaction and

Budgetary Controls

AdjustProject Costs

Manage Project CostsIncrease Control over Project Expenditures

Correct approvedexpenditures

Change billable status Recalculate raw or

burdened costs

Split expenditure items

Provide historical audittrail of all adjustments

Limit which expenditures canbe charged to project by:- Category

- Employee- Date Range

Limit expenditures basedon available funding- Hard or soft limits- Automatically update

funding levels

Manage All Expenditures -- Labor, Materials, Subcontractors, Etc.


27/37


Manage All Customer AgreementsImprove Visibility of Project Funding

Funding

Agreement

Project level funding

Top task funding

Customer at top task Installment funding

Quick agreement

Payment terms

Hard or soft limits

Pull customeror contractualinfo fromupstreamsystems

Capture customeragreements

Support multiplefunding types


28/37


Generate invoices online

-

Enable configurable billing cycles- Across range of projects or for single project

- Support retention billing

- Invoice at project or top task level

Review, adjust & approve invoices online

Print & post invoices in multiple formats

Accrue revenue based on policiesand agreements

- As billed

- Percent complete

Manage unearned revenue (UER) andunbilled receivables (UBR), includingposting to GL in different functional andrevenue transaction currencies

Manage Invoice Generation & Revenue AccrualImprove Cash Flow via Streamlined Project Billing

ManageUER/UBR

AccrueRevenue

GenerateInvoices

Expenditures Progress Milestones Deliverables

- Percent spent

- Time and materials


29/37


Contingent WorkersManage External and Internal Workers the Same

Define contingent workers

Assign contingent workers to tasks

Process labor costs of contingent workers

Link and validate timecards against supplier purchase orders

Process contingent worker expenses same as employees

PO Validation

Payment

HR, Contractors,

Suppliers

FinancialsProject

Costs

Batch Entry via Excel

Self-Service Expenses

Time & Labor Reporting


30/37


Set up cross charge rules

and transfer prices Support multiple

cross-charge transactions- Inter-operating unit

- Intra-operating unit

Streamline Resource SharingBuild Virtual Teams Across Organizations

Project(US West)

Transfer Cost to US Westvia Inter-Company Invoices

Transfer Revenue to US Westvia Borrowed & Lent Acctg.

USEast IndiaFrance

USWest

Example:

Configure cross charging

accounting methods- Borrowed and

lent accounting

- Intercompanybilling accounting


31/37


Manage Asset CapitalizationIncrease Accuracy and Efficiency of Capitalization

DefineAssets

Place

Assets inService

Calculate

CapitalizedInterest

RetireAssets

Define All Assets

Capital or CIP* Assets For new construction, installation,or acquisition

Associate assets to project WBS

Calculate Interest

Calculate capitalized interest

Record interest

Capitalize Costs

Place assets in serviceseparately

Capitalize CIP asset costs- Allocate & group asset costs

- Automatically generate assetlines from CIP costs

Retire Assets

Capture retirement andremoval costs

Process proceeds from sale

* Construction in Process

Integrate with Asset Mgmt Systems


32/37


Executives

Margin

Actuals toBudget

Bookings& Backlog

UtilizationProject and

Program

Managers

Organization

Resource

PersonalizedPortal

OperationsManagers

Projects and

Programs

View byRoles

Enterprise and Project InsightProvide Timely and Critical Information to Right People


33/37


Enterprise and Project Insight

Links toAdditional Reports

Backlog

summary

Cost Trends

Cost

Summary

A l P f A th


34/37


Bookings

Backlog

Book to Bill

Utilization

Availability

Contract Labor

Project Profitability

Project Cost

Analyze Performance Across theBusiness Lifecycle

OpportunityManagement

ResourceManagement

ProjectFinances

Improve Project Success with Actionable Information

Gain Insight into Critical Business Areas

R i K M t i ith D ill


35/37


Review Key Metrics with DrillDown to Projects and Transactions

Analyze performance fromdifferent perspectives basedon role

Data at all levels of projectsand programs to stay informed

Trend and comparative analysisat all levels of programs & projects

Drill down from organization toproject to transactions to spotexceptions and root causes

Organization

Project

Transaction

Program

Quickly Identify Key Problem Areas

Metrics


36/37


Access Personalized, Role-Based AnalysisGet the Right Information to the Right People

ExecutivesOperationsManagers

Project &ProgramManagers

Business Views

EnterpriseTransaction Schema

DirectSummaries

BusinessMetrics

ProjectPerformance

OperationalAnalysis

Single repository of

project metrics for allstakeholders

Secure andpersonalized accessto all information


37/37