Oracle Project Costing User Guide

Budget Entry

Entering or Revising a Budget Draft

Entering a Project or Task Level Budget

Entering Budget Lines

Entering Budget Lines for Period-Phased Budgets

Viewing Calculated Budget Amounts

Entering Budget Lines for Non-Time-Phased or Date Range Budgets

Revising Budget Lines

Copying Budgets from a Project Template or Existing Project

Copying Actual Amounts to Budget Amounts

Deleting a Draft

Submitting a Draft

The Submit Draft Budget Process

Creating a Baseline for a Budget Draft

The Draft Budget Baseline Process

Creating a Baseline for an Integrated Budget

Revising a Budget Baseline

Revising an Original Budget

Reviewing a Budget

Reviewing and Overriding Budget Account Details for Integrated Budgets

Troubleshooting Baseline Failures for Integrated Budgets

Using Budgetary Control

Budgetary Control Settings

Entering Budget Amounts for Controlled Budgets

Budget Definition Strategies

Transaction Processing With Controlled Budgets

Viewing Transaction Funds Check Results

Maintaining Budgetary Control Balances

Budgetary Control Cross Charge Restriction

Budgetary Control Result Messages

Integrating Budgets

Using Bottom-Up Budget Integration

Using Top-Down Budget Integration

Top-Down Budget Integration Example

Creating Project Budgets for Top-Down Budget Integration

Transaction Processing

Burden Cost Encumbrance

Same Line Burden Cost Encumbrance Accounting

Separate Line Burden Cost Encumbrance Accounting

Accounting For Burden and Total Burdened Cost Encumbrances in Oracle Subledger Accounting

Budgetary Control Balances

Maintaining the Project Budget

Year-End Processing

Using Top-Down Budget Integration with Oracle Contract Commitments

Oracle Contract Commitments

Integrating with Oracle Contract Commitments

Prerequisites for Budget Integration with Oracle Contract Commitments

Contract Commitment Transaction Example

Project Encumbrance Example

Creating Project Budgets for Top-Down Budget Integration with Oracle Contract Commitments

Budgetary Control Balances

Maintaining the Project Budget

Year-End Processing

Integrating with the Budget Execution Module of Oracle Federal Financials

Expenditures

Overview of Expenditures

Expenditure Classifications

Expenditure Amounts

Expenditure Entry Methods

Expenditure Item Validation

Expenditure Rejection Reasons

Processing Pre-Approved Expenditures

Entering Pre-Approved Expenditure Batches

Entering Expenditures

Entering Currency Fields

Uploading Expenditure Batches from Microsoft Excel

Copying an Expenditure Batch

Verifying Control Totals and Control Counts

Submitting an Expenditure Batch

Reviewing and Releasing Expenditure Batches

Reversing an Expenditure Batch

Correcting Expenditure Batches

Controlling Expenditures

Using Transaction Control Extensions

Inclusive and Exclusive Transaction Controls

Determining if an Item is Chargeable

Determining if an Item is Billable or Capitalizable

Examples of Using Transaction Controls

CASE 1: Limited employees charge limited expenses

CASE 2: Different expenditures charged during different phases of a project

CASE 3: Some tasks, but not all, are only chargeable for labor expenditures

Viewing Expenditures

Viewing Expenditure Items

Reconciling Invoices and Expenditures

Viewing Accounting Lines

Expenditure Items Windows Reference

Find Expenditure Items Window

Expenditure Items Window

Adjusting Expenditures

Audit Reporting for Expenditure Adjustments

Types of Expenditure Item Adjustments

Restrictions for Adjusting Converted Items

Adjusting Expenditure Items

Mass Adjustment of Expenditures

Transferring Expenditure Items

Splitting Expenditure Items

Adjustments to Multi-Currency Transactions

Adjustments to Burden Transactions

Adjustments to Related Transactions

Marking Items for Adjustments

Processing Adjustments

Results of Adjustment Processing

Adjustments to Supplier Costs

Restrictions to Supplier Cost Adjustments

