Oracle ProjectsFundamentals Release 12.1Part No. E13581-04

August 2010

Oracle Projects Fundamentals, Release 12.1 Part No. E13581-04 Copyright 1994, 2010, Oracle and/or its affiliates. All rights reserved. Primary Author: Rinku Mohapatra Contributing Author: Ashita Mathur, Debjit Nag, Harry Anthony, Jagneswar Guha, Prashanti Gajjala Contributor: Nishant Sinha, Parag Lawate Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited. The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing. If this software or related documentation is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, the following notice is applicable: U.S. GOVERNMENT RIGHTS Programs, software, databases, and related documentation and technical data delivered to U.S. Government customers are "commercial computer software" or "commercial technical data" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, the use, duplication, disclosure, modification, and adaptation shall be subject to the restrictions and license terms set forth in the applicable Government contract, and, to the extent applicable by the terms of the Government contract, the additional rights set forth in FAR 52.227-19, Commercial Computer Software License (December 2007). Oracle USA, Inc., 500 Oracle Parkway, Redwood City, CA 94065. This software is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications which may create a risk of personal injury. If you use this software in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy and other measures to ensure the safe use of this software. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software in dangerous applications. This software and documentation may provide access to or information on content, products and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third party content, products and services. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third party content, products or services.

Contents

Send Us Your Comments Preface 1 Overview of Oracle ProjectsOverview of Oracle Projects......................................................................................................1-1 Oracle Project Costing.......................................................................................................... 1-2 Oracle Project Billing............................................................................................................ 1-3 Oracle Project Resource Management..................................................................................1-4 Oracle Project Management................................................................................................. 1-5 Oracle Project Collaboration................................................................................................ 1-6 Oracle Daily Business Intelligence for Projects.................................................................... 1-6 Oracle Project Portfolio Analysis......................................................................................... 1-7

2

OrganizationsOrganizations............................................................................................................................ 2-1 Defining Organizations........................................................................................................ 2-2 Business Groups.................................................................................................................. 2-8 Operating Units and Multiple Organizations.................................................................... 2-10 Defining Organization Hierarchies.................................................................................... 2-12 Assigning Burdening Hierarchies...................................................................................... 2-15 Locations............................................................................................................................ 2-16 Adding Operating Units ................................................................................................... 2-17 Adding Organizations to the Project Burdening Hierarchy Version................................. 2-22 Case Study: Organization Change in Fremont Corporation.................................................. 2-22 Business Assumptions....................................................................................................... 2-24

iii

Business Requirements...................................................................................................... 2-24 Planning the Organization Change.................................................................................... 2-25 Setup Steps Required for an Organization Change............................................................2-27

3

ResourcesOverview of Resources.............................................................................................................. 3-1 People Resources................................................................................................................. 3-2 Resource Types.................................................................................................................... 3-5 Resource Lists...................................................................................................................... 3-6 Planning Resource Lists............................................................................................................ 3-7 Resource Breakdown Structure............................................................................................... 3-14

4

Project Team DefinitionProject Teams and Team Roles................................................................................................. 4-1 Team Roles........................................................................................................................... 4-2 Defining Nonscheduled Team Members................................................................................. 4-3 Staffing Plan.............................................................................................................................. 4-4 Defining Scheduled Team Members........................................................................................ 4-5 Project Requirements........................................................................................................... 4-5 Project Assignments............................................................................................................. 4-9 Team Templates ................................................................................................................ 4-11 Creating Team Templates ........................................................................................... 4-11 Applying Team Templates ......................................................................................... 4-12 Creating Administrative Assignments...............................................................................4-12 Defining Organization Roles.................................................................................................. 4-13 Assigning People to Projects................................................................................................... 4-14 Person Resource Schedules ............................................................................................... 4-15 Reviewing Person Schedules............................................................................................. 4-15 Maintaining Person Schedules........................................................................................... 4-16 Overview of Timelines ...................................................................................................... 4-17

5

RatesOverview of Rates..................................................................................................................... 5-1 Using Rates for Costing............................................................................................................. 5-3 Using Rates for Billing.............................................................................................................. 5-5 Using Rates for Workplan and Financial Planning.................................................................. 5-9

6

Project Definition and InformationOverview of Projects and Tasks................................................................................................ 6-1

iv

Project Structures....................................................................................................................... 6-2 Overview of Project Structures............................................................................................ 6-2 Enabling Project Structures.................................................................................................. 6-6 Workplan Structures ........................................................................................................... 6-6 Program Management....................................................................................................... 6-10 Financial Structures........................................................................................................... 6-11 Defining Your Financial Structure............................................................................... 6-11 Managing Tasks In A Financial Structure............................................................. 6-14 Viewing a Financial Structure..................................................................................... 6-16 Running Financial Structure Process Updates.............................................................6-16 Integrating Workplan and Financial Structures................................................................. 6-17 Project Lifecycles..................................................................................................................... 6-19 Overview of Project Lifecycles........................................................................................... 6-20 Defining Lifecycles............................................................................................................. 6-20 Using Lifecycles................................................................................................................. 6-20 Assigning Lifecycle Phases to Tasks.................................................................................. 6-20 Project and Task Attributes.....................................................................................................6-21 Project Information............................................................................................................ 6-21 Basic Project Information............................................................................................. 6-22 Name.....................................................................................................................6-22 Long Name........................................................................................................... 6-22 Number................................................................................................................. 6-22 Project Organization............................................................................................. 6-22 Project Type.......................................................................................................... 6-23 Status.................................................................................................................... 6-24 Description............................................................................................................ 6-25 Public Sector (Public)............................................................................................ 6-25 Access Level.......................................................................................................... 6-25 Location................................................................................................................ 6-25 Project Start and Finish Dates............................................................................... 6-26 Precedence for Displayed Start Date and Finish Date.................................... 6-26 Default Effective Dates for Team Members.......................................................... 6-27 Additional Information............................................................................................... 6-27 Work Type............................................................................................................ 6-27 Assignment Precedes Task For Actuals................................................................ 6-28 Billing Job Group.................................................................................................. 6-28 Additional Attributes............................................................................................ 6-28 User-Defined Project Attributes............................................................................ 6-29 Calendars for Projects and Resources................................................................... 6-29 Organizations........................................................................................................ 6-30 Team Members (Key Members)............................................................................ 6-30

