17 Oracle Project Billing

Oracle Project Billing enables simple client invoicing, improved cash flow, and measurement of the profitability of contract projects with support for planning, execution, and analysis. It utilizes information from the work breakdown structure and provides flexible revenue accrual and invoice generation features.

This chapter describes the following test flows in Oracle Project Billing:

• Project Revenue and Invoice Generation

Prerequisites

None.

Profile Options

Not applicable.

Predefined Data

Not applicable.

Setup Data

Not applicable.

17.1 Project Revenue and Invoice Generation

Project revenue and invoice generation covers the integration between Project Billing and the other modules within Projects product family, like Project Foundation and Project Costing and also with Financials products like Receivables and E Business Tax.

A contract project is created which gets funded by an agreement. Costs and billing events are recorded on the projects. For these costs and events, project revenue is generated and accounted. Projects invoices are also generated and fully processed by interfacing the same to receivables.

Prerequisites

None.

Profile Options

Table 17-1 Profile Options for Project Revenue and Invoice Generation Flow

Profile Name	Profile Value	Level
Profile Name	Profile Value	Level
PA: Transaction Billability derived from Work Type	Yes	Site
PA: Require Work Type Entry for Expenditures	Yes	Site

Predefined Data

Table 17-2 Predefined Data for Project Revenue and Invoice Generation Flow

Window Name	Field Name	Field Value
Project Implementation Options	Transaction Source	PROJECTS INVOICES-600

Setup Data

Table 17-3 Setup Data for Project Revenue and Invoice Generation Flow

Window Name	Field Name	Field Value	Comments
Project Type	Service Type	Build
	Work Type	Commercial Customer-billable	Billable or capitalizable option should be selected
	Resource List	Expenditure Category
	Rate Schedule	PJCB-EMP-BR-1
	Rate Schedule	PJCB-JOB-BR-1
	Rate Schedule	PJCB-NL-BR-1	Expenditure type Consulting has a markup of 10% defined.
	Billing Cycle	First Day
Project Template	Employee	Marlin, Ms. Amy
	Customer	Hilman and Associates
	Tax Classification Code	PJB_TAX_RATE	Tax Rate of 10% is defined
Agreement	Agreement Type	Purchase Orders
	Payment Terms	30 NET
Pre-Approved Batch	Expenditure Type	Consulting
Billing Events	Event Type	Manual