Adjusting Project-Related Documents in Oracle Purchasing and Oracle Payables

Writing Off Receipt Accruals in Oracle Purchasing

Adjusting Supplier Costs for Non-Construction-in-Process Assets

Manually Adjusting Unmatched Reversing Expenditure Items

Processing Adjustments

Prioritizing Supplier Costs Adjustments

Accounting for Supplier Cost Adjustments

Adjusting Labor Costs

Adjusting Transactions after Updating Labor Costing Rule

Reversing Costed Labor Transactions

Processing Timecard Adjustments

Processing Payroll Adjustments

Burdening

Overview of Burdening

Burden Calculation Process

Building Up Costs

Example of Cost Buildup

Using Burden Structures

Burden Structure Components

Using Burden Schedules

Types of Burden Schedules

Defining Burden Schedule Versions

Assigning Burden Multipliers

Assigning Burden Schedules

Defining Burden Schedules for Project Types

Assigning Burden Schedules at the Project and Task Level

Assigning Fixed Dates for Burden Schedules

Changing Default Burden Schedules

Overriding Burden Schedules

Determining Which Burden Schedule to Use

Storing, Accounting, and Viewing Burden Costs

Storing Burden Cost on the Same Expenditure Item

Storing Burden Costs as a Separate Expenditure Item on the Same Project

Storing Burden Cost as Summarized Expenditures on a Separate Project

Choosing a Burden Storage Method

Setting Up The Burden Cost Storage Method

Accounting for Burden Costs

Accounting for Burden Costs by Burden Cost Component

Accounting for Total Burdened Cost

Storing Burden Costs with No Accounting Impact

Troubleshooting Burden Transactions

Processing Transactions After a Burden Schedule Revision

Reporting Burden Components in Custom Reports

Revenue and Billing for Burden Transactions

Reporting Requirements for Project Burdening

GL and Upper Management Reporting

Burden Multiplier Algorithm

Accounting Transactions for Burden Cost Reporting

Burdening Options for General Ledger Accounting and Reporting

Middle Management Reporting

Project Management Reporting

Setting Up Burden Cost Accounting to Fit Reporting Needs

Allocations

Overview of Allocations

Understanding the Difference Between Allocation and Burdening

Creating Allocations

Defining Allocation Rules

Allocating Costs

Releasing Allocation Runs

Viewing Allocation Runs

Viewing Allocation Transactions

Reversing Allocation Runs

Full and Incremental Allocations

About Previous Amounts and Missing Amounts in Allocation Runs

AutoAllocations

Creating AutoAllocations Sets

Submitting an AutoAllocation Set

Viewing the Status of AutoAllocation Sets

Asset Capitalization

Overview of Asset Capitalization

About Capital Projects

Capital Projects Processing Flow

Creating Purchase Orders for Capital Projects

Charging Supplier Invoice Lines to Projects

Charging Expense Reports to Capital Projects

Charging Labor, Usages, and Miscellaneous Transactions to Capital Projects

Placing CIP Assets in Service

Creating Fixed Assets from Capital Projects

Sending Retirement Costs to Oracle Assets

Accounting for Asset Costs in Oracle Projects and Oracle Assets

Defining and Processing Assets

Creating Assets in Oracle Projects

Creating a Capital Asset

Creating a Retirement Adjustment Asset

Capital Project Flow

Specifying Which Capital Asset Transactions To Capitalize

Defining Assets

Copying Assets

Asset Attributes

Placing an Asset in Service

Specifying a Retirement Date for Retirement Adjustment Assets

Creating and Preparing Asset Lines for Oracle Assets

Creating Capital Events

Generating Summary Asset Lines

Allocating Asset Costs

Sending Asset Lines to Oracle Assets

Asset Summary and Detail Grouping Options

Asset Grouping Levels

Specifying Grouping Level Types

Assigning Assets to Grouping Levels

Reviewing and Adjusting Asset Lines

Assigning an Asset to Unassigned Asset Lines