v

Page Layouts and Tabs......................................................................................... 6-30 Structures.............................................................................................................. 6-32 Item Association................................................................................................... 6-32 Tasks..................................................................................................................... 6-33 Project Classifications ................................................................................................. 6-41 Pipeline........................................................................................................................ 6-41 Resource Information......................................................................................................... 6-42 Candidate Score Weightings....................................................................................... 6-42 Subteams..................................................................................................................... 6-43 Additional Staffing Information.................................................................................. 6-43 Costing Information........................................................................................................... 6-43 Costing Burden Schedules........................................................................................... 6-43 Budgetary Control....................................................................................................... 6-44 Currency...................................................................................................................... 6-46 Burden Schedule Overrides......................................................................................... 6-46 Labor Multipliers......................................................................................................... 6-47 Asset Information.............................................................................................................. 6-47 Capital Information............................................................................................................6-48 Billing Information............................................................................................................. 6-50 Billing Setup................................................................................................................ 6-50 Revenue and Billing Information.......................................................................... 6-50 Invoice Formats.....................................................................................................6-53 Funding................................................................................................................. 6-53 Billing Setup for Top Tasks......................................................................................... 6-54 Credit Receivers .......................................................................................................... 6-55 Billing Assignments .................................................................................................... 6-56 Customer Billing Retention......................................................................................... 6-56 Standard Billing Schedules.......................................................................................... 6-57 Billing Currency.......................................................................................................... 6-58 Billing Currency Options...................................................................................... 6-58 Currency Option Check Boxes.............................................................................. 6-58 Invoice Processing Currency................................................................................. 6-60 Conversion Attributes to Project Functional Currency, Project Currency, and Funding Currency................................................................................................. 6-60 Currency Conversion Attributes........................................................................... 6-61 Rate Overrides................................................................................................................... 6-62 Job Bill Rate and Discount Overrides ......................................................................... 6-62 Employee Bill Rates and Discount Overrides ............................................................. 6-63 Non-Labor Bill Rate and Discount Overrides ............................................................. 6-64 Job Overrides..................................................................................................................... 6-66 Job Assignment Overrides........................................................................................... 6-66

vi

Job Billing Title Overrides........................................................................................... 6-67 Job Group (Additional Information Window).............................................................6-67 Reporting Information....................................................................................................... 6-68 Cross Charge...................................................................................................................... 6-68 Organization Overrides..................................................................................................... 6-69 Transaction Controls.......................................................................................................... 6-69 Project Templates.................................................................................................................... 6-70 Project Template Design Considerations........................................................................... 6-71 Creating a Project Based on a Project Template................................................................. 6-73 Defining Project Templates and Quick Entry .................................................................... 6-76 Start Date and Finish Date in Project Templates......................................................... 6-76 Quick Entry Date Shift Examples................................................................................ 6-77 Project and Task Organizations in Project Templates..................................................6-78 Team Members in Project Templates...........................................................................6-79 Project Classifications in Project Templates.................................................................6-81 Project Customers in Project Templates...................................................................... 6-82 Defining Quick Entry Fields.............................................................................................. 6-83 Specifying Project and Task Options for a Template......................................................... 6-84 Enabling User-Defined Attributes in Project Templates.................................................... 6-85 Creating, Updating, and Disabling Project Templates....................................................... 6-86 Project and Task Information Entry....................................................................................... 6-86 Entering Project and Task Options.................................................................................... 6-86 Using Effective Dates to Enable or Disable Options.......................................................... 6-92 Creating Projects...................................................................................................................... 6-92 Creating a New Project from a Project Template or Existing Project................................. 6-92 Deleting a Project......................................................................................................... 6-95 Project Requests...................................................................................................................... 6-96 Creating a Project from a Project Request.......................................................................... 6-96 Viewing Projects and Project Information............................................................................. 6-98 Project Search..................................................................................................................... 6-98 Minimum Search Criteria for All Methods.................................................................. 6-98 Keyword Searches....................................................................................................... 6-99 Simple Searches........................................................................................................... 6-99 Advanced Searches....................................................................................................6-100 Alternate Project Searches......................................................................................... 6-101 Project Access Levels................................................................................................. 6-102 Project List....................................................................................................................... 6-103 Project Sets....................................................................................................................... 6-106 Project Workbench........................................................................................................... 6-107 Project Workbench Organization.............................................................................. 6-107 Project Tab................................................................................................................. 6-107

vii

Resources Tab............................................................................................................ 6-108 Workplan Tab............................................................................................................ 6-108 Control Tab................................................................................................................ 6-108 Financial Tab............................................................................................................. 6-109 Reporting Tab............................................................................................................ 6-109 Supplier Tab.............................................................................................................. 6-109 Billing Workbench........................................................................................................... 6-109 Supplier Workbench........................................................................................................ 6-112 Summary................................................................................................................... 6-112 Deductions................................................................................................................ 6-115 Create Deductions............................................................................................... 6-116 Projects................................................................................................................................... 6-118 Task Details .......................................................................................................................... 6-119

7

