Oracle® Cloud Setting Up Project Financial Management: Quick Start
Oracle® Cloud Setting Up Project Financial Management: Quick Start
Oracle® Cloud Setting Up Project Financial Management: Quick Start
February 2013
Contents
1 Welcome to Oracle Fusion Project Financial Management Cloud Service
Oracle Fusion Project Financial Management Cloud Service: Overview ...........................1-1
Manage Application Implementation: Overview ..............................................................1-2
Project Management Offering: Overview ......................................................................... 1-3
Define Common Applications Configuration for Project Financial Management:
Overview ...............................................................................................................................1-4
Define Common Project Configuration: Overview ........................................................... 1-5
.................................................................................. 6-1
Preface
This Preface introduces the guides, online help, and other information sources
available to help you more effectively use Oracle Fusion Applications.
You can add custom help files to replace or supplement the provided content.
Each release update includes new help content to ensure you have access to the
latest information. Patching does not affect your custom help content.
User Guides address the tasks in one or more business processes. They are
intended for users who perform these tasks, and managers looking for an
overview of the business processes. They are organized by the business
process activities and tasks.
Concept Guides explain the key concepts and decisions for a specific
area of functionality. They are intended for decision makers, such as chief
financial officers, financial analysts, and implementation consultants. They
are organized by the logical flow of features and functions.
Intended Audience
Purpose
All users
Implementors
Implementors
Technical Guides
System administrators,
application developers,
and technical members of
implementation teams
For guides that are not available from the Guides menu, go to Oracle Technology
Network at http://www.oracle.com/technetwork/indexes/documentation.
Note
The content of Oracle Enterprise Repository reflects the latest release of Oracle
Fusion Applications.
Documentation Accessibility
For information about Oracle's commitment to accessibility, visit the Oracle
Accessibility Program website at http://www.oracle.com/us/corporate/
accessibility/index.html.
1
Welcome to Oracle Fusion Project
Financial Management Cloud Service
Oracle Fusion Project Financial Management Cloud Service:
Overview
Oracle Fusion Project Financial Management Cloud Service enables you to plan,
organize, and manage activities, resources, cost, billing, and revenue to bring
about the successful completion of specific project goals and objectives.
Description
Description
Description
Define Project Performance Reporting Configuration Configure Oracle Fusion Project Performance
Reporting to collect and review project data against
defined performance areas.
Define Project Templates
Warning
The Oracle Fusion Project Financial Management Cloud Service does not
support integration with Primavera P6 Enterprise Project Portfolio Management
using Oracle Fusion Project Integration Gateway.
Also, client extensions are not available if you use the Oracle Cloud.
Description
Description
2
Configure the Oracle Fusion Project
Foundation Application
Define Project Foundation Configuration: Overview
Setup tasks for Oracle Fusion Project Foundation are grouped into the following
task lists.
Task or Task List Name
Description
Define Burdening
This chapter provides detailed setup steps for the following required tasks:
Manage Expenditure Types
Manage Nonlabor Resources
Manage Rate Schedules
Manage Planning and Billing Resource Breakdown Structures
Manage Project Types
Decision
Expenditure Category
Revenue Category
Unit of Measure
Rate Required
Proceeds of Sale
7. Select a date from which the expenditure type is available for use.
Optionally, select a date to which the expenditure type is available.
2. Enter a date from which the expenditure type class is associated with the
expenditure type. Optionally, specify a date to which the expenditure type
class is associated with the expenditure type.
3. Repeat the process for each expenditure type class that you want to
associate with the expenditure type.
Assign Sets
Use the Assigned Sets region to assign the expenditure type to one or more
reference data sets so that only expenditure types that are relevant to the project
unit are available for the project.
To assign sets:
1. Click the Add Row button in the Assigned Sets region.
You can only select an expenditure type of Usage expenditure type class.
7. If you are creating a resource, such as a training room, whose capacity is
consumed, then select the Equipment Resource Class check box.
Restriction
To indicate that the resource is equipment, the expenditure type you selected
must use a UOM in Hours.
8. Enter a From Date to indicate the date from which the nonlabor resource
is available for use. Optionally, specify a To Date.
9. Specify the organizations to which a nonlabor resource is assigned. Click
the Add Row button in the Nonlabor Resource Organizations region.
Tip
You can assign nonlabor resources to any organization from the organization
hierarchy, regardless of whether the organization has the Project Expenditure
Organization classification, and regardless of the start and end dates for the
organization.
10. In the Name field, select an organization.
11. Enter a From Date to indicate the date from which the nonlabor resource
is assigned to the organization. Optionally, specify a To Date.
12. Repeat the process for each organization to which the nonlabor resource is
assigned.
Restriction
You cannot assign a nonlabor resource to an organization multiple times, even
for different date ranges.
13. Click the Save button.
Use the Manage Rate Schedules page to create, delete, and maintain rate
schedules.
4. Click the Add Row button to create a rate schedule.
5. Enter a unique name, and optionally, a description for the rate schedule.
6. Select a Project Rates Set.
7. Select a Schedule Type depending on whether you want to create a rate
schedule for jobs, persons, nonlabor resources, or resource classes.
8. Select the Currency in which you plan to enter rates.
4. Select the Rate Required check box if you want to enter a rate or a
markup percentage for the expenditure type. If you do not select this
option, you must provide a markup percentage.
5. Enter either a Rate or a Markup Percentage that is used to calculate
amounts for the resource.
6. Enter a From Date to indicate the date from which the rate is available for
use. Optionally, select a To Date.
7. Repeat this process for each expenditure type or expenditure type,
nonlabor resource, and nonlabor resource organization for which you
want to enter rates.
8. Click the Save button.
1. In the Job Rates region, select a Job Set as a source for the jobs you are
entering rates for.
2. Click the Add Row button.
3. Select the Job for which you are entering rates. Note that the Unit of
Measure is always Hours.
4. Enter a rate for the job.
5. Enter a From Date to indicate the date from which the rate is available for
use. Optionally, select a To Date.
6. Repeat this process for each job for which you want to enter rates.
7. Click the Save button.
1. Click the Add Row button in the Resource Class Rates region.
2. Select the resource class for which you are entering rates.
3. Depending on the detail at which you want to enter rates, optionally
select an Organization.
4. Enter either a rate or a markup percentage.
5. Enter a From Date to indicate the date from which the rate is available for
use. Optionally, select a To Date.
6. Repeat this process for each resource class, or resource class and
organization combination for which you want to enter rates.
7. Click the Save button.
Important
A default planning resource breakdown structure with planning resources
for the four resource classes (Labor, Equipment, Material Items, and Financial
Resources) is created automatically for each project unit.
When you create a project template, it is selected as the primary planning
resource breakdown structure. You can designate another planning resource
breakdown structure as primary if required. However, you cannot remove the
default planning resource breakdown structure from the project or template.
As illustrated in the following diagram, setting up planning resource breakdown
structures is a three-step guided process.
Click the Expand icon to expand the resource format hierarchy. You must select
lower levels of a hierarchy individually even if you have selected a format at a
higher level.
3. Click the Save button.
5. Enter a project type name and select a date from which the project type
is available for use. Optionally, select a date to which the project type is
available for use and enter a description.
6. Select the Set to which the project type is assigned.
Important
Project managers can use this project type only on project templates and projects
created in business units associated with the set you select here. For additional
information about set assignments, see also the Create Financial Plan Types
section of this document.
7. Select a Work Type.
Create work types on the Manage Work Types page. Work types classify
actual and scheduled work. Use work types to determine whether
expenditure items are billable, classify cross-charge amounts into cost and
revenue for cross-charge work, and calculate transfer price amounts.
8. To record burden costs on projects, select the Enable burdening check
box.
9. To bill customers for project work, select the Enable billing check box.
10. To assign assets to projects, select the Enable capitalization check box.
2. Select the Default Cost Burden Schedule for projects that are defined
with this project type. Project managers can change this value at the
project or task level.
3. Select the Allow cost burden schedule change for projects and tasks
check box to allow a change of the default cost burden schedule when
creating and maintaining projects and tasks. Do not enable this option
if you want all projects of a project type to use the same schedule for
internal costing.
4. Make the following decisions for burden cost accounting.
Option Name
Decision
Option Name
Decision
Cost Type
3. If you are not grouping supplier invoices, select one of the following radio
buttons in the Supplier Invoices region.
As new additions: Sends each expenditure item on a supplier invoice
line to Oracle Fusion Assets as a separate addition line with a status of
New.
As merged additions: Sends each supplier invoice line to Oracle Fusion
Assets as a separate addition line with the status of Merged.
Select Classifications
Assign project classifications to group your projects according to categories and
codes that you define on the Manage Class Categories page.
1. Navigate to the Classifications tab.
2. Click the Add Row button.
3. Select a Class Category.
4. Select the Assign to all projects check box to automatically add the
classification to the project definition for all new projects using this project
type.
5. Repeat the process for each class category you want to add to the project
type.
6. Click the Save button.
3
Configure the Oracle Fusion Project
Costing Application
Define Project Costing Configuration: Overview
Setup tasks for Oracle Fusion Project Costing are grouped into the following task
lists.
Task List Name
Description
Define Allocations
This chapter provides detailed setup steps for defining an additional segment for
the cost collection flexfield.
Configure the Oracle Fusion Project Costing Application 3-1
7. Select the PJC: All context and view the context sensitive segments.
8. Select a user-defined attribute row to define the context sensitive segment.
9. Click the Edit button.
Use the Edit Segment page to specify the segment name, and define how
it must be displayed and validated.
10. Specify a Name for the flexfield.
11. Optionally specify a Description.
12. Select the Enabled check box to enable this segment.
13. Depending on how the segment must display, for example as a dropdown list, associate an existing value set or create a value set for Oracle
Fusion Project Costing and associate the value set to the segment.
14. In the Validation region select a value set. You can also view the value set.
15. Optionally make this a Required field.
16. In the Initial Default region, specify the format of the initial value that
populates the segment, and the entity attribute from which the segment
can be continually updated.
17. In the Display Properties region, enter a Short Prompt which appears as
alternate text for the flexfield.
18. Enter a Prompt which appears as the field label.
19. The Display Type field specifies how the segment must be displayed. For
example, you can specify the expense locations in a drop-down list.
20. Select a Display Type such as Checkbox, List of Values, or Text Area.
21. On the Edit Segment page, click the Save and Close button.
22. On the Edit Context page, note the created segment name so you can
identify it in the transactional pages.
23. Repeat steps 7 through 23 for every additional context in which the new
segment must appear.
24. Once you finish defining all the flexfields you require, click the Save and
Close button.
25. You must deploy the Cost Collection flexfield from the Manage Project
Standard Cost Collection Flexfield page to make it available for users
while entering transactions.
26. You can now verify the segment you defined using the Cost Collection
flexfield by creating a transaction from the either Manage Unprocessed
Transactions page or Cost Transaction Excel Spreadsheets.
4
Configure the Oracle Fusion Project
Control Application
Define Project Control Configuration: Overview
Setup tasks for Oracle Fusion Project Control include the following.
Task Name
Description
This chapter provides detailed setup steps for the following required tasks:
Manage Financial Plan Types
Manage Project Plan Types
requirements, you can create separate financial plan types for each planning
scenario. Alternatively, you may create only a few financial plan types, for
example, for approved budgets and primary forecasts.
Use the Manage Financial Plan Types page to create financial plan types
and to review, edit, or delete existing financial plan types.
4. Click the Create button to open the Create Financial Plan Type page.
Use the Create Financial Plan Type page to enter basic financial plan
type information, and setup and planning options that determine how
associated financial plan versions are created.
5. Enter a unique financial plan type name and select a date from which the
financial plan type is available for use.
6. Optionally, provide a description and a date to which the financial plan
type is available for use.
7. Use the Plan Class list to determine whether project managers will use
the financial plan type to create budget versions or forecast versions.
8. Use the Planning Amounts list to determine whether associated financial
plan versions will contain costs amounts, revenue amounts, or both.
If you want to create a financial plan type to plan for both cost and
revenue, indicate whether one version will contain both amounts, or if
project managers must select to include either cost or revenue amounts
when creating a budget or forecast version.
9. Select setup options depending on whether you are creating a financial
plan type of the Budget or Forecast plan class.
If you are creating a financial plan type of the Budget plan class, make the
following decisions:
Option Name
Decision
Notes
Designate as approved
cost budget
Designate as approved
revenue budget
Enable planning in
multiple transaction
currencies
If you are creating a financial plan type of the Forecast plan class, make
parallel decisions for the following attributes:
Designate as primary cost forecast
Designate as primary revenue forecast
Use workflow for status changes
Set as default financial plan type
You must also make the following decisions.
Option Name
Decision
Notes
Automatically submit
forecasts for approval
Can forecasts be
automatically submitted
for approval?
Automatic submission
for approval applies only
to primary forecasts.
When the project
manager creates the
first baseline version for
the approved budget,
the application creates
the primary forecast
version and submits it for
approval.
Automatically approve
forecasts
Assign Sets
You associate one or more sets with financial or project plan types so that project
managers can use them to create financial plans (budget or forecast versions) for
projects or project templates. Financial plan types are available for selection only
when projects or project templates are created for project units linked to selected
sets.
The following diagram illustrates an example of set assignments. The Consulting
Services set is associated only with the Consulting Services project unit. You
associate the financial plan type Consulting Bid only with the Consulting
Services set. In this case, only project managers who create projects for
Consulting Services can create versions of the Consulting Bid financial plan type.
If you associate the Internal Services Set to the Consulting Bid financial plan
type, then project managers from the Internal Services project unit can also
access that financial plan type.
Tip
To make financial plan types available more widely across your organization,
you can assign them to a common set.
To assign sets:
1. Navigate to the Set Assignments tab.
2. Make the following decisions related to the amount types that are
available for editing on budget and forecast versions and how they are
edited and displayed.
Option Name
Decision
Notes
Amount Types
Planning Level
Calendar Type
Period Profile
2. Click the Add Row button on the Transaction Currencies subtab to add a
transaction currency.
3. Select the desired currency in the Currency field.
4. Repeat the process for each transaction currency that project managers can
use.
5. Click the Save button.
6. Click the Project Currency subtab.
Use the Project Currency subtab to define how the application must
convert transaction currency amounts to project currency. If the financial
plan type supports planning for cost and revenue, you must provide
currency conversion attributes separately for cost and revenue.
6. Repeat the process for each business unit for which you want to select
rates.
7. Click the Save button.
If your generation source is Financial plan type and your source plan
type is a forecast financial plan type, then you can select Current
approved, Original approved, or Current working.
5. If the financial plan type supports planning for revenue, select a Revenue
Generation Method. Options include the following.
Option Name
Description
Manual
6. Select the Retain manually added budget lines check box if plan lines
added by project managers must be retained when an existing version is
generated again.
7. Select the Retain override rates from source check box if override rates
entered in the source plan version must be used to generate amounts in
the new budget version.
8. Click the Save button.
If you are creating a financial plan type of the Forecast plan class, then as
illustrated in the following figure, in addition to the decisions listed for budget
financial plan types, you must also determine the following:
1. Select one of the following options for Forecast ETC Method to determine
how ETC amounts are calculated.
Option Name
Resulting Calculation
Remaining plan
Plan to complete
ETC = Plan - Actual ETC = Plan * (1 Physical Percent Complete from latest
Published Progress)
Manual entry
2. If you are using the Remaining plan ETC method, then select the Carry
forward unused amounts from past periods check box to carry over
unused source plan amounts from periods prior to the actual amounts
through period.
3. Select one of the following options for the Actual Amounts Through
Period field to determine the period through which to obtain actual
amounts when generating forecast amounts:
Current period
Prior period
Decision
Notes
Report Quantity
Report Cost
Amount Scale
Currency Type
Use the Export Options tab to determine the amounts, rates, and quantities that
you can export to Excel. Make the following decisions:
Option Name
Decision
Display commitments
Selected Measures
Use the Manage Project Plan Types page to create project plan types and
to review, edit, or delete existing project plan types.
4. Click the Create button to open the Create Project Plan Type page.
Use the Create Project Plan Type page to provide basic project plan type
information and specify setup and planning options that determine how
associated project plans and progress are created.
5. Enter a unique project plan type name and select a date from which the
project plan type is available for use.
6. Optionally, provide a description and a date to which the project plan
type is available for use.
7. Use the options in the Setup Options region to indicate whether:
Project managers can use Microsoft Project for scheduling.
Project managers can enter amounts in currencies other than the project
currency.
Note
When you select this option, you must provide currency conversion attributes in
the Currency Settings tab.
Option Name
Decision
Notes
Calendar Type
If project managers
will not plan based on
a calendar, determine
whether cost rates are
derived based on the
start or end date of plan
lines or a fixed date.
Fixed Date
Period Profile
2. Decide how planned dates for tasks and task assignments are entered or
calculated.
Option Name
Decision
Restriction
The Use task planned dates as task assignment dates check box and the
Automatically roll up task planned dates check box are disabled if you enable
use of Microsoft Project as the scheduling application.
3. Decide how transaction dates are entered using the following options.
Option Name
Decision
2. Decide how physical percent complete values are calculated and roll up
the task hierarchy.
Option Name
Decision
Notes
Physical Percent
Complete Calculation
Method
Option Name
Decision
Notes
ETC Method
Decision
Decision
5
Configure the Oracle Fusion Project
Billing Application
Define Project Billing Configuration: Overview
Setup for Oracle Fusion Project Billing includes the following task lists and tasks.
Task or Task List Name
Description
This chapter provides detailed setup steps for the following required tasks:
Manage Event Types
Manage Revenue Methods
Manage Invoice Methods
Manage Invoice Formats
Optionally, you can add a tax classification code to an event type. Oracle Fusion
Project Billing calculates the approximate tax amounts for events of this type on
contract invoice lines.
The following section describe how you create event types.
Use the Manage Revenue Methods page to create revenue methods and to
review, edit, or delete revenue methods.
4. Click the Create button to create a revenue method.
5. On the Create Revenue Method page, enter a revenue method name.
6. Specify a status. Select Active to make the revenue method available for
use.
7. Select one of the following revenue method classifications to determine
the basis for calculating revenue amounts for transactions on contracts or
contract lines.
Revenue Method Classification
Description
Amount Based
As Billed
As Incurred
Percent Complete
Percent Spent
Rate Based
Restriction
You can use a revenue method with the As Billed or As Incurred revenue
method classification only when combined with an invoice method that has the
Rate Based invoice method classification. In this situation, the bill rate, burden,
or transfer price schedule type selected for that invoice method is used for both
invoicing and revenue recognition.
8. To enable a revenue method for intercompany billing only, select the
Use Revenue Method for Intercompany Billing check box. Use revenue
methods with this option to track internal business activity between legal
entities within your enterprise. Deselect the check box if the revenue
method is used for billing external parties.
Description
Amount Based
Percent Complete
Percent Spent
Rate Based
Use the Manage Invoice Formats page to create new invoice formats and
to review, edit, or delete existing invoice formats.
4. In the Invoice Format Header region, click the Add Row button.
5. Enter a unique name for the invoice format.
6. Select a Format Type to determine whether the invoice format is used for
labor, nonlabor, or events.
7. Select a date from which the information format is available for use.
Optionally, select a date to which the invoice format is available.
8. Select a grouping option to determine the fields displayed on the invoice
line and how they are grouped.
9. Select the Customer Invoice check box to use an invoice format for
regular contract invoices. Similarly, select the Internal Invoice check box
to use an invoice format for invoices generated by intercompany and
interproject contracts.
Tip
Select both check boxes if you want to use an invoice format for both customer
and internal invoices. However, the list of values for the Field Name field in
the Invoice Format Details region only includes values that are valid for both
options.
10. Select the Fixed Format check box to prohibit distributions from being
moved to other invoices lines.
Restriction
You must select this check box if you select the Internal Invoice check box.
6
Configure the Oracle Fusion Project
Performance Reporting Application
Define Project Performance Reporting Configuration: Overview
Setup tasks for Oracle Fusion Project Performance Reporting include the
following.
Task List or Task Name
Description
This chapter provides detailed setup steps for the task Manage Key Performance
Indicators.
6. Use the Create Key Performance Indicator page to specify KPI details,
trending information, and threshold levels.
7. Provide the following information in the General Information region:
Option Name
Decision
Project Unit
Notes
KPI Name
Measure
Which performance
You are creating a
measure should you use? KPI to calculate the
Inception-to-Date margin
percentage for a project.
Measure Format
None
Populated automatically
by the application based
on the selected measure,
such as percentage,
hours, currency.
Important
The measure format
determines how you
enter threshold values for
the KPI.
KPI Category
Currency Type
Calendar Type
Decision
Notes
Trend Indicator
Tolerance Percentage
Set a tolerance
percentage to define
how much of a change
from the previous KPI
value will be tolerated
before the trend indicator
changes to indicate worse
performance.
For example, you
can specify that the
application can tolerate
up to 1 % deviation for a
decrease in ITD Budget
Margin (%) from the
previous value, before
the trend indicator
changes to depict that
performance of the KPI is
decreasing.
12. Use the Threshold Levels region to specify thresholds to indicate the
health status of a KPI. Select one of the following options:
Multiple threshold levels
Single threshold level value
Single threshold level range
Important
Information you enter in the following sections will vary based on whether the
measure format of the KPI you are creating is percentage, currency, or hours.
This procedure is based on a KPI with a currency measure format.
5. Enter the Threshold Start and Threshold End range relevant to the
possible KPI values in the Edit Threshold Levels dialog box.
6. Select a Status Indicator which must be displayed when the KPI value
falls in the range you specify.
7. Click the Save and Close button.
8. Add as many rows as required to set multiple thresholds with different
currencies for the KPI.
9. Click the Save and Close button in the Create Key Performance Indicator
page.
7
Configure Oracle Fusion Project
Templates
Define Project Templates: Overview
The Define Project Templates task list contains the following task.
Task Name
Description
Decision
Notes
Business Unit
Selecting a business
unit determines which
rate schedules, project
types, and invoice
formats projects can
use. It also determines
the legal entity and
which project and task
owning organizations are
available for projects.
Legal Entity
None
Populates automatically
based on the business
unit you selected.
Change this if required.
Project Unit
Organization
Project Type
Selecting a project
type enables you to
control basic project
configuration options
for burdening, billing,
capitalization, and
project categorization.
Use the the Edit Project Template page to review basic template
information, access project, financial, and reporting options, and select
quick entry fields.
10. In the Edit Project Template page, scroll down to the Quick Entries region.
Use the Quick Entries region to specify the information that users enter
when they create a project using this project template. Quick entry fields
allow users to enter certain project information quickly.
11. Click the Add Row button.
12. Select a value in the Field Name column.
13. If you have selected Classification or Team member as the field name,
then select a value in the Specification column.
Classification: Select the class category to use when creating the
classification.
Team Member: Select the project role to use when creating the team
member.
14. Enter a field label in the Prompt column.
15. Optionally make this a required field.
16. Scroll up to the Setup Options region.
Use the Setup Options region to select which regions, such as basic
information, financial options, and reporting options, are displayed in the
project definition after the project is created.
17. Click the Save button.