Changing the Asset Assigned to an Asset Line

Splitting an Asset Line

Adjusting Assets After Interface

Adjusting Capital Project Costs

Reversing Capitalization of Assets in Oracle Projects

Reversing Capitalization of an Asset or Event

Recapitalization of Reverse Capitalized Assets

Abandoning a Capital Asset in Oracle Projects

Capitalizing Interest

Overview of Capitalized Interest

Defining Capitalized Interest Rate Names and Rate Schedules

Setting Up Capital Projects for Capitalized Interest

Generating Capitalized Interest Expenditure Batches

Reviewing Capitalized Interest Expenditure Batches

Using the Asset Capitalization Dashboard

Cross Charge

Overview of Cross Charge

Cross Charge Business Needs and Example

Project Structure: Distinct Projects by Provider Organization

Project Structure: Single Project

Project Structure: Primary Project with Subcontracted Projects

Cross Charge Types

Cross Charge Processing Methods and Controls

Cross Charge Processing Methods

Cross Charge Controls

Cross Charge Processing Controls

Transfer Pricing

Processing Flow for Cross Charge

Borrowed and Lent Processing Flow

Intercompany Billing Processing Flow

Creating Cross Charge Transactions

Processing Borrowed and Lent Accounting

Determining Accounts for Borrowed and Lent Transactions

Generating Accounting Transactions for Borrowed and Lent Accounting

Processing Intercompany Billing Accounting

Determining Accounts for Intercompany Billing Accounting

Generating Intercompany Invoices

Approving and Releasing Intercompany Invoices

Interfacing Intercompany Invoices to Receivables

Interfacing Intercompany Invoices to Oracle Payables

Interface Tax Lines from Oracle Payables to Oracle Projects

Adjusting Cross Charge Transactions

Overview of Cross Charge Adjustments

Processing Flow for Cross Charge Adjustments

Integration with Other Oracle Applications

Overview of Oracle Project Costing Integration

Integrating Expense Reports with Oracle Payables and Oracle Internet Expenses

Overview of Expense Report Integration

Setting Up in Payables and Oracle Projects

Processing Expense Reports Created in Oracle Internet Expenses and Oracle Payables

Adjusting Expense Reports

Integrating with Oracle Purchasing and Oracle Payables (Requisitions, Purchase Orders, and Supplier Invoices)

Understanding the Supplier Cost Process Flow

Processing Supplier Costs with Accrual Basis Accounting

Processing Supplier Costs with Cash Basis Accounting

Entering Project-Related Information in Oracle Purchasing and Oracle Payables

Project-Related Information

Oracle Purchasing: Entering Project-Related Information

Oracle Payables: Entering Project-Related Information

Validating Project Information

Accounting Transactions Created by the Account Generator

Managing Supplier Payments

Managing Financing and Advances

Managing Retainage

Payment Control

Interfacing Supplier Costs

Interfacing Costs from Oracle Purchasing and Oracle Payables to Oracle Projects

Reviewing Supplier Costs

Commitment Reporting

Adjusting Project-Related Supplier Costs

Integrating with Oracle Assets

Implementing Oracle Assets

Interfacing Assets to Oracle Assets

Mass Additions

Viewing Capital Project Assets in Oracle Assets

Adjusting Assets

Integrating with Oracle Project Manufacturing

Importing Project Manufacturing Costs

Integrating with Oracle Asset Tracking

Importing Oracle Asset Tracking Cost

Integrating with Oracle Inventory

Entering Project-Related Transactions in Oracle Inventory

Collecting Inventory Costs

Transferring Inventory Costs to Oracle Projects

Importing Inventory Transactions

Reviewing Imported Inventory Transactions

Adjusting Inventory Transactions

Integrating with Oracle Time and Labor

Collecting and Processing Project-Related Timecards

Editing Timecards in Oracle Time & Labor

Integrating with Oracle Payroll

Integrating with Oracle Service

Integrating with Oracle Loans

Index

Oracle Project Costing User Guide

Contents