UtilizationUtilization.................................................................................................................................. 7-1 Utilization Time Periods...................................................................................................... 7-2 Work Types and Utilization Categories............................................................................... 7-2 Utilization Views................................................................................................................. 7-3 Utilization Calculation......................................................................................................... 7-3 Utilization Reporting........................................................................................................... 7-4 Reviewing the Resource Details: Utilization Page......................................................... 7-5 Reconciling Utilization Totals........................................................................................7-6

8

Organization ForecastingUnderstanding Organization Forecasting................................................................................ 8-1 Organization Forecasting Concepts..................................................................................... 8-1 Organization Forecasting Features...................................................................................... 8-2 Using Organization Forecasting............................................................................................... 8-3 Organization Forecasting Process Flow............................................................................... 8-3 Defining Prerequisite Forecast Information.................................................................. 8-3 Submitting Calculation Processes.................................................................................. 8-5 Creating Versions and Generating Amounts.................................................................8-5 Reviewing Forecast Amounts........................................................................................ 8-5 Adjusting Forecast Amounts......................................................................................... 8-5 Submitting and Creating Baselines................................................................................8-5 Creating Organization Forecasts.......................................................................................... 8-6 Creating a Forecast Version and Generating Amounts................................................. 8-6 Maintaining Forecast Versions...................................................................................... 8-7 Adjusting Generated Amounts......................................................................................8-7

viii

Reviewing Organization Forecast Results............................................................................8-8 Budgets and Forecasts Page.......................................................................................... 8-8 Organization Forecast Summary Page.......................................................................... 8-8 Viewing Forecast Revenue Components................................................................ 8-9 Viewing Forecast Cost Components....................................................................... 8-9 Viewing Forecast Utilization Components........................................................... 8-10 Viewing Forecast Headcount Components...........................................................8-10

9

System Administration and MaintenanceUnderstanding Data Processing................................................................................................ 9-1 Deferred Workflow Processes................................................................................................... 9-2 Available Item Types .......................................................................................................... 9-3 Recommended Process Scheduling Parameters .................................................................. 9-3 Archiving and Purging Projects................................................................................................ 9-4 Purging Process Overview................................................................................................... 9-6 Purging Safely and Efficiently............................................................................................. 9-8 Prerequisites for Purging Projects........................................................................................ 9-9 Statuses Associated with Purging...................................................................................... 9-13 Purge Procedures............................................................................................................... 9-15 Instructions for Archiving and Purging Projects......................................................... 9-15 Step One: Create a Purge Batch............................................................................. 9-15 Step Two: Review and Refine the List...................................................................9-18 Step Three: Validate the Projects in the Purge Batch.............................................9-19 Step Four: Release the Purge Batch....................................................................... 9-20 Step Five: Start the Purge Process......................................................................... 9-20 Modifying an Existing Purge Batch............................................................................. 9-21 Deleting a Purge Batch................................................................................................ 9-21 Correcting Errors......................................................................................................... 9-22 After Purging..................................................................................................................... 9-22 Setting Up for Archiving and Purging....................................................................................9-24 Assigning Purge Responsibility......................................................................................... 9-25 Profile Option.................................................................................................................... 9-25 Client Extensions............................................................................................................... 9-25 Transaction Tables Used in Archiving and Purging.......................................................... 9-25 Purged Tables and Archive Tables.................................................................................... 9-26 Actuals Tables............................................................................................................. 9-26 Summarization Tables................................................................................................. 9-27 Capitalization Tables................................................................................................... 9-28 Multiple Reporting Currencies Tables.........................................................................9-28 Cross Charge Tables.................................................................................................... 9-29

ix

Staffing Transaction Tables......................................................................................... 9-29 Resource Unassigned Time Tables.............................................................................. 9-30 Mass Update for Projects and Tasks ...................................................................................... 9-31 Creating A Mass Update Batch.......................................................................................... 9-31 Mass Update Batches Window Reference.......................................................................... 9-32 Processing A Mass Update Batch....................................................................................... 9-34 Mass Update Batch Verifications....................................................................................... 9-35 Impacts of Merging Customer Information........................................................................... 9-37 Entities Affected by Customer Merge Operations............................................................. 9-37

10

ProcessesProcesses in Oracle Projects.................................................................................................... 10-1 Submitting Processes......................................................................................................... 10-2 Submitting Streamline Processes........................................................................................... 10-2 Interface Streamline Processes........................................................................................... 10-3 Project Streamline Processes............................................................................................ 10-11 One-Step Interface Streamline Processes to GL................................................................10-19 Distribution Processes........................................................................................................... 10-23 Create and Distribute Burden Transactions..................................................................... 10-23 Distribute Borrowed and Lent Amounts......................................................................... 10-25 Distribute Expense Report Adjustments.......................................................................... 10-26 Distribute Labor Costs..................................................................................................... 10-27 Distribute Supplier Cost Adjustments............................................................................. 10-29 Distribute Total Burdened Cost....................................................................................... 10-31 Distribute Usage and Miscellaneous Costs...................................................................... 10-32 Generation Processes............................................................................................................. 10-33 Create Accounting........................................................................................................... 10-34 Create Periodic Capital Events.........................................................................................10-37 Generate Allocations Transactions................................................................................... 10-38 Delete Allocations Transactions....................................................................................... 10-39 Generate Asset Lines........................................................................................................ 10-40 Generate Capitalized Interest Transactions..................................................................... 10-45 Generate Cost Accounting Events....................................................................................10-45 Generate Cross Charge Accounting Events..................................................................... 10-48 Generate Draft Invoices................................................................................................... 10-49 Generate Financial Plan Amounts................................................................................... 10-53 Delete Unreleased Invoices for a Range of Projects......................................................... 10-53 Generate Draft Revenue................................................................................................... 10-55 Delete Draft Revenue of a Single Project.......................................................................... 10-58 Generate Revenue Accounting Events............................................................................. 10-59

x

Generate Intercompany Invoices..................................................................................... 10-60 Release Allocations Transactions..................................................................................... 10-62 Generate Assets Automatically for a Range of Projects................................................... 10-63 Place Assets in Service - API............................................................................................ 10-64 Organization Forecasting Processes...................................................................................... 10-65 Calculate Forecast Amounts (Incremental)...................................................................... 10-66 Calculate Forecast Amounts (Initial)................................................................................10-66 Generate Organization Forecasts..................................................................................... 10-67 Update Forecast Amounts............................................................................................... 10-68 Interface Processes................................................................................................................. 10-68 Interface Assets ............................................................................................................... 10-69 Interface Expense Reports from Payables ....................................................................... 10-70 Interface Intercompany Invoices to Receivables ............................................................. 10-71 Interface Invoices to Receivables ..................................................................................... 10-72 Interface Supplier Costs................................................................................................... 10-74 Transfer Journal Entries to GL......................................................................................... 10-76 Project Resource Management Processes............................................................................. 10-78 Automated Candidate Search.......................................................................................... 10-79 Generate Calendar Schedules.......................................................................................... 10-79 Process Forecast Exceptions ............................................................................................ 10-80 Perform Action Rules....................................................................................................... 10-80 Rebuild Timeline.............................................................................................................. 10-80 Refresh Resource Availability.......................................................................................... 10-81 Burden Processes................................................................................................................... 10-81 Add New Organization Compiled Burden Multipliers................................................... 10-81 Compile All Burden Schedule Revisions......................................................................... 10-82 Summarization and Update Processes.................................................................................. 10-82 Adjust Expenditure Items................................................................................................ 10-83 Compute Forecast Labor Revenue................................................................................... 10-85 Copy Actual Amounts..................................................................................................... 10-86 Manage Project Requests and Maintain Projects.............................................................. 10-86 Maintain Budgetary Control Balances............................................................................. 10-88 Process Mass Update Batches ......................................................................................... 10-89 Process Structure Updates .............................................................................................. 10-89 Process Project Structure Updates................................................................................... 10-90 Refresh Project Summary Amounts................................................................................. 10-91 Refresh Resource Breakdown Structure Element Names.................................................10-92 Refresh Transaction Summary Amounts......................................................................... 10-92 Revaluate Funding for a Single Project............................................................................ 10-93 Revaluate Funding for a Range of Projects ..................................................................... 10-94 Delete Revaluated Funding for a Range of Projects......................................................... 10-96

xi

Summarize Unbilled Receivables / Unearned Revenue Balances.................................... 10-96 Update Project Summary Amounts .............................................................................. 10-103 Upload Financial Plan Data from Microsoft Excel......................................................... 10-104 Year End Budget Rollover ............................................................................................. 10-105 Tieback Processes................................................................................................................ 10-107 Tieback Asset Lines from Oracle Assets........................................................................ 10-107 Tieback Invoices from Receivables.................................................................................10-108 Transaction Import Process................................................................................................. 10-108 Transaction Import........................................................................................................ 10-108 Administrative Processes.................................................................................................... 10-110 Add Task Managers as Project Members on a Range of Projects................................... 10-111 Archiving and Purging Processes ................................................................................. 10-112 Create Invoice Organization Transaction Types Process............................................... 10-115 Maintain Project Resources............................................................................................ 10-116 Optimize the Project Search Intermedia Index .............................................................. 10-119 Rebuild the Project Search Intermedia Index ................................................................ 10-119 Release Pay When Paid Holds....................................................................................... 10-120 Streamline Rollup for Financial Plan and Workplan Versions.......................................10-121 Sweep Transaction Accounting Events.......................................................................... 10-122 Upgrade Bill Rate Schedules in Projects.........................................................................10-126 Upgrade Budget Types and Budget Versions................................................................ 10-126 Update Project Access Level ......................................................................................... 10-131 Upgrade Resource Lists to Planning Resource Lists...................................................... 10-131 Upgrade Transaction Attributes.................................................................................... 10-132 Performance and Exceptions Reporting Programs............................................................. 10-134 Project Performance Reporting Setup Audit Report...................................................... 10-139 Load Project and Resource Base Summaries.................................................................. 10-140 Load Project Performance Data......................................................................................10-141 Update Project and Resource Base Summaries.............................................................. 10-142 Update Project Performance Data.................................................................................. 10-143 Refresh Project and Resource Base Summaries.............................................................. 10-144 Refresh Project Performance Data..................................................................................10-145 Delete Project Intelligence and Performance Reporting Data........................................ 10-147 Delete Project Performance Reporting Data...................................................................10-148 Process Resource Breakdown Structure Updates...........................................................10-150 Load Project Reporting Base Summaries and Performance Data...................................10-150 Update Project Reporting Base Summaries and Performance Data............................... 10-151 Refresh Project Reporting Base Summaries and Performance Data...............................10-152 Launch Update Project Performance............................................................................. 10-153 Delete Historical Workplans and Financial Plans.......................................................... 10-154 Generate Performance Scores and Notifications............................................................ 10-155

xii

Generate and Distribute Reporting Pack....................................................................... 10-156 Utilization Reporting Programs.......................................................................................... 10-157 Project Deliverable Processes............................................................................................. 10-160 Initiate Project Deliverable Actions................................................................................ 10-160 Relieve Project Deliverable Demand.............................................................................. 10-161

11

Reports and ListingsOracle Applications Common Report Parameters................................................................. 11-2 Oracle Projects Common Report Parameters..................................................................... 11-2 Common Report Headings................................................................................................ 11-4 Submitting Reports and Listings............................................................................................ 11-4 Submitting Requests............................................................................................................... 11-5 Cancelling Requests................................................................................................................ 11-5 Monitoring Requests............................................................................................................... 11-5 Debug Mode............................................................................................................................ 11-6 Implementation Listings......................................................................................................... 11-6 Agreement Types Listing .................................................................................................. 11-7 AutoAccounting Functions Listing ................................................................................... 11-7 AutoAccounting Lookup Sets Listing ............................................................................... 11-8 AutoAccounting Rule Definitions Listing ......................................................................... 11-8 AutoAccounting Segment Rule Pairings Listing ...............................................................11-8 Class Categories and Codes Listing .................................................................................. 11-8 Credit Types Listing .......................................................................................................... 11-9 Employee Assignment Listing and Employee Assignments by Organization Listing ...... 11-9 Event Types Listing ...........................................................................................................11-9 Expenditure Cost Rates Listing ......................................................................................... 11-9 Expenditure Types Listing ................................................................................................ 11-9 Implementation Options Listing ..................................................................................... 11-10 Invoice Formats Listing ................................................................................................... 11-10 Job Listing ....................................................................................................................... 11-10 Labor Cost Multipliers Listing ........................................................................................ 11-10 Labor Cost Rates Listing and Labor Cost Rates Listing By Organization ....................... 11-10 Labor Costing Rules Listing ............................................................................................ 11-11 Non-Labor Resources by Organization Listing ............................................................... 11-11 Organization Hierarchy Listing ...................................................................................... 11-11 Organization Listing ....................................................................................................... 11-12 Project Contact Types Listing ..........................................................................................11-12 Project Customer Relationships Listing .......................................................................... 11-12 Project Roles Listing ........................................................................................................ 11-12 Project Statuses Listing ................................................................................................... 11-12

xiii

Project Types Listing ....................................................................................................... 11-13 Projects Lookups.............................................................................................................. 11-13 Projects Periods................................................................................................................ 11-13 Revenue Categories Listing .............................................................................................11-13 Service Types Listing ...................................................................................................... 11-14 Standard Rate Schedules Listing ..................................................................................... 11-14 Transaction Sources Listing ............................................................................................ 11-14 Units Definition Listing ...................................................................................................11-14 Project Entry Reports............................................................................................................. 11-14 Project Configuration ...................................................................................................... 11-15 Task Details ..................................................................................................................... 11-15 Work Breakdown Structure............................................................................................. 11-15 Transaction Entry Reports..................................................................................................... 11-15 Expenditure Batch Status................................................................................................. 11-16 Expense Report Entry...................................................................................................... 11-16 Missing Timecards .......................................................................................................... 11-17 Pre-Approved Expenditures Entry Audit ....................................................................... 11-17 Timecard Entry Report.......................................................................................................... 11-18 Project Expenditures Reports................................................................................................ 11-18 Capital Project Summary Report..................................................................................... 11-19 Expenditures Detail Report ............................................................................................. 11-20 Expenditures Summary Report ....................................................................................... 11-21 Inactive Capital Projects Report....................................................................................... 11-22 Project Asset Details Report............................................................................................. 11-22 Project Expenditure Adjustment Activity ....................................................................... 11-22 Transfer Activity Report ................................................................................................. 11-23 Project Financial Reports...................................................................................................... 11-23 Revenue, Cost, Budgets by Resources (Project Level) ..................................................... 11-24 Task - Revenue, Cost, Budgets by Resources................................................................... 11-25 Revenue, Cost, Budgets by Work Breakdown Structure ................................................. 11-25 Employee Activity Report..................................................................................................... 11-26 Employee Activity by Organization ................................................................................11-26 Billing Review Reports......................................................................................................... 11-27 Invoice Review ................................................................................................................ 11-27 Unbilled Receivables Aging ............................................................................................ 11-28 Agreement Status by Customer ...................................................................................... 11-30 Billing Process Flow Reports................................................................................................ 11-30 Invoice Flow Detail and Invoice Flow Summary ............................................................ 11-31 Potential Revenue Summary ........................................................................................... 11-32 Project Billing Status ....................................................................................................... 11-33 Revenue Flow Detail ....................................................................................................... 11-33

xiv

Interface Audit Reports......................................................................................................... 11-34 Cost Audit Report ........................................................................................................... 11-34 Cross Charge Audit Report.............................................................................................. 11-35 Revenue Audit Report..................................................................................................... 11-36 Interfaced CIP/RWIP Amounts by FA Period ................................................................. 11-37 Revaluated Funding Audit ............................................................................................. 11-37 Supplier Cost Audit Report............................................................................................. 11-38 Supplier Invoice Audit Report......................................................................................... 11-39 Expense Report Audit Report.......................................................................................... 11-40 Project Subledger Audit Reports.......................................................................................... 11-40 Project Subledger Summary............................................................................................. 11-41 Project Subledger Detail by Project.................................................................................. 11-42 Project Subledger Detail by Expenditure Type................................................................ 11-42 Period Close Exception Reports............................................................................................ 11-42 Transaction Exception Details ......................................................................................... 11-43 Transaction Exception Summary..................................................................................... 11-45 Summarization Period Exceptions................................................................................... 11-46 Organization Forecast Exception Report.............................................................................. 11-46 Discoverer Workbooks.......................................................................................................... 11-47 Staffing Business Area..................................................................................................... 11-48 Financial Business Area................................................................................................... 11-68 Competence Business Area.............................................................................................. 11-72 Utilization Business Area Folders.................................................................................... 11-79 Business Views............................................................................................................... 11-112 Security Overview................................................................................................... 11-115 Discoverer Workbooks in Oracle Projects...................................................................... 11-115 Required Project Hours (PAREQPRJ)...................................................................... 11-117 Required Project Hours by GL Period...............................................................11-117 Required Project Hours by PA Period...............................................................11-118 Required Project Hours by Global Week.......................................................... 11-120 Scheduled Resource Hours (PASCHRES)............................................................... 11-121 Scheduled Resource Hours by GL Period......................................................... 11-122 Scheduled Resource Hours by PA Period......................................................... 11-124 Scheduled Resource Hours by Global Week..................................................... 11-126 Available Resource Hours (PAAVLRES).................................................................11-129 Available Resource Hours by GL Period.......................................................... 11-129 Available Resource Hours by PA Period.......................................................... 11-131 Available Resource Hours by Global Week...................................................... 11-133 Overcommitted Resource Hours (PAOVCRES)...................................................... 11-135 Overcommitted Resource Hours by GL Period................................................ 11-135 Overcommitted Resource Hours by PA Period................................................ 11-138

xv

Overcommitted Resource Hours by Global Week............................................ 11-140 Project Pipeline Workbook (PASALPIP)................................................................. 11-142 Project Pipeline by Fiscal Year.......................................................................... 11-143 Project Pipeline by Fiscal Quarter..................................................................... 11-145 Project Pipeline by GL Period........................................................................... 11-146 Project Pipeline by PA Period........................................................................... 11-148 Organization Competence Summary Workbook (PA_PRM_ORG_COMP_SUM).. 11-150 Organization Competence Summary Worksheet..............................................11-150 Resource Listing for Organization and Competence Worksheet...................... 11-152 Resource Competencies Workbook (PA_PRM_RES_COMP).................................. 11-153 Organization Resource Competencies.............................................................. 11-153 Project Resource Competencies........................................................................ 11-155 Resource Competence Details........................................................................... 11-156 Team Role Details Workbook (PA_PRM_TEAM_ROLE_DETAILS)....................... 11-158 Requirement Details..........................................................................................11-158 Assignment Details........................................................................................... 11-162 Utilization by Organization Workbook (PJIORGUT).............................................. 11-166 Summary Worksheet........................................................................................ 11-166 By Utilization Category and Work Type Worksheet.........................................11-168 Summary Trend Worksheet.............................................................................. 11-169 Utilization by Resources Workbook (PJIRESUT).....................................................11-171 Summary Worksheet........................................................................................ 11-171 By Utilization Category and Work Type Worksheet.........................................11-173 Summary Trend Worksheet.............................................................................. 11-175 Utilization by Resource Managers Workbook (PJIMGRRUT)................................. 11-177 Summary Worksheet........................................................................................ 11-177 By Utilization Category and Work Type Worksheet.........................................11-179 Summary Trend Worksheet.............................................................................. 11-180 Discoverer Query Tips................................................................................................... 11-182

12

Integration with Other Oracle ApplicationsSystem Integration.................................................................................................................. 12-1 Integrating with Oracle Subledger Accounting..................................................................... 12-9 Accounting Event Model Overview.................................................................................12-10 Understanding the Expenditures Accounting Event Entity...................................... 12-11 Understanding the Revenue Accounting Event Entity..............................................12-17 Understanding the Budgets Accounting Event Entity...............................................12-19 Understanding Accounting Events for Burden Encumbrances in Oracle Purchasing and Oracle Payables......................................................................................................... 12-24 Sweeping Transaction Accounting Events................................................................ 12-27

xvi

Understanding Subledger Accounting Setup for Oracle Projects.................................... 12-27 Subledger Accounting Concurrent Programs.................................................................. 12-31 Reporting......................................................................................................................... 12-31 Integrating with the Budget Execution Module of Oracle Federal Financials ................... 12-33 Integrating with Oracle General Ledger............................................................................... 12-33 Implementing General Ledger ........................................................................................ 12-34 Data that Oracle Projects Predefines................................................................................ 12-35 Transferring Costs and Revenue to General Ledger ....................................................... 12-36 Journal Import................................................................................................................. 12-37 Posting in Oracle General Ledger.................................................................................... 12-38 Tie Back Costs and Revenue............................................................................................ 12-38 Opening and Closing Periods ......................................................................................... 12-38 Reporting......................................................................................................................... 12-39 Other Journal Entry Issues............................................................................................... 12-39 Integrating with Oracle Project Contracts............................................................................ 12-40 Overview of Oracle Project Contracts Integration........................................................... 12-40 Integrating with Oracle Human Resources.......................................................................... 12-41 Adding an Employee....................................................................................................... 12-42 Changing an Employee's Name....................................................................................... 12-42 Terminating an Employee................................................................................................ 12-43 Integrating with Oracle Cash Management......................................................................... 12-43 Integrating with Oracle Sales................................................................................................12-44 Understanding Opportunity to Project Integration......................................................... 12-45 Using Opportunity to Project Integration........................................................................ 12-47 Viewing Workflow Notifications..................................................................................... 12-49 Integrating with Oracle Product Lifecycle Management..................................................... 12-49

13

Security in Oracle ProjectsSecurity In Oracle Projects...................................................................................................... 13-1 Understanding Oracle Projects Security............................................................................ 13-1 Multiple Organization Access Control...............................................................................13-3 Responsibility-Based Security............................................................................................ 13-4 Project Security.................................................................................................................. 13-5 Organization Security........................................................................................................ 13-9 Demonstrating a Security Check...................................................................................... 13-10 Public APIs....................................................................................................................... 13-13

14

Global Project SupportProviding Data Access Across Business Groups.................................................................... 14-1 Organization Hierarchies Overview.................................................................................. 14-2

xvii

Jobs Overview.................................................................................................................... 14-2 Business Group Access...................................................................................................... 14-3 Using Global Organization Hierarchies............................................................................. 14-7 Job Groups and Global Jobs............................................................................................... 14-9 Using Job Groups in Oracle Projects..........................................................................14-12 Defining Global Security Profiles........................................................................................ 14-12 Multi-Currency Support........................................................................................................14-13 When Currency Amounts Are Calculated....................................................................... 14-13 Converting Multiple Currencies........................................................................................... 14-15 Currency Models in Oracle Projects..................................................................................... 14-20 Reporting Currencies............................................................................................................ 14-27 Multilingual Support............................................................................................................ 14-28

15

Accounting Periods and Dates for Transaction ProcessingAccounting Transactions ........................................................................................................ 15-1 Accounting Transactions for Cost...................................................................................... 15-2 Accounting Transactions for Cost Accrual.........................................................................15-3 Date Processing in Oracle Projects......................................................................................... 15-3 Overview of Dates in Oracle Projects................................................................................. 15-3 Determining Dates............................................................................................................. 15-5 Financial Periods and Date Processing for Financial Accounting......................................... 15-8 Period-End Date Accounting............................................................................................. 15-9 Expenditure Item Date Accounting................................................................................. 15-12 Expenditure Item Date Accounting with Common Accounting Periods......................... 15-15 Examples of Accounting Date Derivation........................................................................ 15-18 When Accounting Dates Are Derived..............................................................................15-21 Setting Up Expenditure Item Date Accounting.................................................................... 15-22

A

Predefined Setup for Oracle Subledger AccountingData that Oracle Projects Predefines for Oracle Subledger Accounting................................. A-1 Applications........................................................................................................................ A-2 Event Entities....................................................................................................................... A-3 Event Classes and Event Types........................................................................................... A-4 Process Categories............................................................................................................... A-8 Accounting Event Class Options......................................................................................... A-9 Sources, Source Assignments, and Accounting Attribute Assignments............................ A-12 Journal Line Types............................................................................................................. A-13 Account Derivation Rules.................................................................................................. A-25 Journal Lines Definitions................................................................................................... A-26 Application Accounting Definitions.................................................................................. A-31

xviii

Subledger Accounting Methods........................................................................................ A-32 Post-Accounting Programs that Oracle Projects Defines....................................................... A-33

B

Menu PathsOracle Projects Navigation Paths............................................................................................. B-1

Glossary Index

xix

Send Us Your CommentsOracle Projects Fundamentals, Release 12.1Part No. E13581-04

Oracle welcomes customers' comments and suggestions on the quality and usefulness of this document. Your feedback is important, and helps us to best meet your needs as a user of our products. For example: Are the implementation steps correct and complete? Did you understand the context of the procedures? Did you find any errors in the information? Does the structure of the information help you with your tasks? Do you need different information or graphics? If so, where, and in what format? Are the examples correct? Do you need more examples?

If you find any errors or have any other suggestions for improvement, then please tell us your name, the name of the company who has licensed our products, the title and part number of the documentation and the chapter, section, and page number (if available). Note: Before sending us your comments, you might like to check that you have the latest version of the document and if any concerns are already addressed. To do this, access the new Oracle E-Business Suite Release Online Documentation CD available on My Oracle Support and www.oracle.com. It contains the most current Documentation Library plus all documents revised or released recently. Send your comments to us using the electronic mail address: appsdoc_us@oracle.com Please give your name, address, electronic mail address, and telephone number (optional). If you need assistance with Oracle software, then please contact your support representative or Oracle Support Services. If you require training or instruction in using Oracle software, then please contact your Oracle local office and inquire about our Oracle University offerings. A list of Oracle offices is available on our Web site at www.oracle.com.

xxi

Preface

Intended AudienceWelcome to Release 12.1 of the Oracle Projects Fundamentals. This guide assumes you have a working knowledge of the following: The principles and customary practices of your business area. Oracle Projects If you have never used Oracle Projects, we suggest you attend one or more of the Oracle Projects training classes available through Oracle University The Oracle Applications graphical user interface. To learn more about the Oracle Applications graphical user interface, read the Oracle Applications User Guide. See Other Information Sources for more information about Oracle Applications product information. See Related Information Sources on page xxvi for more Oracle E-Business Suite product information.

Deaf/Hard of Hearing Access to Oracle Support ServicesTo reach Oracle Support Services, use a telecommunications relay service (TRS) to call Oracle Support at 1.800.223.1711. An Oracle Support Services engineer will handle technical issues and provide customer support according to the Oracle service request process. Information about TRS is available at http://www.fcc.gov/cgb/consumerfacts/trs.html, and a list of phone numbers is available at http://www.fcc.gov/cgb/dro/trsphonebk.html.

xxiii

Documentation AccessibilityOur goal is to make Oracle products, services, and supporting documentation accessible to all users, including users that are disabled. To that end, our documentation includes features that make information available to users of assistive technology. This documentation is available in HTML format, and contains markup to facilitate access by the disabled community. Accessibility standards will continue to evolve over time, and Oracle is actively engaged with other market-leading technology vendors to address technical obstacles so that our documentation can be accessible to all of our customers. For more information, visit the Oracle Accessibility Program Web site at http://www.oracle.com/accessibility/.

Accessibility of Code Examples in DocumentationScreen readers may not always correctly read the code examples in this document. The conventions for writing code require that closing braces should appear on an otherwise empty line; however, some screen readers may not always read a line of text that consists solely of a bracket or brace.

Accessibility of Links to External Web Sites in DocumentationThis documentation may contain links to Web sites of other companies or organizations that Oracle does not own or control. Oracle neither evaluates nor makes any representations regarding the accessibility of these Web sites.

Structure1 Overview of Oracle Projects

This chapter provides a brief overview of the Oracle Projects group of applications, including Oracle Project Costing, Oracle Project Billing, Oracle Project Resource Management, Oracle Project Management, Oracle Project Collaboration, Oracle Daily Business Intelligence for Projects, and Oracle Project Portfolio Analysis.2 Organizations

This chapter discusses three integral aspects of the Oracle Projects application suite: organizations, jobs, and resources. Oracle Projects shares organization, job, and employee information with Oracle Human Resources. If your business does not currently use Oracle Human Resources, you define this data using the Oracle Human Resources windows provided with Oracle Projects. Your implementation of Oracle Human Resources to work with Oracle Projects involves the definition of: Organizations and organization hierarchies Jobs

xxiv

Resource information

The structure of your enterprise determines how you define your organizations, business groups, hierarchies, jobs, and job groups.3 Resources

Resources are the labor, services, materials, equipment, and other items needed to plan, track, complete, and account for project work. In Oracle Projects, you can define and utilize resources to: Plan work Staff projects Estimate budgets and forecasts Assign tasks, issues, and change requests Track and report project costs and categorize revenue Schedule assignments and monitor the project progress Charge labor and expenses to a project containing employees and contingent workers

4 Project Team Definition

This chapter discusses the functionality behind project team definition, including the definition of scheduled and nonscheduled team members and the definition of organization roles, and the definition and management of scheduled team roles.5 Rates

This chapter describes how Oracle Projects determines rates. You can use rates to calculate amounts for costing, billing, and workplan and financial planning.6 Project Definition and Information

This chapter describes how to define projects, project structures, project lifecycles, project attributes, project team and organization roles, and tasks.7 Utilization

This chapter describes the Utilization feature in Oracle Projects.8 Organization Forecasting

This chapter discusses the organization forecasting functionality in Oracle Projects. Organization forecasting is a powerful management planning and reporting tool.9 System Administration and Maintenance

This chapter describes procedures and activities you need to know about to administer data and settings in Oracle Projects.10 Processes

This chapter describes all of the processes you can submit in Oracle Projects.11 Reports and Listings

xxv

This chapter describes each standard report and listing in Oracle Projects.12 Integration with Other Oracle Applications

This chapter describes how to integrate Oracle Projects with other Oracle Applications.13 Security in Oracle Projects

This chapter discusses the various security structures used by Oracle Projects: project security, responsibilitybased security, and organizational security.14 Global Project Support

This chapter discusses functionality within Oracle Projects supporting operation of global enterprise, including support for multiple organizations, multiple currencies, and multiple languages.15 Accounting Periods and Dates for Transaction Processing

This chapter describes how accounting dates and accounting periods are considered when transactions are processed in Oracle Projects. It also describes the reporting and accounting dates associated with each type of transaction, and how those dates are derived.A Predefined Setup for Oracle Subledger Accounting

This appendix documents the predefined setup that Oracle Projects provides for Oracle Subledger AccountingB Menu Paths

This appendix describes the default navigation paths for each window on the Oracle Projects menu.Glossary

Related Information SourcesYou can choose from many sources of information, including online documentation, training, and support services, to increase your knowledge and understanding of Oracle Projects.

Integration RepositoryThe Oracle Integration Repository is a compilation of information about the service endpoints exposed by the Oracle E-Business Suite of applications. It provides a complete catalog of Oracle E-Business Suite's business service interfaces. The tool lets users easily discover and deploy the appropriate business service interface for integration with any system, application, or business partner. The Oracle Integration Repository is shipped as part of the E-Business Suite. As your instance is patched, the repository is automatically updated with content appropriate for the precise revisions of interfaces in your environment.

Online DocumentationAll Oracle E-Business Suite documentation is available online (HTML or PDF).

xxvi

PDF - See the Oracle E-Business Suite Documentation Library for current PDF documentation for your product with each release. The Oracle E-Business Suite Documentation Library is also available on My Oracle Support and is updated frequently. Online Help - Online help patches (HTML) are available on My Oracle Support. Release Notes - For information about changes in this release, including new features, known issues, and other details, see the release notes for the relevant product, available on My Oracle Support. Oracle Electronic Technical Reference Manual - The Oracle Electronic Technical Reference Manual (eTRM) contains database diagrams and a detailed description of database tables, forms, reports, and programs for each Oracle E-Business Suite product. This information helps you convert data from your existing applications and integrate Oracle E-Business Suite data with non-Oracle applications, and write custom reports for Oracle E-Business Suite products. The Oracle eTRM is available on My Oracle Support.

Guides Related to All ProductsOracle E-Business Suite User's GuideThis guide explains how to enter data, query, run reports, and navigate using the graphical user interface (GUI) available with this release of Oracle Projects (and any other Oracle E-Business Suite products). This guide also includes information on setting user profiles, as well as running and reviewing reports and concurrent programs. You can access this user's guide online by choosing "Getting Started with Oracle Applications" from any Oracle Applications help file.

Oracle Projects Documentation SetOracle Projects Implementation GuideUse this guide to implement Oracle Projects. This guide also includes appendixes covering function security, menus and responsibilities, and profile options.

Oracle Project Costing User GuideUse this guide to learn detailed information about Oracle Project Costing. Oracle Project Costing provides the tools for processing project expenditures, including calculating their cost to each project and determining the General Ledger accounts to which the costs are posted.

xxvii

Oracle Project Billing User GuideThis guide shows you how to use Oracle Project Billing to define revenue and invoicing rules for your projects, generate revenue, create invoices, and integrate with other Oracle Applications to process revenue and invoices, process client invoicing, and measure the profitability of your contract projects.

Oracle Project Management User GuideThis guide shows you how to use Oracle Project Management to manage projects through their lifecycle - from planning, through execution, to completion.

Oracle Project Portfolio Analysis User GuideThis guide contains the information you need to understand and use Oracle Project Portfolio Analysis. It includes information about project portfolios, planning cycles, and metrics for ranking and selecting projects for a project portfolio.

Oracle Project Resource Management User GuideThis guide provides you with information on how to use Oracle Project Resource Management. It includes information about staffing, scheduling, and reporting on project resources.

User Guide