This guide also applies to on-premise implementations

3Subject Areas

This chapter contains the following:

Data Structure for Analytics: Explained

The BI repository defines which columns (or slices of data) are available for you to include in analyses, and where data for each column comes from. The repository is organized into subject areas which contain folders with columns. You can also use the BI repository as a data source for reports.

Columns

The following table describes the three types of columns.

Column Type Description Example Icon for Column Type

Fact

Provides a measure of values that are numbers.

Credit Amount in Contract Currency

Yellow ruler

Attribute

Represents information about a business object with values that are dates, IDs, or text.

Attribute columns can be flexfield segments imported into the BI repository.

Contract Association Level

Gray paper

Hierarchy

Holds data values that are organized in a hierarchical manner.

Date - Week To Year hierarchy contains:

  • Total

  • Week To Year

  • Week

  • Day Detail

Column: Hierarchy of blue squares

Sublevel: Blue or white square

Subject Areas

To create an analysis:

  1. Select a subject area which contains columns related to a specific business object or business area. For example, Project Billing - Invoices Real Time.

  2. Open folders within the subject area to find the columns to include in your analysis. For example, you can open the Project folder and select the Project Ledger Currency column within it.

Folders

Each subject area has one fact folder and a number of dimension folders. Folders can have subfolders. For example, the Project folder in Project Billing - Invoices Real Time subject area has multiple subfolders like Project Classification, Project Data Attributes, Project Record Information, and so on.

  • Fact folders:

    • Contain fact columns.

    • Are usually at the bottom of the list of folders and are usually named after the subject area.

  • Dimension folders:

    • Contain attribute and hierarchical columns.

    • Are joined to the fact folder within a subject area.

      For example, if your analysis has Currency attribute from a dimension folder, you see a currency column in the results. If you also add the Total fact, then your analysis includes only those records that have both currency and total amount columns populated. Adding certain columns can reduce the query set for your analysis depending on how you've joined them in the query.

      Note: If you add attributes that don't have a value, you'll see them as null in the results if you've joined them appropriately in the query.
    • Can be common folders or contain common dimensions that appear in more than one subject area. If your analysis has columns from multiple subject areas then you must include:

      • Columns from dimension folders that are common to all those subject areas. At least one such column is mandatory.

      • One column from the fact folder in each of those subject areas.

Subject Areas for Oracle Project Portfolio Management Real-Time Analyses: Overview

You can use multiple subject areas to create real-time analyses and dashboards for Oracle Project Portfolio Management as listed below.

Subject Area Description Business Questions

Project Billing - Event Real Time

Analyze real-time information of project contract billing events. View project contract billing events at an individual transaction level and analyze billing events using dimensions such as contract, contract line, project, and task. You can also analyze billing events by event details such as event type, completion date, invoice revenue and status, and reversal indicator.

  • Which are the billing events for a project or contract and contract line?

  • What's the total amount or number of completed billing events which are not invoiced or recognized for revenue for a contract and contract line?

  • Which billing events are on an invoice hold or a revenue hold?

  • Which billing events are potentially missing an event completion date?

Project Billing - Funding Real Time

Gain insight into project contract funding information to analyze funds consumed for invoice and revenue, and funds remaining by using dimensions such as customer, organization, contract, billing type, project, task, and time.

  • Which are the contract lines for a contract?

  • How much of the contract line amount is invoiced and recognized for revenue?

  • Which projects are linked to contracts?

  • Which project contracts are active for a business unit?

Project Billing - Invoices Real Time

Gain insight into real-time project contract invoice information at an individual transaction level and analyze invoicing, concessions, and credits by using dimensions such as customer, organization, contract, billing type, project, task, employee, time, and currency.

  • What are the transactions for an invoice line?

  • Which invoices need attention?

  • What are the invoice line details for a particular invoice?

  • Who are the contracted customers for a business unit?

Project Billing - Revenue Real Time

Analyze real-time information on revenue recognized for project contracts. View project contract revenue information at an individual transaction level by using dimensions such as customer, organization, contract, billing type, project, task, employee, time, and currency.

  • Which contracts have actual revenue in the current accounting year?

  • Which contracts have the lowest actual revenue in the current accounting period?

  • What's the actual revenue trend for accounting periods in the selected accounting year?

Project Control - Budgets Real Time

Analyze project budget data such as raw and burdened cost, planned effort, revenue, and margin for current working, current baseline, and original baseline budget versions. View real-time project budget information by using dimensions such as project, task, employee, time, and planning resource.

  • Which projects are under a business unit and what are the statuses of these projects?

  • What's the budgeted amount for a project for the various budget versions?

  • What's the planned effort and revenue amount for a project for the various budget versions?

Project Control - Forecasts Real Time

Analyze project forecast data for current, prior, and original forecast versions. View real-time forecast data such as raw and burdened cost, planned effort, revenue, margin, and variance measures such as cost variance, revenue variance, and so on by using dimensions such as project, task, employee, time, and planning resource.

  • What are the raw and burdened costs for a project?

  • What's my cost variance?

  • What's my margin on a project?

  • What's the forecasted revenue for a project?

  • What are the different forecast versions for my project?

Project Control - Progress Real Time

Analyze project progress and view specific progress details such as actual cost, estimated effort to complete, cost percent spent, physical percent complete, and estimated cost at completion. Measure project performance using earned value metrics, including cost variance, cost performance index, and schedule performance index. Analyze performance trends as progress is captured over time and use that information to estimate and control project outcomes.

  • What's the latest published physical percent complete for all tasks?

  • What's the latest published physical percent complete for summary tasks?

  • What are the planned and actual costs for each task as per the latest published progress?

  • What are the cost and schedule performance indexes on my project?

Project Costing - Actual Costs Real Time

Analyze actual project costs by viewing supplier, labor, nonlabor, and third-party transaction project costs. View specific costs, associated expenditure items, and distribution line details for a specific project, task, task hierarchy, employee, project organization, and expenditure organization for a specific time period.

  • Which capitalizable costs are not yet capitalized?

  • How much does each transaction source contribute to project costs?

  • Which transactions contribute to the total cost of my projects?

Project Costing - Assets Real Time

Analyze capital projects and identify possible exceptions by comparing expensed and capitalizable costs. Track capitalizable costs throughout the capitalization process and review asset details, view asset assignments to projects and tasks, analyze amounts charged to different accounts, and drill down to cost distribution lines.

  • What's the total capitalized cost of my assets?

  • How's an expenditure item allocated across assets?

  • Which cost distributions are included in an asset line?

  • Which assets are assigned to a task?

Project Costing - Commitments Real Time

Gain insight into project commitment transactions from the procure-to-pay flow. View requisition, purchase order, and supplier invoice measures for a project, task, task hierarchy, project organization, and expenditure organization for a specific time period.

  • What are the requisitions and purchase orders that still have commitment costs for my project?

  • What are the outstanding commitments for my project?

  • Which commitments are associated with my capital projects?

Project Costing - Expenditure Item Performance - Real Time

Analyze expenditure item performance by gaining insight into project expenditure item costs, and billing and revenue details. View expenditure item type and class information for project, task, task hierarchy, employee, project organization, and expenditure organization for a specific time period.

  • What are the billing and revenue details by project?

  • What was the expenditure incurred on a project in a prior week?

  • Which expenditure items are associated with my capital projects?

Project Costing - Unprocessed Transactions Real Time

Analyze unprocessed project transactions sourced from Oracle Fusion or third-party applications and view general details about pending, failed, and unprocessed transactions including the original source and processing information. View unprocessed transactions for a project, task, task hierarchy, employee, related expenditure types, project organization, and expenditure organization for a specific time period.

  • What unprocessed transactions are waiting to be sent to Oracle Project Portfolio Management?

  • Which transactions weren't successfully imported to Oracle Project Portfolio Management?

Project Management - Change Management Real Time

Analyze real-time project change order information using dimensions such as change order reason, status, impact, participant, time, and project.

  • What's the number of pending change orders grouped by various stages?

  • What are the reasons for change orders?

  • What's the estimated cost and revenue for the change order?

  • What's the current stage and status of the change order?

Project Management - Opportunity Integration Real Time

Analyze specific project opportunity details such as status, win probability percentage, deal amounts, and weighted labor bill and cost amounts. View real-time information through opportunity-related project metrics using dimensions such as opportunity, project, and time.

  • How many projects are in the pipeline for each customer?

  • What's the weighted (adjusted) revenue for all projects under this branch of the enterprise project structure?

  • Which are the projects for this opportunity?

  • How much did it cost to pursue this deal?

  • What are the win probabilities for opportunities on a project?

  • What are the deal and weight labor bill amounts on a project?

Project Management - Planning Real Time

Analyze project plan data and view specific project plan details such as start and finish dates, progress information, planned, actual, and remaining cost, and labor effort. View real-time information through project plan metrics using dimensions such as project, task, employee, progress status, resource, sprint, and time.

  • What are the planned billing amounts for my projects?

  • What are the operating margins for my projects?

  • What are the planned and actual margins and margin percentages for my projects?

  • What are the planned and actual costs for my projects?

  • How much effort is planned per resource role for my projects?

Project Management - Project Issues Real Time

Analyze the issues and related action items that you own or create, or that are related to projects that you manage. View real-time information across different dimensions such as project, owner, issue type, and status.

  • Which issues are open for my projects, along with their details?

  • Which issues are open for an individual owner?

  • What are my action items?

  • What patterns are apparent from historic performance on issues? What can we learn from analysis of issues that could help future project performance?

Project Management - Project Hierarchy Real Time

Analyze project plan data such as cost, schedule, effort, and bill amounts rolled up to enterprise project structure. Analyze real-time information through project hierarchy metrics using dimensions such as project hierarchy, resource, employee, task, task hierarchy, progress status, time, project, and sprint.

  • What are the actual costs for my EPS elements?

  • What are the total costs for my EPS elements?

Project Management - Project Resources Real Time

Analyze real-time project resource allocation information, for example, project labor and expense resource allocations using dimensions such as employee, resource class, resource, project role, project resource assignment status, project, and opportunity.

  • What are the statuses of the resources currently working on my projects?

  • Who are the planned resources assigned to my projects?

  • What are the allocated hours for my project resources?

Project Management - Project Work Items Real Time

Analyze real-time project work item information and view specific project work item details such as deliverables, concepts, proposals, requirements specifications, product change orders, items, and negotiations. View real-time information through work item metrics using dimensions such as project, task, priority, and status.

  • What are the work items for my projects?

  • What are the work item statuses that determine the completion of my project tasks?

  • Which of my project deliverables are overdue, due soon, and yet to start?

  • What are the allocated hours for my project resources?

Project Management - Requirements Real Time

Analyze real-time project backlog information for your project backlog items using dimensions such as requirement hierarchy, sprint, product, release, scrum master, backlog owner, project, and task.

  • What's the total number of backlog items by status for a product in a given sprint?

  • What's the total number of story points achieved in each sprint of a release?

  • Which of my backlog items have exceptions?

  • What are the planned hours for each backlog item?

  • What are the backlog items for my projects in a sprint?

  • What's the remaining effort for my backlog items?

Project Resource Management - Resource Management Real Time

Analyze real-time project resource assignment information, for example, project resource supply, demand (requests and assignments), and utilization using dimensions such as resource, resource pool, role, qualification, time, and project.

  • Which requests are in Open or Resource Proposed status?

  • What's the forecasted revenue and margin for resource requests that are in Open or Resource Proposed status?

Project Resource Management - Resource Pool Real Time

Analyze real-time resource pool information using dimensions such as resource, resource pool, resource pool membership, resource pool hierarchy, department, and location.

  • Which resources belong to a resource pool?

  • What are the dates of pool membership for a resource?

  • What's a resource's pool membership history since the resource was hired?

Project Management - Task Management Real Time

Analyze the tasks that you own or create, including project tasks, to-do tasks, action items, and milestones.

  • Which project tasks are due in 7 days?

  • In how many days are my project tasks due?

  • Which project tasks are incomplete?

  • Which project tasks, milestones, and action items are due?

Projects - Cross Subject Area Analysis - Real Time

Analyze real-time information on project performance, including budgets, forecasts, costs, commitments, revenue, and invoices using dimensions such as award, fiscal calendar, employee, project, task, organizations, and time.

  • Is my project profitable?

  • How much funding has my contract consumed?

  • How much has been invoiced for my contract?

  • How does my budgeted cost compare against my actual and forecast costs?

  • What are my committed costs for a project?

  • How does my budgeted revenue compare against my actual and forecast revenue?

Projects - Grants Management - Award Analysis Real Time

Analyze real-time award information using dimensions such as award, award project, keyword, certification, reference types, and time.

  • What are the awards for a specific keyword, for example, awards on diabetes research?

  • Which award certifications expire in the next 30 days?

  • What are the proposal numbers for the awards?

  • Which are the certifications awarded for various projects?

Projects - Grants Management - Award Funding Real Time

Analyze real-time award funding information using dimensions such as award, award project, budget period, funding source, sponsor, personnel, keyword, organization credits, and time.

  • Which awards are currently active?

  • Which awards are past their end dates but weren't closed?

  • What's the allocated funding amount for each project of an active award?

  • What's the total funding by department year over year?

  • What awards have funding unallocated to projects?

The following table lists the currencies supported by each subject area.

Subject Area Supported Currency

Project Billing - Event Real Time

  • Ledger Currency

  • Entered Currency

  • Project Currency

  • Contract Currency

Project Billing - Funding Real Time

Contract Currency

Project Billing - Invoices Real Time

  • Ledger Currency

  • Entered Currency

  • Project Currency

  • Contract Currency

Project Billing - Revenue Real Time

  • Ledger Currency

  • Entered Currency

  • Project Currency

  • Contract Currency

Project Control - Budgets Real Time

  • Ledger Currency

  • Entered Currency

  • Project Currency

Project Control - Forecasts Real Time

  • Ledger Currency

  • Entered Currency

  • Project Currency

Project Control - Progress Real Time

  • Ledger Currency

  • Project Currency

Project Costing - Actual Costs Real Time

  • Ledger Currency

  • Entered Currency

  • Project Currency

The project currency is valid for all measures except for the Transfer Price measures.

Project Costing - Assets Real Time

  • Ledger Currency

  • Entered Currency

  • Project Currency

Project Costing - Commitments Real Time

  • Ledger Currency

  • Entered Currency

  • Project Currency

Project Costing - Expenditure Item Performance - Real Time

  • Ledger Currency

  • Entered Currency

  • Project Currency

Project Costing - Unprocessed Transactions Real Time

  • Ledger Currency

  • Entered Currency

  • Project Currency

Project Management - Change Management Real Time

Project Currency

Project Management - Opportunity Integration Real Time

Project Currency

Project Management - Planning Real Time

Project Currency

Project Management - Project Issues Real Time

Not Applicable

Project Management - Project Hierarchy Real Time

Project Currency

Project Management - Project Resources Real Time

Not Applicable

Project Management - Project Work Items Real Time

Not Applicable

Project Management - Requirements Real Time

Not Applicable

Project Resource Management - Resource Management Real Time

Project Currency

Project Resource Management - Resource Pool Real Time

Not Applicable

Project Management - Task Management Real Time

Not Applicable

Projects - Cross Subject Area Analysis - Real Time

  • Ledger Currency

  • Entered Currency

  • Project Currency

  • Contract Currency

The contract currency is valid only for invoice and revenue related measures.

Projects - Grants Management - Award Analysis Real Time

Not Applicable

Projects - Grants Management - Award Funding Real Time

  • Ledger Currency

  • Entered Currency

  • Project Currency

  • Contract Currency

Available Dimensions for Oracle Project Portfolio Management Subject Areas: Overview

Each subject area has a number of dimension folders and one fact folder. The dimension folders contain attribute and hierarchical columns. Dimensions are joined to the fact folder within a subject area. If an analysis you use has the Currency attribute from a dimension folder, you see a currency column in the results. This table describes the dimensions you can use for analyses in Oracle Project Portfolio Management.

Subject Area Dimensions

Project Billing - Event Real Time

  • Billing Event Measures

  • Currency Exchange Details

  • Event Details

  • Event Type

  • Fiscal Calendar

  • Organizations

  • Project

  • Project Contract Header Details

  • Project Contract Line Details

  • Task

  • Task Hierarchy

  • Time

Project Billing - Funding Real Time

  • Contract Customer Account

  • Currency Details

  • Fiscal Calendar

  • Funding Details

  • Organizations

  • Project

  • Project Contract Header Details

  • Project Contract Line Details

  • Project Contract Measures

  • Project Funding Measures

  • Task

  • Task Hierarchy

  • Time

Project Billing - Invoices Real Time

  • Award

  • Bill-to Customer

  • Bill-to Customer Account

  • Contract Customer Account

  • Contract and Project Details

  • Credits and Write-offs

  • Currency Exchange Details

  • Customer Details

  • Employee

  • Event Details

  • Expenditure Item

  • Expenditure Type

  • Fiscal Calendar

  • Institution

  • Intercompany and Interproject Details

  • Invoice Calculation

  • Invoice Details

  • Invoice Processing

  • Invoice Transaction Measures

  • Organizations

  • Primary Sponsor

  • Project

  • Project Contract Header Details

  • Project Contract Line Details

  • Receiver Fiscal Calendar

  • Task

  • Task Hierarchy

  • Tax Details

  • Time

Project Billing - Revenue Real Time

  • Accounting Class

  • Award

  • Balancing Segment

  • Contract Customer Account

  • Contract and Project Details

  • Cost Center

  • Currency Exchange Details

  • Employee

  • Event Details

  • Expenditure Item

  • Fiscal Calendar

  • GL Accounting Date

  • GL Accounting Date Fiscal Calendar

  • General Ledger Account

  • Institution

  • Intercompany and Interproject Details

  • Job

  • Ledger

  • Legal Entity

  • Natural Account

  • Organizations

  • Primary Sponsor

  • Project

  • Project Contract Header Details

  • Project Contract Line Details

  • Receiver Fiscal Calendar

  • Revenue Accounting Details

  • Revenue Calculation

  • Revenue Details

  • Revenue Transaction Measures

  • Task

  • Task Hierarchy

  • Time

Project Control - Budgets Real Time

  • Award

  • Employee

  • Fiscal Calendar

  • Institution

  • Organizations

  • Primary Sponsor

  • Project

  • Project Budget

  • Project Budget Version

  • Projects Calendar

  • Receiver Fiscal Calendar

  • Resource Class

  • Task

  • Task Hierarchy

  • Time

Project Control - Forecasts Real Time

  • Employee

  • Fiscal Calendar

  • Forecast Fact

  • Organizations

  • Project

  • Project Forecast Version

  • Projects Calendar

  • Receiver Fiscal Calendar

  • Resource Class

  • Task

  • Task hierarchy

  • Time

Project Control - Progress Real Time

  • Organizations

  • Progress

  • Progress As Of Date

  • Progress Measures

  • Project

  • Project Progress Status

  • Task

Project Costing - Actual Costs Real Time

  • Accounting Class

  • Adjustment Details

  • Award

  • Balancing Segment

  • Capitalization Details

  • Cost Accounting Details

  • Cost Center

  • Currency Exchange Details

  • Effort Details

  • Employee

  • Expenditure Class

  • Expenditure Item

  • Expenditure Item Billing Details

  • Expenditure Item Revenue Details

  • Expenditure Item and Cost Distribution Cross-Charge Transaction Details

  • Expenditure Item and Cost Distribution Details

  • Expenditure Type

  • Fiscal Calendar

  • GL Accounting Date

  • GL Accounting Date Fiscal Calendar

  • General Ledger Account

  • Imported Cost Accounts

  • Institution

  • Item

  • Job

  • Ledger

  • Legal Entity

  • Natural Account

  • Nonlabor Resource

  • Organizations

  • Original Source References

  • Primary Sponsor

  • Processing Details

  • Project

  • Project Contract Header Details

  • Project Contract Line Details

  • Projects Calendar

  • Receiver Fiscal Calendar

  • Receiver Ledger Currency Exchange Details

  • Supplier

  • Task

  • Task Hierarchy

  • Time

  • Transfer Price Currency Exchange Details

  • Work Type

Projects Costing - Assets Real Time

  • Capital Event

  • Cost Distribution Line

  • Currency Exchange Details

  • Expenditure Item

  • Project

  • Project Asset

  • Project Asset Line

  • Time

Project Costing - Commitments Real Time

  • Award

  • Commitment Details

  • Currency Details for Commitments

  • Expenditure Class

  • Expenditure Type

  • Institution

  • Organizations

  • Primary Sponsor

  • Project

  • Projects Calendar

  • Resource Class

  • Supplier

  • Task

  • Task Hierarchy

  • Time

  • Work Type

Project Costing - Expenditure Item Performance - Real Time

  • Capitalization Details

  • Currency Exchange Details

  • Effort Details

  • Employee

  • Expenditure Class

  • Expenditure Item Billing Details

  • Expenditure Item Details

  • Expenditure Item Revenue Details

  • Expenditure Type

  • Item

  • Job

  • Legal Entity

  • Nonlabor Resource

  • Organizations

  • Original Source References

  • Processing Details

  • Project

  • Project Contract Header Details

  • Project Contract Line Details

  • Receiver Ledger Currency Exchange Details

  • Supplier

  • Task

  • Task Hierarchy

  • Work Type

Project Costing - Unprocessed Transactions Real Time

  • Award

  • Currency Exchange Details for Unprocessed Transactions

  • Employee

  • Expenditure Class

  • Expenditure Type

  • Imported Cost Accounts

  • Institution

  • Item

  • Job

  • Nonlabor Resources

  • Organizations

  • Primary Sponsor

  • Project

  • Projects Calendar

  • Supplier

  • Task

  • Task hierarchy

  • Time

  • Unprocessed Transactions Adjustment Details

  • Unprocessed Transactions Details

  • Unprocessed Transactions Effort Details

  • Unprocessed Transactions Original Source References

  • Unprocessed Transactions Processing Details

  • Work Type

Project Management - Change Management Real Time

  • Change Management Measures

  • Change Order

  • Project

  • Time

Project Management - Opportunity Integration Real Time

  • Currency Detail

  • Opportunity

  • Opportunity Based Measures

  • Project

  • Project Plan Dates

  • Project Planning Measures

  • Project Progress Status

  • Time

Project Management - Planning Real Time

  • Employee

  • Milestone

  • Primary Resource

  • Primary Task Assignment Resource

  • Project

  • Project Plan Dates

  • Project Plan Details

  • Project Planning Measures

  • Project Progress Status

  • Resource

  • Resource Class

  • Sprint

  • Task

  • Task Hierarchy

  • Time

Project Management - Project Issues Real Time

  • Action Item Creator

  • Action Item Details

  • Action Item Measures

  • Action Item Owner

  • Action Item Status

  • Issue Closed Reason

  • Issue Creator

  • Issue Details

  • Issue Measures

  • Issue Owner

  • Issue Priority

  • Issue Status

  • Issue Type

  • Project

  • Time

Project Management - Project Hierarchy Real Time

  • Opportunity

  • Opportunity Based Measures

  • Project

  • Project Hierarchy

  • Project Hierarchy Measures

  • Project Progress Status

  • Time

Project Management - Project Resources Real Time

  • Employee

  • Opportunity

  • Project

  • Project Resource Details

  • Project Resource Finish Date

  • Project Resource Measures

  • Project Resource Start Date

  • Project Role

  • Resource

  • Resource Assignment Status

  • Resource Class

  • Time

Project Management - Project Work Items Real Time

  • Project

  • Task

  • Task Hierarchy

  • Time

  • Work Item Creator

  • Work Item Details

  • Work Item Measures

  • Work Item Owner

  • Work Item Priority

  • Work Item Status

  • Work Item Type

Project Management - Requirements Real Time

  • Acceptance Criteria

  • Backlog Item Details

  • Backlog Item Measures

  • Milestone

  • Owner

  • Priority

  • Product

  • Project

  • Release

  • Requirement

  • Requirement Hierarchy

  • Scrum Master

  • Spirit

  • Status

  • Task

  • Task Effort Measures

Project Management - Task Management Real Time

  • Issue

  • Milestone

  • Primary Resource

  • Project

  • Project Progress Status

  • Resource

  • Tag

  • Task

  • Task Creator

  • Task Dates

  • Task Follower

  • Task Management Details

  • Task Management Measures

  • Task Owner

  • Task Type

Project Resource Management - Resource Management Real Time

  • Assignment

  • Project

  • Project Assignment Dates

  • Project Request Dates

  • Project Resource Actuals

  • Project Resource Assignment

  • Project Resource Request

  • Project Resource Supply

  • Project Resource Utilization

  • Project Role

  • Qualification

  • Request

  • Resource

  • Supply

  • Time

Project Resource Management - Resource Pool Real Time

  • Resource

  • Resource Pool

Projects - Cross Subject Area Analysis - Real Time

  • Award

  • Award Funding Details

  • Award Funding Measures

  • Award Project Funding Measures

  • Bill-to Customer

  • Budget Transaction Measures

  • Commitment Transaction Measures

  • Cost Transaction Measures

  • Employee

  • Fiscal Calendar

  • Forecast Transaction Measures

  • Invoice Transaction Measures

  • Organizations

  • Project

  • Project Contract Header Details

  • Project Contract Line Details

  • Reviewer Fiscal Calendar

  • Resource

  • Revenue Transaction Measures

  • Task

  • Task Hierarchy

  • Time

Projects - Grants Management - Award Analysis Real Time

  • Award

  • Award Certification Measures

  • Award Keyword Measures

  • Award Reference Measures

  • Certification

  • Keyword

  • Project

  • Reference Type

Projects - Grants Management - Awards Funding Real TIme

  • Award

  • Award Funding Details

  • Award Funding Measures

  • Award Keyword Measures

  • Award Project

  • Award Project Funding Measures

  • Fiscal Calendar

  • Institution

  • Keyword

  • Organization Credit

  • Organizations

  • Personnel

  • Primary Sponsor

  • Project

  • Project Contract Header Details

  • Project Contract Line Details

  • Terms and Conditions

  • Time

Predefined Analytics for Oracle Project Portfolio Management: Overview

You can use the following predefined analyses and dashboards for your reporting needs. Based on your requirements, you can use these directly or copy and customize them.

Subject Area Title

Project Billing - Event Real Time

  • Project Billing Events

  • Project Billing - Invoiced Transactions

    This analysis is also listed under the Project Billing - Invoices Real Time subject area.

  • Project Revenue - Recognized Transactions

    This analysis is also listed under the Project Billing - Revenue Real Time subject area.

Project Billing - Funding Real Time

  • Project Contract Lines

  • Project Contract List

These analyses are also listed under the Project Billing - Invoices Real Time and Project Billing - Revenue Real Time subject areas.

Project Billing - Invoices Real Time

  • Project Contract Lines

    This analysis is also listed under the Project Billing - Funding Real Time and Project Billing - Revenue Real Time subject areas.

  • Project Contract List

    This analysis is also listed under the Project Billing - Funding Real Time and Project Billing - Revenue Real Time subject areas.

  • Project Billing - Invoiced Transactions

    This analysis is also listed under the Project Billing - Event Real Time subject area.

  • Project Billing - Invoice Lines

  • Invoices by Status

Project Billing - Revenue Real Time

  • Project Revenue - Recognized Transactions

    This analysis is also listed under the Project Billing - Event Real Time subject area.

  • Project Revenue - Contract Lines

  • Revenue by Contract

  • Project Income Statement

    This analysis is also listed under the Project Costing - Actual Costs Real Time subject area.

  • Project Contract Lines

    This analysis is also listed under the Project Billing - Invoices Real Time and Project Billing - Funding Real Time subject areas.

  • Project Contract List

    This analysis is also listed under the Project Billing - Invoices Real Time and Project Billing - Funding Real Time subject areas.

Project Control - Budgets Real Time

  • Budget vs Actual Cost Comparison

    This analysis is also listed under the Project Costing - Actual Costs Real Time subject area.

  • Project Tasks

  • Project List

Project Costing - Actual Costs Real Time

  • Project Income Statement

    This analysis is also listed under the Project Billing - Revenue Real Time subject area.

  • Budget vs Actual Cost Comparison

    This analysis is also listed under the Project Control - Budgets Real Time subject area.

  • Project Cost Account Reconciliation

  • Project Cost by Transaction Source Details

  • Project Cost by Transaction Source

  • Project Expenditure Items

    This analysis is also listed under the Project Costing - Commitments Real Time subject area.

  • Project Capital Costs

    This analysis is also listed under the Project Costing - Commitments Real Time subject area.

Project Costing - Assets Real Time

  • Capital Expenditures

  • Uncapitalizable Cost for Capitalizable Tasks

  • Capital Asset Assignments

  • Capital Asset Lines

  • Capital Assets

Project Costing - Commitments Real Time

  • Project Expenditure Items

  • Project Capital Costs

These analyses are also listed under the Project Costing - Actual Costs Real Time subject area.

Project Management - Change Management Real Time

  • Change Orders by Participant Status

  • Change Orders by Reason

  • Change Order Details

  • Pending Change Orders Summary

Project Management - Planning Real Time

  • Tasks Scheduled Outside of Resource Assignment Dates

    This analysis is also listed under the Project Management - Project Resources Real Time subject area.

  • Resource Allocation and Task Assignment Comparison by Week

    This analysis is also listed under the Project Management - Planning Real Time subject area.

  • Project Cost Variance

  • Planned and Actual Project Labor Comparison

  • Actual Project Labor Margin

Project Management - Project Issues Real Time

  • Action Item Details

  • Closed Issue Analysis

  • Detail of Open Issues

  • Issue Analysis by Project

  • Issues Aging

  • Issues by Type

  • Issue Details

  • My Open Action Items

  • My Open Issues

  • Open Action Items by Project

Project Management - Project Hierarchy Real Time

  • Delegate Access Analysis

  • Owner Access Analysis

  • Remaining Project Hours

  • Total and Actual EPS Node Cost

  • Total Project Hours

Project Management - Project Resources Real Time

  • Tasks Scheduled Outside of Resource Assignment Dates

    This analysis is also listed under the Project Management - Planning Real Time subject area.

  • Resource Allocation and Task Assignment Comparison by Week

    This analysis is also listed under the Project Management - Planning Real Time subject area.

  • Placeholder Resources on My Projects

  • Resources Currently on My Projects

Project Management - Project Work Items Real Time

  • Deliverables Due in My Projects

  • Deliverables Not Started in My Projects

  • All Work Items in My Projects

Project Management - Requirements Real Time

  • Backlog Completeness Check Analysis

  • Backlog Item Sprint Velocity Analysis

  • Backlog Items Status Analysis

  • Project Hours by Backlog Item Analysis

Project Resource Management - Resource Management Real Time

  • Projected Revenue Shortfall by Resource

  • Requested Resource Forecast Revenue Details

  • Project Resource Request Forecast Revenue

  • Resource Pool Projected and Actual Utilization by Resource

  • Resource Pool Actual Utilization by Resource and Month

  • Resource Capacity Planning by Project Role

Project Management - Task Management Real Time

  • Project Work Coming Due

  • My Upcoming Tasks

Projects - Cross Subject Area Analysis - Real Time

Actual Cost Analysis by Resource Type

Projects - Grants Management - Award Funding Real Time

  • Award Project Funding Details

  • Award List

Assets

Project Capital Costs Analysis: Explained

This topic provides an overview of the Project Capital Costs analysis.

Overview

The Project Capital Costs analysis displays actual and committed costs for capital projects, including capitalization details. You can drill down to project expenditure items from this analysis.

Key Insights

This report answers the following business questions:

  • What are the actual and committed costs incurred by my capital projects?

  • How much of this cost is capitalizable?

  • How much of this cost is already capitalized?

Frequently Asked Questions

FAQ Answer

How do I find this report?

Reports and Analytics - Shared Folders - Projects - Project Financials Sample Reports

Who uses this report?

  • Project Accountant

  • Project Manager

When do I use this report?

When you need to know how much of the actual and committed costs for a capital project is capitalizable and how much of these costs is already capitalized.

What can I do with this report?

You can:

  • View the list of projects by:

    • Project Business Unit

    • Project Organization

    • Project Status

  • Drill down to the Project Expenditure Items analysis using the Total Cost column.

What type of report is this?

Oracle Transactional Business Intelligence

Related Subject Areas

This report uses the Project Costing - Actual Costs Real Time and Project Costing - Commitment Real Time subject areas.

Report Details

The following table lists the selected columns, underlying formulas, and customized column properties for the report.

Selected Column Source and Customized Properties

Project Business Unit

  • "Project"."Project Business Unit"

  • Excluded from view

Project Organization

  • "Project"."Organization Name"

  • Excluded from view

Project Number

"Project"."Project Number"

Currency Code

"Currency Exchange Details"."Apps Common Currency Code"

union joins with

"Currency Details for Commitments"."Apps Common Currency Code"

Project Status

  • "Project"."Current Project Status Name"

  • Excluded from view

Enable Capitalization

  • "- Project Type Attributes"."Project Capitalizable Flag"

  • Excluded from view

Template

  • "- Project Indicator Attributes"."Template Flag"

  • Excluded from view

Capitalizable Flag

  • "Capitalization Details"."Capitalizable Flag"

    union joins with

    "Commitment Details"."Capitalizable Flag"

  • Excluded from view

Capitalized

  • "Capitalization Details"."Expenditure Item Capitalization Distribution Flag"

    union joins with

    'N'

  • Excluded from view

Transaction Number

  • "Expenditure Item"."Expenditure Item"

    union joins with

    "Commitment Details"."Commitment Number"

  • Excluded from view

Total Cost

  • "- Expenditure Item and Cost Distribution Measures"."Cost"

    union joins with

    "- Commitment Cost Measures"."Total Committed Cost"

  • Action link to the Project Expenditure Items analysis

Expenditure Item

  • "Capitalization Details"."Expenditure Item Capitalizable Flag"

    union joins with

    "Commitment Details"."Capitalizable Flag"

  • Excluded from view

Cost Type

  • 'Actuals'

    union joins with

    "Commitment Details"."Commitment Type"

  • Excluded from view

Actual Cost

  • Calculated measure

  • If cost type is actual then equals total cost else 0

  • Default sum

Purchase Requisition

  • Calculated measure

  • If cost type is purchase requisition then equals total cost else 0

  • Default sum

Purchase Order

  • Calculated measure

  • If cost type is purchase order then equals total cost else 0

  • Default sum

Supplier Invoice

  • Calculated measure

  • If cost type is supplier invoice then equals total cost else 0

  • Default sum

Capitalizable Total Cost

  • Calculated measure

  • If expenditure item is capitalizable then equals total cost else 0

  • Default sum

Capitalizable Actual Cost

  • Calculated measure

  • If expenditure item is capitalizable and cost type is actual then equals total cost else 0

  • Default sum

Capitalizable Committed Cost

  • Calculated measure

  • Displays the difference between total cost and capitalizable actual cost.

  • Default sum

Capitalized Cost

  • Calculated measure

  • Displays the difference between total cost and capitalizable total cost.

  • Default sum

The following table lists the prompts and filters used in the report.

Filter on Column Type Rules

Project Business Unit

Dashboard prompt

  • Choice list

  • Select multiple values enabled

  • Default selection: All values

Project Organization

Dashboard prompt

  • Choice list

  • Values limited by Project Business Unit

  • Select multiple values enabled

  • Default selection: All values

Project Status

Dashboard prompt

  • Choice list

  • Select multiple values enabled

  • Default selection specific value: Approved

Enable Capitalization

Filter

Equals 'Y'

Template

Filter

Not 'Y'

The following table lists the views in the report.

View Displayed Information

View Name

Project Capital Costs

View Sections

None

Table Column and Measures

  1. Project

    1. Project Number

    2. Currency Code

  2. Total Cost

  3. Actual Cost

  4. Committed Costs

    1. Purchase Requisition

    2. Purchase Order

    3. Supplier Invoice

  5. Capitalization Details

    1. Capitalizable Total Cost

    2. Capitalizable Actual Cost

    3. Capitalizable Committed Cost

    4. Capitalized Cost

Project Expenditure Items Analysis: Explained

This topic provides an overview of the Project Expenditure Items analysis.

Overview

The Project Expenditure Items analysis displays the total cost of a capital project included in the Project Capital Costs analysis by task and expenditure item. You can drill down to the Project Expenditure Items analysis by clicking on the Total Cost column data on the Project Capital Costs analysis.

Key Insights

This report answers the following business question:

Which expenditure items and commitments are associated with my capital projects?

Frequently Asked Questions

The following table lists frequently asked questions about this report.

FAQ Answer

How do I find this report?

Reports and Analytics pane - Shared Folders - Projects - Project Financials Sample Reports - Project Capital Cost

Who uses this report?

  • Project Accountant

  • Project Manager

When do I use this report?

When you need to review the expenditure items and commitments for a capital project.

What can I do with this report?

You can review:

  • Expenditure items for your capital project.

  • Commitments for your capital project.

What type of report is this?

Oracle Transactional Business Intelligence

Related Subject Areas

This report uses the Project Costing - Actual Costs Real Time and Project Costing - Commitment Real Time subject areas.

Report Details

The following table lists the selected columns, underlying formulas, and customized column properties for the report.

Selected Column Source and Customized Properties

Project Number

"Project"."Project Number"

Project Name

  • "Project"."Project Name"

  • Excluded from view

Transaction Number

cast("Expenditure Item"."Expenditure Item" as char)

union joins with

"Commitment Details"."Commitment Number"

Cost

"- Expenditure Item and Cost Distribution Measures"."Cost"

union joins with

"- Commitment Cost Measures"."Total Committed Cost"

Capitalizable

CASE "Capitalization Details"."Expenditure Item Capitalizable Flag" WHEN 'Y' THEN 'Yes' ELSE 'No' END

union joins with

CASE "Commitment Details"."Capitalizable Flag" WHEN 'Y' THEN 'Yes' ELSE 'No' END

Capitalized

Case "Capitalization Details"."Expenditure Item Capitalization Distribution Flag" WHEN 'Y' THEN 'Yes' ELSE 'No' END

union joins with

'No'

Cost Type

'Actuals'

union joins with

"Commitment Details"."Commitment Type Name"

Currency Code

"Currency Exchange Details"."Apps Common Currency Code"

union joins with

"Currency Details for Commitments"."Apps Common Currency Code"

Expenditure Type

"Expenditure Type"."Resource Type Name"

Expenditure Item Creation Date

"- Expenditure Item and Cost Distribution Record Information"."Expenditure Item Creation Date"

union joins with

"- Commitment Record Information"."Creation Date"

Expenditure Organization

"- Expenditure Owning Organization"."Expenditure Organization Name"

union joins with

"Commitment Details"."Organization Name"

Task Number

"Task"."Task Number"

Task Name

"Task"."Task Name"

Project Manager

"Project"."Current Project Manager"

The following table lists the prompts and filters used in the report.

Filter on Column Type Rules

Project Number

Prompt

  • Prompted

  • Default value: 001 VKD Capital Project

The following table lists the views in the report.

View Displayed Information

View Name

Project Expenditure Items

View Sections

Currency Code

Table Column and Measures

  1. Project Number

  2. Project Manager

  3. Task Number

  4. Task Name

  5. Transaction Number

  6. Cost

  7. Cost Type

  8. Capitalizable

  9. Capitalized

  10. Expenditure Type

  11. Expenditure Item Creation Date

  12. Expenditure Organization

Capital Asset Assignments Analysis: Explained

This topic provides an overview of the Capital Asset Assignments analysis.

Overview

The Capital Asset Assignments analysis displays how your assets and asset costs are assigned to your projects and tasks.

Key Insights

This report answers the following business questions:

  • What's the total cost of assets assigned at the project level?

  • Which assets are assigned to a task?

  • Which assets aren't assigned?

Frequently Asked Questions

The following table lists frequently asked questions about this report.

FAQ Answer

How do I find this report?

Reports and Analytics pane - Shared Folders - Projects - Project Financials Sample Reports

Who uses this report?

Project Accountant

When do I use this report?

When you need to:

  • Review how assets are assigned to projects and tasks.

  • Group your assets by asset type and category.

What can I do with this report?

You can view:

  • Assets grouped by

    • Asset type

    • Asset category

  • Costs for these asset groups.

What type of report is this?

Oracle Transactional Business Intelligence

Related Subject Area

This report uses the Project Costing - Assets Real Time subject area.

Report Details

The following table lists the selected columns, underlying formulas, and customized column properties for the report.

Selected Column Source and Customized Properties

Project Number

"Project"."Project Number"

Project Name

"Project"."Project Name"

Asset Task - Task Number

"Asset Task"."Asset Task - Task Number"

Asset Task - Task Name

"Asset Task"."Asset Task - Task Name"

Grouping Level Type

"Project Asset"."Asset Grouping Level Type"

Asset Number

"Project Asset"."Asset Number"

Asset Name

"Project Asset"."Asset Name"

Asset Key

"Project Asset"."Asset Id"

Asset Category

"Project Asset"."Asset Category"

Asset Type

"Project Asset"."Asset Type"

Estimated Units

  • "Asset Measures"."Estimated Asset Units"

  • Value suppression: Repeat

Actual Units

  • "Asset Measures"."Actual Asset Units"

  • Value suppression: Repeat

Estimated Asset Cost

  • "Asset Measures"."Estimated Asset Cost"

  • Value suppression: Repeat

Asset Cost

  • "Asset Line Measures"."Rounded Grouped Cost"

  • Value suppression: Repeat

Currency

"Currency Exchange Details"."Apps Common Currency Code"

The following table lists the prompts and filters used in the report.

Filter on Column Type Rules

Project Number

Dashboard prompt

  • Choice list

  • Required

  • Select multiple values enabled

  • Default selection SQL:

    select min("Project"."Project Number") from "Project Costing - Assets Real Time"

Asset Category

Dashboard prompt

  • Choice list

  • Select multiple values enabled

Task Number

Dashboard prompt

  • Choice list

  • Select multiple values enabled

  • Values limited by All Prompts

Task Name

Dashboard prompt

  • Choice list

  • Select multiple values enabled

Grouping Level Type

Dashboard prompt

  • Choice list

  • Select multiple values enabled

The following table lists the views in the report.

View Displayed Information

View Name

Capital Asset Assignments

View Sections

None

Table Column and Measures

  1. Project Number

  2. Project Name

  3. Asset Category

  4. Asset Type

  5. Grouping Level Type

  6. Asset Number

  7. Asset Name

  8. Asset Key

  9. Currency

  10. Estimated Units

  11. Actual Units

  12. Estimated Asset Cost

  13. Asset Cost

  14. Asset Task - Task Number

  15. Asset Task - Task Name

Capital Asset Lines Analysis: Explained

This topic provides an overview of the Capital Asset Lines analysis.

Overview

The Capital Asset Lines analysis displays the expenditure items and cost distributions that are allocated and assigned to an asset in a given period.

Key Insights

This report answers the following business questions:

  • Which asset lines contribute to my assets?

  • What's the total capitalized cost of my assets?

  • How's an expenditure item allocated across assets?

  • Which cost distributions are included in an asset line?

Frequently Asked Questions

The following table lists frequently asked questions about this report.

FAQ Answer

How do I find this report?

Reports and Analytics pane - Shared Folders - Projects - Project Financials Sample Reports

Who uses this report?

Project Accountant

When do I use this report?

When you need to:

  • Perform detailed analysis to determine which expenditure items and cost distribution lines are allocated and assigned to an asset in a given period.

  • Review how expenditure items are grouped into asset lines.

What can I do with this report?

You can review and analyze:

  • The asset lines that contribute to your total assets.

  • You total capitalized and CIP cost.

What type of report is this?

Oracle Transactional Business Intelligence

Related Subject Area

This report uses the Project Costing - Assets Real Time subject area.

Report Details

The following table lists the selected columns, underlying formulas, and customized column properties for the report.

Selected Column Source and Customized Properties

Capital Event Number

"Capital Event"."Capital Event Number"

Asset Line Number

"Project Asset Line"."Project Asset Line Id#1"

Asset Period

"Project Asset Line"."FA Period Name"

Asset Number

"Project Asset"."Asset Number"

Asset Name

"Project Asset"."Asset Name"

Asset Category

"Project Asset"."Asset Category"

Asset Line Task Number

"Asset Line Task"."Asset Line Task - Task Number"

Asset Line Task Name

"Asset Line Task"."Asset Line Task - Task Name"

Expenditure Organization

"Expenditure Item"."Expenditure Organization"

Transaction Number

"Expenditure Item"."Expenditure Item"

Transaction Date

"Expenditure Item"."Expenditure Item Date"

Expenditure Type

"Expenditure Type"."Resource Type Name"

Distribution Line Number

"Cost Distribution Line"."Distribution Line Num"

Currency

"Currency Exchange Details"."Apps Common Currency Code"

Capitalized Cost

  • "Asset Line Measures"."Rounded Capitalized Cost"

  • Value suppression: Repeat

CIP Cost

  • "Asset Line Measures"."Rounded Grouped CIP Cost"

  • Value suppression: Repeat

The following table lists the prompts and filters used in the report.

Filter on Column Type Rules

Project Number

Dashboard prompt

  • Choice list

  • Required

  • Select multiple values enabled

  • Default selection SQL:

    select min("Project"."Project Number") from "Project Costing - Assets Real Time"

Capital Event Number

Dashboard prompt

  • Choice list

  • Select multiple values enabled

Transaction Number

Dashboard prompt

  • Choice list

  • Select multiple values enabled

Asset Number

Dashboard prompt

  • Choice list

  • Select multiple values enabled

  • Values limited by All Prompts

Asset Line Number

Dashboard prompt

  • Choice list

  • Select multiple values enabled

Accounting Period

Dashboard prompt

  • Choice list

  • Required

  • Select multiple values enabled

The following table lists the views in the report.

View Displayed Information

View Name

Capital Asset Lines

View Sections

None

Table Column and Measures

  1. Asset Category

  2. Capital Event Number

  3. Asset Number

  4. Asset Name

  5. Asset Line Number

  6. Asset Line Task Number

  7. Asset Line Task Name

  8. Expenditure Organization

  9. Asset Period

  10. Transaction Number

  11. Transaction Date

  12. Expenditure Type

  13. Distribution Line Number

  14. Currency

  15. Capitalized Cost

  16. CIP Cost

Capital Assets Analysis: Explained

This topic provides an overview of the Capital Assets analysis.

Overview

The Capital Assets analysis displays the details of your capital assets.

Key Insights

This report answers the following business questions:

  • Which assets are built and placed in service?

  • Which assets don't have a complete asset definition?

  • What's the total cost of each asset?

Frequently Asked Questions

The following table lists frequently asked questions about this report.

FAQ Answer

How do I find this report?

Reports and Analytics pane - Shared Folders - Projects - Project Financials Sample Reports

Who uses this report?

Project Accountant

When do I use this report?

When you need to:

  • Review the assets created for a project.

  • Ensure that all assets are defined and that the asset attributes are correct.

What can I do with this report?

You can review:

  • Actual asset in-service date

  • Number of asset units

  • Total asset cost

What type of report is this?

Oracle Transactional Business Intelligence

Related Subject Area

This report uses the Project Costing - Assets Real Time subject area.

Report Details

The following table lists the selected columns, underlying formulas, and customized column properties for the report.

Selected Column Source and Customized Properties

Asset Number

"Project Asset"."Asset Number"

Asset Name

"Project Asset"."Asset Name"

Asset Key

"Project Asset"."Asset Id"

Asset Category

"Project Asset"."Asset Category"

Asset Book

"Project Asset"."Asset Book Name"

Book Currency

"Project Asset"."Asset Book Currency"

Standard Unit Cost

"Project Asset"."Asset Category Standard Unit Cost"

Asset Type

"Project Asset"."Asset Type"

Estimated In-Service Date

"Project Asset"."Estimated In Service Date"

Actual In-Service Date

"Project Asset"."Placed in Service Date"

Estimated Units

  • "Asset Measures"."Estimated Asset Units"

  • Value suppression: Repeat

Actual Units

  • "Asset Measures"."Actual Asset Units"

  • Value suppression: Repeat

Estimated Asset Cost

  • "Asset Measures"."Estimated Asset Cost"

  • Value suppression: Repeat

Currency

"Currency Exchange Details"."Apps Common Currency Code"

Total Asset Cost

  • "Asset Line Measures"."Rounded Grouped Cost"

  • Value suppression: Repeat

The following table lists the prompts and filters used in the report.

Filter on Column Type Rules

Project Number

Dashboard prompt

  • Choice list

  • Required

  • Select multiple values enabled

  • Default selection SQL:

    select min("Project"."Project Number") from "Project Costing - Assets Real Time"

Task Number

Dashboard prompt

  • Choice list

  • Select multiple values enabled

Task Name

Dashboard prompt

  • Choice list

  • Select multiple values enabled

Asset Category

Dashboard prompt

  • Choice list

  • Select multiple values enabled

The following table lists the views in the report.

View Displayed Information

View Name

Capital Assets

View Sections

None

Table Column and Measures

  1. Asset Category

  2. Asset Type

  3. Asset Number

  4. Asset Key

  5. Asset Name

  6. Estimated In-Service Date

  7. Actual In-Service Date

  8. Asset Book

  9. Book Currency

  10. Estimated Units

  11. Actual Units

  12. Currency

  13. Standard Unit Cost

  14. Estimated Asset Cost

  15. Total Asset Cost

Noncapitalizable Cost for Capitalizable Tasks Analysis: Explained

This topic provides an overview of the Noncapitalizable Cost for Capitalizable Tasks analysis.

Overview

The Noncapitalizable Cost for Capitalizable Tasks analysis displays the noncapitalizable cost for your capitalizable project tasks.

Key Insights

This report answers the following business questions:

  • What are the total costs for my capitalizable tasks?

  • What percentage of my task costs is not capitalizable?

Frequently Asked Questions

The following table lists frequently asked questions about this report.

FAQ Answer

How do I find this report?

Reports and Analytics pane - Shared Folders - Projects - Project Financials Sample Reports

Who uses this report?

Project Accountant

When do I use this report?

When you need to:

  • Review charges that are expensed for capitalizable tasks.

  • Ensure that costs are classified correctly and that expenses charged to the task are appropriate.

What can I do with this report?

You can review:

  • Total costs for your project tasks.

  • Percentage of total task costs that's not capitalizable.

What type of report is this?

Oracle Transactional Business Intelligence

Related Subject Area

This report uses the Project Costing - Assets Real Time subject area.

Report Details

The following table lists the selected columns underlying formulas, and customized column properties for the report.

Selected Column Source and Customized Properties

Expenditure Task Number

"Task"."Task Number"

Expenditure Task Name

"Task"."Task Name"

Task Manager

"Task"."Task Manager Name"

Expenditure Type

"Expenditure Type"."Resource Type Name"

Currency

"Currency Exchange Details"."Apps Common Currency Code"

Expense Cost

  • "Cost Distribution Measures"."Noncapitalizable Cost"

  • Value suppression: Repeat

Total Task Cost

  • "Cost Distribution Measures"."Cost"

  • Value suppression: Repeat

Percent of Total Cost

  • Formula customized as:

    "Cost Distribution Measures"."Noncapitalizable Cost"/"Cost Distribution Measures"."Cost"

  • Value suppression: Repeat

  • Data format: Percentage

Expenditure Organization

"Expenditure Item"."Expenditure Organization"

Transaction Number

"Expenditure Item"."Expenditure Item"

Transaction Date

  • "Expenditure Item"."Expenditure Item Date"

  • Custom date format: d-MMM-yyyy h:mm t

The following table lists the prompts and filters used in the report.

Filter on Column Type Rules

Project Number

Dashboard prompt

  • Choice list

  • Required

  • Select multiple values enabled

  • Default selection SQL:

    select min("Project"."Project Number") from "Project Costing - Assets Real Time"

  • Default value: Burd_2701Proj

Expenditure Organization

Dashboard prompt

  • Choice list

  • Select multiple values enabled

Project Accounting Period

Dashboard prompt

  • Choice list

  • Required

  • Select multiple values enabled

Project Name

Filter

Prompted

The following table lists the views in the report.

View Displayed Information

View Name

Noncapitalized Cost for Capitalizable Tasks

View Sections

None

Table Column and Measures

  1. Transaction Date

  2. Expenditure Organization

  3. Task Manager

  4. Expenditure Task Number

  5. Expenditure Task Name

  6. Transaction Number

  7. Expenditure Type

  8. Currency

  9. Expense Cost

  10. Total Task Cost

  11. Percent of Total Cost

Capital Expenditures Analysis: Explained

This topic provides an overview of the Capital Expenditures analysis.

Overview

The Capitalizable Expenditures analysis displays the capital expenditure items for your assets.

Key Insights

This report answers the following business questions:

  • What's the total capitalized cost of my assets?

  • How's an expenditure item allocated across assets?

  • Which cost distributions are included in an asset line?

  • Which assets are assigned to a task?

  • Which assets aren't assigned?

Frequently Asked Questions

The following table lists frequently asked questions about this report.

FAQ Answer

How do I find this report?

Reports and Analytics pane - Shared Folders - Projects - Project Financials Sample Reports

Who uses this report?

Project Manager

When do I use this report?

When you need to:

  • View and understand where expenditures are in the capitalization process.

  • Identify activities that must be performed or issues that must be addressed.

What can I do with this report?

You can review the following for your assets:

  • Ungrouped cost

  • Unassigned cost

  • Assigned cost

  • Transferred cost

  • Capitalized cost

What type of report is this?

Oracle Transactional Business Intelligence

Related Subject Area

This report uses the Project Costing - Assets Real Time subject area.

Report Details

The following table lists the selected columns, underlying formulas, and customized column properties for the report.

Selected Column Source and Customized Properties

Expenditure Task Number

"Task"."Task Number"

Expenditure Task Name

"Task"."Task Name"

Expenditure Type

"Expenditure Type"."Resource Type Name"

Transaction Number

"Expenditure Item"."Expenditure Item"

Distribution Line Number

"Cost Distribution Line"."Distribution Line Num"

Capital Event Number

"Capital Event"."Capital Event Number"

Asset Line Number

"Project Asset Line"."Project Asset Line Id#1"

Asset Period

"Project Asset Line"."FA Period Name"

Asset Number

"Project Asset"."Asset Number"

Currency

"Currency Exchange Details"."Apps Common Currency Code"

Ungrouped Cost

  • "Cost Distribution Measures"."Common Capitalizable Cost"

  • Value suppression: Repeat

Unassigned Cost

  • "Asset Line Measures"."Unrounded Unassigned CIP Cost"

  • Value suppression: Repeat

Assigned Cost

  • "Asset Line Measures"."Unrounded Assigned CIP Cost"

  • Value suppression: Repeat

Transferred Cost

  • "Asset Line Measures"."Unrounded Transferred CIP Cost"

  • Value suppression: Repeat

Capitalized Cost

  • "Asset Line Measures"."Unrounded Capitalized Cost"

  • Value suppression: Repeat

The following table lists the prompts and filters used in the report.

Filter on Column Type Rules

Project Number

Dashboard prompt

  • Choice list

  • Required

  • Select multiple values enabled

  • Default selection SQL

    select min("Project"."Project Number") from "Project Costing - Assets Real Time"

Project Name

Filter

Prompted

Task Number

Dashboard prompt

  • Choice list

  • Select multiple values enabled

Task Name

Dashboard prompt

  • Choice list

  • Select multiple values enabled

Project Accounting Period Name

Dashboard prompt

  • Choice list

  • Required

  • Select multiple values enabled

The following table lists the views in the report.

View Displayed Information

View Name

Capital Expenditures

View Sections

None

Table Column and Measures

  1. Expenditure Task Number

  2. Expenditure Task Name

  3. Expenditure Type

  4. Transaction Number

  5. Distribution Line Number

  6. Capital Event Number

  7. Asset Line Number

  8. Asset Period

  9. Asset Number

  10. Currency

  11. Ungrouped Cost

  12. Unassigned Cost

  13. Assigned Cost

  14. Transferred Cost

  15. Capitalized Cost

CIP Account Analysis: Explained

This topic provides an overview of the Construction-In-Process Account Analysis.

Overview

The CIP Account Analysis displays capitalizable costs by the construction-in-process account. You can use this analysis to reconcile costs with the general ledger.

Key Insights

The report answers the following business questions:

  • Do the capitalizable costs in Oracle Fusion Project Costing reconcile with the account balances in the general ledger?

  • What are the CIP assets assigned to a project?

  • What's the total cost of the CIP assets?

Frequently Asked Questions

The following table lists frequently asked questions about this report.

FAQ Answer

How do I find this report?

Report and Analytics pane - Shared Folders - Projects - Project Financial Sample Reports

Who uses this report?

Project Accountant

When do I use this report?

When you need to view the details of the construction-in-process assets.

What can I do with this report?

You can:

  • View all project costs charged to a CIP account.

  • Reconcile CIP balances with the general ledger.

  • Investigate discrepancies within a CIP account.

  • Provide supporting documentation of CIP accounts to internal and external auditors.

What type of report is this?

Oracle Transactional Business Intelligence

Related Subject Area

This report uses the Project Costing - Assets Real Time subject area.

Report Details

The following table lists the selected columns, underlying formula, and customized column properties for the report.

Selected Column Source and Customized Properties

CIP Balancing Segment

"Balancing Segment"."Balancing Segment Code"

CIP Cost Center

"Cost Center"."Cost Center Code"

CIP Natural Account

"Natural Account"."Account Code"

CIP Account

"General Ledger Account"."Concatenated Segments"

Legal Entity

"Expenditure Item"."Expenditure Item Provider Legal Entity Name"

Transaction Number

"Expenditure Item"."Expenditure Item"

Transaction Date

"Expenditure Item"."Expenditure Item Date"

Project Number

"Project"."Project Number"

Project Name

"Project"."Project Name"

Task Number

"Task"."Task Number"

Task Name

"Task"."Task Name"

Cost Distribution Line

  • "Cost Distribution Line"."Distribution Line Num"

  • Value Suppression: Repeat

Asset Number

"Project Asset"."Asset Number"

Currency

  • "Currency Exchange Details"."Apps Common Currency Code"

  • Value Suppression: Repeat

Cost

  • IFNULL("Asset Line Measures"."Unrounded Grouped Cost",0)

  • Value Suppression: Repeat

The following table lists the prompts and filters used in the report.

Filter on Column Type Rules

Expenditure Business Unit

Dashboard prompt

  • Choice list

  • Select multiple values enabled

  • Default selection SQL:

    SELECT MIN("Expenditure Item"."Expenditure Business Unit Name") FROM "Project Costing - Assets Real Time" FETCH FIRST 65001 ROWS ONLY

Project Number

Dashboard prompt

  • Choice list

  • Select multiple values enabled

CIP Account

Dashboard prompt

  • Choice list

  • Select multiple values enabled

CIP Company

Dashboard prompt

  • Choice list

  • Select multiple values enabled

CIP Cost Center

Dashboard prompt

  • Choice list

  • Select multiple values enabled

CIP Natural Account

Dashboard prompt

  • Choice list

  • Select multiple values enabled

Accounting Period

Dashboard prompt

  • Choice list

  • Select multiple values enabled

  • Default selection SQL:

    SELECT MAX("Projects Calendar"."Project Period")FROM "Project Costing - Assets Real Time" FETCH FIRST 65001 ROWS ONLY

The following table lists the views in the report.

View Displayed Information

View Name

CIP Account Analysis

View Sections

None

Table Column and Measures

  1. CIP Balancing Segment

  2. CIP Cost Center

  3. CIP Natural Account

  4. CIP Account

  5. Legal Entity

  6. Project Name

  7. Project Number

  8. Task Number

  9. Task Name

  10. Transaction Number

  11. Transaction Date

  12. Cost Distribution Line

  13. Asset Number

  14. Currency

  15. Cost

Project Costing - Assets Real Time Measures: Explained

This topic provides an overview of the measures available in the Project Costing - Assets Real Time subject area. The measures are populated when accounting currency is set as the preferred currency in Oracle Transactional Business Intelligence.

Cost Distribution Line Measures

The following measures appear in the ledger currency. Similar measures are available for the transaction currency.

Measure Description

Cost

Raw cost if raw cost is capitalized. Total burdened cost if burdened cost is capitalized.

Raw Cost

Raw cost of the cost distribution.

Burden Cost

Burden cost of the cost distribution.

Noncapitalizable Cost

Raw cost if the expenditure item is noncapitalizable and raw cost is capitalized. Total burdened cost if the expenditure item is noncapitalizable and burdened cost is capitalized.

Capitalizable Cost

Raw cost if the expenditure item is capitalizable and raw cost is capitalized. Total burdened cost if the expenditure item is capitalizable and burdened cost is capitalized.

Common Capitalizable Cost

Capitalizable cost that's charged to a task or project where the asset grouping level type is Common Costs.

Ungrouped Capitalizable Cost

Capitalizable cost that's not grouped into an asset line. The total noncapitalized or CIP amount of a cost distribution line is the sum of the cost distribution Ungrouped Capitalizable Cost and the asset line Grouped CIP Cost.

Asset Line Measures

The following measures appear in the ledger currency. Measures are available for both rounded and unrounded costs. The rounded amounts are rounded to 2 decimal places.

Measure Description

Original Asset Cost

Cost of the asset line before it's split.

Grouped Cost

Current cost of the asset line after it's split. This measure includes CIP and capitalized costs.

Grouped CIP Cost

Current cost of the asset line that's not capitalized in Oracle Fusion Assets. This measure includes amounts that are transferred to Oracle Fusion Assets but aren't capitalized. The total CIP amount of a cost distribution line is the sum of the cost distribution Ungrouped Capitalizable Cost and the asset line Grouped CIP Cost.

Unassigned CIP Cost

Current cost of a common cost asset line that's not allocated to an asset.

Assigned CIP Cost

Current cost of the asset line that's assigned to an asset but not transferred to Oracle Fusion Assets.

Transferred CIP Cost

Current cost of the asset line that's transferred to Oracle Fusion Assets but not capitalized.

Rejected CIP Cost

Current cost of the asset line that was transferred to Oracle Fusion Assets but rejected.

Capitalized Cost

Current cost of the asset line that's transferred and capitalized in Oracle Fusion Assets.

Project Billing

Invoices by Status Analysis: Explained

This topic provides an overview of the Invoices by Status analysis.

Overview

The Invoices by Status analysis displays invoices for the selected billing type, accounting period, and invoice status. Results are ordered by invoice date, contract number, and invoice number. You can drill down to the invoice lines and invoiced transactions from this analysis.

Key Insights

This report answers the following business questions:

  • Which invoices need attention?

  • What are the invoice line details for a particular invoice?

  • Which transactions are included in the invoice?

Frequently Asked Questions

The following table lists the frequently asked questions about this report.

FAQ Answer

How do I find this report?

Reports and Analytics - Shared Folders - Projects - Project Financials Sample Reports

Who uses this report?

  • Grants Accountant

  • Project Billing Specialist

When do I use this report?

When there's an invoice which needs attention.

What can I do with this report?

You can:

  • View invoices in this analysis by:

    • Accounting Period

    • Billing Type

    • Invoice Status

  • Drill down to the:

    • Project Billing - Invoice Lines analysis using the Invoice Amount column.

    • Project Billing - Invoiced Transactions analysis using the Invoice Amount column.

What type of report is this?

Oracle Transactional Business Intelligence

Related Subject Area

This report uses the Project Billing - Invoices Real Time subject area.

Report Details

The following table lists the selected columns, underlying formulas, and customized column properties for the report.

Selected Column Source and Customized Properties

Invoice Date

"- Invoice Dates"."Invoice Date"

Contract Number

"Project Contract Header Details"."Contract Number"

Invoice Number

  • "Invoice Details"."Invoice Number"

  • Action link to the Project Billing - Invoice Lines analysis

Invoice Status

"Invoice Details"."Invoice Status"

Receivables Invoice Number

"Invoice Details"."AR Invoice Number"

Bill-to Customer

"- Bill-to Customer Details"."Billed Account Name"

Invoice Type

"Invoice Details"."Invoice Type"

Credit Invoice Number

Formula customized as:

IFNULL("Credits and Write-offs"."Header Credit Invoice Number",'')

Invoice Amount

  • Formula customized as:

    IFNULL("Invoice Transaction Measures"."External Project Invoice Amount in Invoice Currency", IFNULL("Invoice Transaction Measures"."Intercompany Invoice Amount in Invoice Currency", IFNULL("Invoice Transaction Measures"."Interproject Invoice Amount in Invoice Currency", 0)))

  • Action link to the:

    • Project Billing - Invoice Lines analysis

    • Project Billing - Invoiced Transactions analysis

Invoice Currency

"Currency Exchange Details"."Apps Document Currency Code"

Billing Type

  • "Invoice Details"."Project Billing Type Code"

  • Excluded from view

Accounting Period Name

  • "Fiscal Calendar"."Fiscal Period"

  • Excluded from view

The following table lists the prompts and filters used in the report.

Filter on Column Type Rules

Billing Type

Dashboard prompt

  • Choice list

  • Select multiple values enabled

  • Default selection: All values

Accounting Period

Dashboard prompt

  • Choice list

  • Values limited by All Prompts

  • Select multiple values enabled

  • Default selection: All values

Invoice Status

Dashboard prompt

  • Choice list

  • Values limited by All Prompts

  • Select multiple values enabled

  • Default selection: All values

The following table lists the views in the report.

View Displayed Information

View Name

Project Billing - Invoices by Status

View Sections

None

Table Column and Measures

  1. Invoice Date

  2. Contract Number

  3. Invoice Number

  4. Invoice Status

  5. Receivables Invoice Number

  6. Bill-to Customer

  7. Invoice Type

  8. Credit Invoice Number

  9. Invoice Amount

  10. Invoice Currency

Project Billing Events Analysis: Explained

This topic provides an overview of the Project Billing Events analysis.

Overview

The Project Billing Events analysis displays the project contract billing events at an individual transaction level.

Key Insights

This report answers the following business questions:

  • Which are the billing events for a project or contract and contract line?

  • Which billing events are missing an event completion date?

Frequently Asked Questions

FAQ Answer

How do I find this report?

Reports and Analytics - Shared Folders - Projects - Project Financials Sample Reports

Who uses this report?

Project Manager

When do I use this report?

When you need to know the details of the billing events for a project or contract.

What can I do with this report?

You can:

  • View the billing event details for different invoice and revenue statuses.

  • View the billing details based on the billing event completion date.

  • Drill down to the Project Billing - Invoiced Transactions Analysis using the Invoiced Amount column.

  • Drill down to the Project Revenue - Recognized Transactions Analysis using the Recognized Amount column.

What type of report is this?

Oracle Transactional Business Intelligence

Related Subject Area

This report uses the Project Billing - Event Real Time subject area.

Report Details

The following table lists the selected columns, underlying formulas, and customized column properties for the report.

Selected Column Source and Customized Properties

Event Completion Date

  • "Event Details"."Completion Date"

  • Column data displayed in custom date format as M/d/yy h:mm t

Event Type

"Event Details"."Event Type"

Revenue Status

"Event Details"."Event Revenue Status"

Invoice Status

"Event Details"."Event Invoice Status"

Project Number

"Project"."Project Number"

Contract Number

"Project Contract Header Details"."Contract Number"

Event Amount

  • Formula customized as:

    IFNULL("Billing Event Measures"."Event Amount", 0)

  • Value suppression: Repeat

  • Column data displayed in number format with negative values allowed

Invoiced Amount

  • Formula customized as:

    IFNULL("Billing Event Measures"."Invoiced Amount in Contract Currency", 0)

  • Value suppression: Repeat

  • Column data displayed in number format with negative values allowed

  • Action link to the Project Billing - Invoiced Transactions Analysis using the Invoiced Amount column.

Recognized Amount

  • Formula customized as:

    IFNULL("Billing Event Measures"."Recognized Revenue in Contract Currency", 0)

  • Value suppression: Repeat

  • Column data displayed in number format with negative values allowed

  • Action link to the Project Revenue - Recognized Transactions Analysis using the Recognized Amount column.

Unbilled Amount

  • Formula customized as:

    IfNull("Billing Event Measures"."Unbilled Event Amount in Contract Currency",0)

  • Value suppression: Repeat

  • Column data displayed in number format with negative values allowed

Unrecognized Amount

  • Formula customized as:

    IfNull("Billing Event Measures"."Unrecognized Event Amount in Contract Currency",0)

  • Value suppression: Repeat

  • Column data displayed in number format with negative values allowed

Contract Currency

"Currency Exchange Details"."Apps Common Currency Code"

Contract Line Number

"Project Contract Line Details"."Contract Line Number"

Task Number

"Task"."Task Number"

Use for Invoices

"Event Type"."Event Type Invoice Flag"

Use for Revenue

"Event Type"."Event Type Revenue Flag"

The following table lists the prompts and filters used in the report.

Column Type Rules

Business Unit

Dashboard prompt

  • Choice list

  • Select multiple values enabled

  • Default selection: All values

Event Usage

Dashboard prompt

  • Choice list

  • Default selection: Custom Values

Invoice Status

Dashboard prompt

  • Choice list

  • Select multiple values enabled

  • Default selection: All values

Revenue Status

Dashboard prompt

  • Choice list

  • Select multiple values enabled

  • Default selection: All values

Completion Date On or Before

Dashboard prompt

  • Calendar

  • Default selection SQL Results:

    SELECT MAX("Event Details"."Completion Date") FROM "Project Billing - Event Real Time"

The following table lists the views in the report.

View Displayed Information

View Name

Project Billing Events Analysis

View Sections

None

Table Column and Measures

  1. Contract Number

  2. Contract Line Number

  3. Project Number

  4. Task Number

  5. Use for Invoices

  6. Use for Revenue

  7. Revenue Status

  8. Event Type

  9. Event Completion Date

  10. Event Amount

  11. Contract Currency

  12. Invoiced Amount

  13. Unbilled Amount

  14. Recognized Amount

  15. Unrecognized Amount

Project Billing - Invoiced Transactions Analysis: Explained

This topic provides an overview of the Project Billing - Invoiced Transactions analysis.

Overview

The Project Billing - Invoiced Transactions analysis lists invoiced transactions for an invoice line in the Invoice Lines analysis. The results are ordered by contract line number and transaction number. You can drill down to the Project Billing - Invoiced Transactions analysis by clicking on the Invoice Amount column data on the Invoices by Status analysis.

Key Insights

This report answers the following business question:

What are the transactions for an invoice line?

Frequently Asked Questions

The following table lists frequently asked questions about this report.

FAQ Answer

How do I find this report?

Reports and Analytics pane - Shared Folders - Projects - Project Financials Sample Reports - Invoices by Status

Who uses this report?

  • Grants Accountant

  • Project Billing Specialist

When do I use this report?

When you need to review the transactions for an invoice line.

What can I do with this report?

Review invoiced transactions.

What type of report is this?

Oracle Transactional Business Intelligence

Related Subject Area

This report uses the Project Billing - Invoices Real Time subject area.

Report Details

The following table lists the selected columns, underlying formulas, and customized column properties for the report.

Selected Column Source and Customized Properties

Contract Number

"Project Contract Header Details"."Contract Number"

Invoice Number

"Invoice Details"."Invoice Number"

Invoice Line Number

"Invoice Details"."Invoice Line Number"

Contract Line Number

"Project Contract Line Details"."Contract Line Number"

Transaction Type

"Invoice Calculation"."Distribution Bill Transaction Type Name"

Event Number

"Invoice Calculation"."Event Number"

Expenditure Type

"Expenditure Type"."Resource Type Name"

Person

"Employee"."Employee Name"

Bill Rate

"Invoice Calculation"."Distribution Bill Rate"

Project Number

"Project"."Project Number"

Task Number

"Task"."Task Number"

Invoice Amount

Formula customized as:

IFNULL("Invoice Transaction Measures"."External Project Invoice Amount in Invoice Currency",0)+ IFNULL("Invoice Transaction Measures"."Intercompany Invoice Amount in Invoice Currency",0)+ IFNULL("Invoice Transaction Measures"."Interproject Invoice Amount in Invoice Currency",0)

Invoice Currency

"Currency Exchange Details"."Apps Document Currency Code"

The following table lists the prompts and filters used in the report.

Filter on Column Type Rules

Contract Number

Filter

Prompted

Billing Type

Filter

Prompted

Accounting Period Name

Filter

Prompted

Invoice Status

Filter

Prompted

The following table lists the views in the report.

View Displayed Information

View Name

Invoiced Transactions

View Sections

None

Table Column and Measures

  1. Contract Number

  2. Contract Line Number

  3. Invoice Number

  4. Invoice Line Number

  5. Transaction Type

  6. Event Number

  7. Expenditure Type

  8. Person

  9. Bill Rate

  10. Project Number

  11. Task Number

  12. Invoice Amount

  13. Invoice Currency

Project Billing - Invoice Lines Analysis: Explained

This topic provides an overview of the Project Billing - Invoice Lines analysis.

Overview

The Project Billing - Invoice Lines analysis lists the invoice lines for an invoice included in the Invoices by Status analysis, ordered by invoice line number. You can drill down to the Project Billing - Invoice Lines analysis by clicking on the Invoice Amount column data on the Invoices by Status analysis.

Key Insights

This report answers the following business question:

What are the invoice lines for a particular invoice?

Frequently Asked Questions

The following table lists frequently asked questions about this report.

FAQ Answer

How do I find this report?

Reports and Analytics pane - Shared Folders - Projects - Project Financials Sample Reports - Invoices by Status

Who uses this report?

  • Grants Accountant

  • Project Billing Specialist

When do I use this report?

When you need to review the invoice lines for an invoice.

What can I do with this report?

Review the invoice lines for an invoice.

What type of report is this?

Oracle Transactional Business Intelligence

Related Subject Area

This report uses the Project Billing - Invoices Real Time subject area.

Report Details

The following table lists the selected columns, underlying formulas, and customized column properties for the report.

Selected Column Source and Customized Properties

Contract Number

"Project Contract Header Details"."Contract Number"

Invoice Number

"Invoice Details"."Invoice Number"

Line Number

"Invoice Details"."Invoice Line Number"

Line Description

"Invoice Details"."Invoice Line Description"

Line Type

"Invoice Details"."Invoice Line Type"

Invoice Amount

Formula customized as:

IFNULL("Invoice Transaction Measures"."External Project Invoice Amount in Invoice Currency", IFNULL("Invoice Transaction Measures"."Intercompany Invoice Amount in Invoice Currency", IFNULL("Invoice Transaction Measures"."Interproject Invoice Amount in Invoice Currency", 0)))

Invoice Currency

"Currency Exchange Details"."Apps Document Currency Code"

The following table lists the prompts and filters used in the report.

Filter on Column Type Rules

Contract Number

Filter

Prompted

Accounting Period Name

Filter

Prompted

Billing Type

Filter

Prompted

Invoice Status

Filter

Prompted

The following table lists the views in the report.

Views Name

View Name

Invoice Lines

View Sections

None

Table Column and Measures

  1. Contract Number

  2. Invoice Number

  3. Line Number

  4. Line Description

  5. Line Type

  6. Invoice Amount

  7. Invoice Currency

Project Contracts

Project Contract List Analysis: Explained

This topic provides an overview of the Project Contract List analysis.

Overview

The Project Contract List analysis displays project contracts and contract status for a business unit grouped by customer. You can drill down to project contract lines from this analysis.

Key Insights

This report answers the following business questions:

  • Which project contracts are active for a business unit?

  • Which projects are linked to these contracts?

  • What is the total amount of consumed and remaining contract funds?

  • Who are the contracted customers for a business unit?

Frequently Asked Questions

The following table lists the frequently asked questions about this report.

FAQ Answer

How do I find this report?

Reports and Analytics - Shared Folders - Projects - Project Financials Sample Reports

Who uses this report?

  • Contract Administrator

  • Grants Accountant

  • Project Accountant

  • Project Billing Specialist

  • Project Team Member

When do I use this report?

When you need to view the transactions that contribute to contract funds consumption and the contract line amounts that are invoiced and recognized for revenue.

What can I do with this report?

You can:

  • View contracts in this analysis by:

    • Contract Business Unit

    • Contract Status

  • Drill down to the Project Contract Lines analysis using the Contract Number column.

What type of report is this?

Oracle Transactional Business Intelligence

Related Subject Areas

This report uses the Project Billing - Funding Real Time, Project Billing - Invoices Real Time, and Project Billing - Revenue Real Time subject areas.

Report Details

The following table lists the selected columns, underlying formulas, and customized column properties for the report.

Selected Column Source and Customized Properties

Contract Business Unit

Project Billing - Funding Real Time - Organizations:

"- Contract Business Unit"."Contract Business Unit Name"

Contract Customer Account Name

"Contract Customer Account"."Contract Customer Account Name"

Contract Number

  • "Project Contract Header Details"."Contract Number"

  • Action link to the Project Contract Lines analysis

Contract Status

"Project Contract Header Details"."Contract Status Name"

Contract Start Date

"- Contract Header Dates"."Contract Start Date"

Contract End Date

"- Contract Header Dates"."Contract End Date"

Project Number

"Project"."Project Number"

Contract Header Currency Code

"Project Contract Header Details"."Contract Header Currency Code"

Contract Amount in Contract Currency

Formula customized as:

IFNULL("Project Contract Measures"."Contract Amount", 0)

Revenue in Contract Currency

  • Formula customized as:

    IFNULL("Project Billing - Revenue Real Time"."Revenue Transaction Measures"."Revenue Amount in Contract Currency", 0)

  • Action link to the Project Revenue - Recognized Transactions analysis

Revenue Amount Remaining

  • Calculated measure

  • Formula customized as:

    IFNULL("Project Contract Measures"."Contract Amount", 0)-IFNULL("Project Billing - Revenue Real Time"."Revenue Transaction Measures"."Revenue Amount in Contract Currency", 0)

  • Column data displayed in currency format with 2 decimal places, the 1000s separator enabled, and negative values shown in red.

Invoiced Amount in Contract Currency

  • Formula customized as:

    IFNULL("Project Billing - Invoices Real Time"."Invoice Transaction Measures"."External Project Invoice Amount in Contract Currency",0)+ IFNULL("Project Billing - Invoices Real Time"."Invoice Transaction Measures"."Intercompany Invoice Amount in Contract Currency", 0)+ IFNULL("Project Billing - Invoices Real Time"."Invoice Transaction Measures"."Interproject Invoice Amount in Contract Currency", 0)

  • Action link to the Project Billing - Invoiced Transactions analysis

Contract Funds Available for Invoicing

  • Calculated measure

  • Formula customized as:

    IFNULL("Project Contract Measures"."Contract Amount", 0)- IFNULL("Project Billing - Invoices Real Time"."Invoice Transaction Measures"."External Project Invoice Amount in Contract Currency", 0)+ IFNULL("Project Billing - Invoices Real Time"."Invoice Transaction Measures"."Intercompany Invoice Amount in Contract Currency", 0)+ IFNULL("Project Billing - Invoices Real Time"."Invoice Transaction Measures"."Interproject Invoice Amount in Contract Currency", 0)

The following table lists the prompts and filters used in the report.

Filter on Column Type Rules

Contract Business Unit

Dashboard prompt

  • Choice list

  • Default selection SQL:

    SELECT MIN("- Contract Business Unit"."Contract Business Unit Name") FROM "Project Billing - Funding Real Time"

Contract Status

Dashboard prompt

  • Choice list

  • Default selection specific value: ACTIVE

The following table lists the views in the report.

View Displayed Information

View Name

Project Contracts

View Sections

None

Table Column and Measures

  1. Contract Customer Account Name

  2. Contract Business Unit

  3. Contract Status

  4. Contract Number

  5. Contract Start Date

  6. Contract End Date

  7. Project Number

  8. Contract Header Currency Code

  9. Contract Amount in Contract Currency

  10. Revenue in Contract Currency

  11. Revenue Amount Remaining

  12. Invoiced Amount in Contract Currency

  13. Contracts Funds Available for Invoicing

Project Contract Lines Analysis: Explained

This topic provides an overview of the Project Contract Lines analysis.

Overview

The Project Contract Lines analysis displays a list of all project contract lines for a contract grouped by the customer. You can drill down to the Project Contract Lines analysis by clicking on the Contract Number column data on the Project Contract List analysis.

Key Insights

This report answers the following business questions:

  • Which are the contract lines for a contract?

  • How much of the contract line amount is invoiced and recognized for revenue?

Frequently Asked Questions

The following table lists frequently asked questions about this report.

FAQ Answer

How do I find this report?

Reports and Analytics pane - Shared Folders - Projects - Project Financials Sample Reports - Project Contract List - Project Contract Lines

Who uses this report?

  • Contract Administrator

  • Grants Accountant

  • Project Accountant

  • Project Billing Specialist

  • Project Team Member

When do I use this report?

When you need to review contract lines.

What can I do with this report?

Review contract lines, and invoiced and revenue recognized amounts.

What type of report is this?

Oracle Transactional Business Intelligence

Related Subject Areas

This report uses the Project Billing - Funding Real Time, Project Billing - Invoices Real Time, and Project Billing - Revenue Real Time subject areas.

Report Details

The following table lists the selected columns, underlying formulas, and customized column properties for the report.

Selected Column Source and Customized Properties

Contract Business Unit Name

  • "- Contract Business Unit"."Contract Business Unit Name"

  • Excluded from view

Contract Number

"Project Contract Header Details"."Contract Number"

Contract Line Type Name

"Project Contract Line Details"."Contract Line Type Name"

Contract Line Status Name

"Project Contract Line Details"."Contract Line Status Name"

Contract Line Number

"Project Contract Line Details"."Contract Line Number"

Contract Line Name

"Project Contract Line Details"."Contract Line Name"

Contract Line Description

"Project Contract Line Details"."Contract Line Description"

Contract Line Start Date

"- Contract Line Dates"."Contract Line Start Date"

Contract Line End Date

"- Contract Line Dates"."Contract Line DateTerminated"

Project Number

"Project"."Project Number"

Contract Header Currency Code

"Project Contract Header Details"."Contract Header Currency Code"

Contract Amount

  • Formula customized as:

    IFNULL("Project Contract Measures"."Contract Amount", 0)

  • Column data displayed in currency format with 2 decimal places, the 1000s separator enabled and negative values shown in red.

Revenue Amount in Contract Currency

  • Formula customized as:

    IFNULL("Project Billing - Revenue Real Time"."Revenue Transaction Measures"."Revenue Amount in Contract Currency", 0)

  • Action link to the Project Revenue - Recognized Transactions analysis

Revenue Amount Remaining

  • Calculated Measure

  • Formula customized as:

    IFNULL("Project Contract Measures"."Contract Amount", 0)-IFNULL("Project Billing - Revenue Real Time"."Revenue Transaction Measures"."Revenue Amount", 0)

Invoice Amount in Contract Currency

  • Formula customized as:

    IFNULL("Project Billing - Invoices Real Time"."Invoice Transaction Measures"."External Project Invoice Amount in Contract Currency",IFNULL("Project Billing - Invoices Real Time"."Invoice Transaction Measures"."Intercompany Invoice Amount in Contract Currency", IFNULL("Project Billing - Invoices Real Time"."Invoice Transaction Measures"."Interproject Invoice Amount in Contract Currency", 0)))

  • Action link to the Project Billing - Invoiced Transactions analysis

Invoice Amount Remaining

  • Calculated Measure

  • Formula customized as:

    IFNULL("Project Contract Measures"."Contract Amount", 0)-IFNULL("Project Billing - Invoices Real Time"."Invoice Transaction Measures"."External Project Invoice Amount in Contract Currency",IFNULL("Project Billing - Invoices Real Time"."Invoice Transaction Measures"."Intercompany Invoice Amount in Contract Currency", IFNULL("Project Billing - Invoices Real Time"."Invoice Transaction Measures"."Interproject Invoice Amount in Contract Currency", 0)))

The following table lists the prompts and filters used in the report.

Filter on Column Type Rules

Contract Number

Filter

Prompted

The following table lists the views in the report.

View Displayed Information

View Name

Project Contract Lines

View Sections

None

Table Column and Measures

  1. Contract Number

  2. Contract Line Number

  3. Contract Line Name

  4. Contract Line Status Name

  5. Contract Line Type Name

  6. Project Number

  7. Contract Line Start Date

  8. Contract Line End Date

  9. Contract Line Description

  10. Contract Header Currency Code

  11. Contract Amount

  12. Invoice Amount in Contract Currency

  13. Invoice Amount Remaining

  14. Revenue Amount in Contract Currency

  15. Revenue Amount Remaining

Project Costs

Project Cost by Transaction Source Analysis: Explained

This topic provides an overview of the Project Cost by Transaction Source analysis.

Overview

The Project Cost by Transaction Source analysis displays project cost transactions grouped by transaction source. You can drill down to project cost transaction source details from this analysis.

Key Insights

This report answers the following business question:

How much does each transaction source contribute to project costs?

Frequently Asked Questions

The following table lists the frequently asked questions about this report.

FAQ Answer

How do I find this report?

Reports and Analytics - Shared Folders - Projects - Project Financials Sample Reports

Who uses this report?

  • Grants Accountant

  • Project Accountant

When do I use this report?

When you need to determine the contribution of each transaction source to the project cost.

What can I do with this report?

You can:

  • View project cost transactions by:

    • Expenditure Category

    • Expenditure Item Dates

    • Project Business Unit

    • Project Name

    • Transaction Source

  • Drill down to the Project Cost by Transaction Source Details analysis using the Cost column.

What type of report is this?

Oracle Transactional Business Intelligence

Related Subject Area

This report uses the Project Costing - Actual Costs Real Time subject area.

Report Details

The following table lists the selected columns, underlying formulas, and customized column properties for the report.

Selected Column Source and Customized Properties

Project Business Unit

"Project"."Project Business Unit"

Project Number

Formula customized as:

TRIM(BOTH FROM "Project"."Project Number")

Project Name

  • Formula customized as:

    TRIM(BOTH FROM "Project"."Project Name")

  • Excluded from view

Project Status

  • "Project"."Current Project Status Name"

  • Excluded from view

Transaction Source

"Original Source References"."Transaction Source Name"

Currency Type

Formula customized as:

CASE WHEN VALUEOF(NQ_SESSION.PREFERRED_CURRENCY) = 'Local Currency' THEN 'Ledger Currency' WHEN VALUEOF(NQ_SESSION.PREFERRED_CURRENCY) = 'Document Currency' THEN 'Transaction Currency' ELSE VALUEOF(NQ_SESSION.PREFERRED_CURRENCY) END

Currency Code

"Currency Exchange Details"."Apps Common Currency Code"

Total Burdened Cost

  • "- Expenditure Item and Cost Distribution Measures"."Cost"

  • Action link to the Project Cost by Transaction Source Details analysis

The following table lists the prompts and filters used in the report.

Filter on Column Type Rules

Project Business Unit

Dashboard prompt

  • Choice list

  • Select multiple values enabled

  • Default selection: All values

Project Number

Dashboard prompt

  • Choice list

  • Select multiple values enabled

  • Default selection: All values

Transaction Source

Dashboard prompt

  • Choice list

  • Select multiple values enabled

  • Default selection: All values

Expenditure Category

Dashboard prompt

  • Choice list

  • Select multiple values enabled

  • Default selection: All values

Expenditure Item Date

Dashboard prompt

Is between calendar

The following table lists the views in the report.

View Displayed Information

View Name

Project Cost by Transaction Source Summary

View Type

Pivot table

Pivot Column

Transaction Source

Table Column and Measures

  1. Project Business Unit

  2. Project Name

  3. Project Currency

  4. Cost

Project Cost by Transaction Source Details Analysis: Explained

This topic provides an overview of the Project Cost by Transaction Source Details analysis.

Overview

The Project Cost by Transaction Source Details analysis displays individual transactions that add up to the project summary cost amounts and pertinent transaction information that helps you to make informed analyses. You can drill down to the Project Cost by Transaction Source Details analysis by clicking on the Cost column data on the Project Cost by Transaction Source analysis.

Key Insights

This report answers the following business question:

Which transactions contribute to the total cost of my projects?

Frequently Asked Questions

The following table lists frequently asked questions about this report.

FAQ Answer

How do I find this report?

Reports and Analytics pane - Shared Folders - Projects - Project Financials Sample Reports - Project Cost by Transaction Source

Who uses this report?

  • Grants Accountant

  • Project Accountant

When do I use this report?

When you need to determine the contribution of each transaction source to the project cost.

What can I do with this report?

Review individual cost transactions that contribute to your project cost.

What type of report is this?

Oracle Transactional Business Intelligence

Related Subject Area

This report uses the Project Costing - Actual Costs Real Time subject area.

Report Details

The following table lists the selected columns, underlying formulas, and customized column properties for the report.

Selected Column Source and Customized Properties

Project Business Unit

  • "Project"."Project Business Unit"

  • Excluded from view

Project Number

Formula customized as:

TRIM(BOTH FROM "Project"."Project Number")

Project Name

  • "Project"."Project Name"

  • Excluded from view

Task Number

"Task Hierarchy"."Base Task Number"

Task Name

  • Formula customized as:

    IFNULL("Task Hierarchy"."Base Level Task Name", '')

  • Excluded from view

Transaction Source

"Original Source References"."Transaction Source Name"

Transaction Number

"Expenditure Item"."Expenditure Item"

Expenditure Type

"Expenditure Type"."Resource Type Name"

Expenditure Category

"Expenditure Type"."Expenditure Category Name"

Document

"Original Source References"."Document"

Document Entry

"Original Source References"."Document Entry"

Expenditure Item Date

"Expenditure Item and Cost Distribution Details"."Expenditure Item Date"

Currency Code

"Currency Exchange Details"."Apps Common Currency Code"

Burdened Cost

"- Expenditure Item and Cost Distribution Measures"."Cost"

The following table lists the prompts and filters used in the report.

Filter on Column Type Rules

TRIM(BOTH FROM Project Number)

Filter

Prompted

Transaction Source

Filter

Prompted

The following table lists the views in the report.

View Displayed Information

View Name

Project Cost by Transaction Source Details Drilldown

View Type

Table

Table Column and Measures

  1. Project Number

  2. Task Number

  3. Transaction Source

  4. Document

  5. Document Entry

  6. Expenditure Category

  7. Expenditure Type

  8. Transaction Number

  9. Expenditure Item Date

  10. Currency Code

  11. Burdened Cost

Project Cost Account Reconciliation Analysis: Explained

This topic provides an overview of the Project Cost Account Reconciliation analysis.

Overview

The Project Cost Account Reconciliation analysis displays the expenditure items that are posted to the selected GL accounts. This analysis helps to reconcile account balance discrepancies between Oracle Fusion General Ledger and Oracle Fusion Project Costing.

Key Insights

This report answers the following business question:

How can I view project cost reconciliation with GL accounts and investigate reconciliation issues?

Frequently Asked Questions

The following table lists frequently asked questions about this report.

FAQ Answer

How do I find this report?

Reports and Analytics pane - Shared Folders - Projects - Project Financials Sample Reports

Who uses this report?

  • Grants Accountant

  • Project Accountant

When do I use this report?

When account balance discrepancies exist between General Ledger and Project Costing.

What can I do with this report?

You can view specific or financially material transactions by:

  • Account

  • Accounting Class

  • Accounting Period

  • Event Class

  • Ledger Name

  • Project Number

  • Range of Debit Amount

  • Range of Credit Amount

  • Task Number

  • Transaction Number

What type of report is this?

Oracle Transactional Business Intelligence

Related Subject Area

This report uses the Project Costing - Actual Costs Real Time subject area.

Report Details

The following table lists the selected columns, underlying formulas, and customized column properties for the report.

Selected Column Source and Customized Properties

Ledger

"Ledger"."Ledger Name"

Accounting Period

"GL Accounting Date Fiscal Calendar"."Accounting Period"

Account

"General Ledger Account"."Concatenated Segments"

Event Class

"Cost Accounting Details"."Event Class Name"

Accounting Class

"Accounting Class"."Accounting Class Meaning"

Project Number

"Project"."Project Number"

Task Number

"Task"."Task Number"

Transaction Number

"Expenditure Item"."Expenditure Item"

Distribution Line Number

"Expenditure Item and Cost Distribution Details"."Distribution Line Num"

Ledger Currency

  • "Ledger"."Ledger Currency"

  • Value suppression: Repeat

Debit Amount

  • "- Cost Accounting Transaction Measures"."Unrounded Accounted Debit Amount"

  • Value suppression: Repeat

Credit Amount

  • "- Cost Accounting Transaction Measures"."Unrounded Accounted Credit Amount"

  • Value suppression: Repeat

The following table lists the prompts and filters used in the report.

Filter on Column Type Rules

Ledger Name

Dashboard prompt

  • Choice list

  • Required

  • Default selection SQL:

    SELECT MIN("Ledger"."Ledger Name") FROM "Project Costing - Actual Costs Real Time"

Accounting Period

Dashboard prompt

  • Choice list

  • Required

  • Values limited by Ledger Name

Account

Dashboard prompt

  • Choice list

  • Select multiple values enabled

  • Values limited by Ledger Name

Accounting Class

Dashboard prompt

  • Choice list

  • Select multiple values enabled

  • Values limited by Ledger Name

Event Class

Dashboard prompt

  • Choice list

  • Select multiple values enabled

  • Values limited by Ledger Name

Project Number

Dashboard prompt

  • Choice list

  • Select multiple values enabled

  • Values limited by Ledger Name

Task Number

Dashboard prompt

  • Choice list

  • Select multiple values enabled

  • Values limited by Project Number

Transaction Number

Dashboard prompt

  • Choice list

  • Select multiple values enabled

  • Values limited by Task Number

Debit Amount

Dashboard prompt

Is between text field

Credit Amount

Dashboard prompt

Is between text field

The following table lists the views in the report.

View Displayed Information

View Name

Project Cost Account Reconciliation

View Sections

None

Table Column and Measures

  1. Ledger

  2. Accounting Period

  3. Account

  4. Event Class

  5. Accounting Class

  6. Project Number

  7. Task Number

  8. Transaction Number

  9. Distribution Line Number

  10. Ledger Currency

  11. Debit Amount

  12. Credit Amount

Project Definition

Project List Analysis: Explained

This topic provides an overview of the Project List analysis.

Overview

The Project List analysis displays the projects for a business unit and organization. You can navigate to the Project Tasks analysis from this report.

Key Insights

This report answers the following business questions:

  • Which projects are under a business unit and what are the statuses of these projects?

  • What are the associated tasks for a project?

Frequently Asked Questions

The following table lists frequently asked questions about this report.

FAQ Answer

How do I find this report?

Reports and Analytics pane - Shared Folders - Projects - Project Financials Sample Reports

Who uses this report?

Project Administrator

When do I use this report?

When you need to review projects under a business unit and tasks for a project.

What can I do with this report?

You can:

  • View projects and project statuses by:

    • Project Business Unit

    • Project Organization

    • Project Status

  • Navigate to the Project Tasks analysis.

What type of report is this?

Oracle Transactional Business Intelligence

Related Subject Area

This report uses the Project Control - Budgets Real Time subject area.

Report Details

The following table lists the selected columns, underlying formulas, and customized column properties for the report.

Selected Column Source and Customized Properties

Project Business Unit

  • "Project"."Project Business Unit"

  • Excluded from view

Project Organization

  • "Project"."Organization Name"

  • Excluded from view

Project Number

"Project"."Project Number"

Project Name

"Project"."Project Name"

Project Manager

"Project"."Current Project Manager"

The "Project"."Current Project Manager" source column exists as "Project"."Project Manager" in the BI catalog.

Project Status

"Project"."Current Project Status Name"

The "Project"."Current Project Status Name" source column exists as "Project"."Project Status" in the BI catalog.

Project Type

"-Project Type Attributes"."Project Type Name"

The "-Project Type Attributes"."Project Type Name" source column exists as "-Project Type Attributes"."Project Type" in the BI catalog.

Project Start Date

"-Project Date Attributes". "Project Start Date"

Project Finish Date

"-Project Date Attributes"."Completion Date"

The "-Project Date Attributes"."Completion Date" source column exists as "-Project Date Attributes"."Project Finish Date" in the BI catalog.

Template

  • "-Project Indicator Attributes"."Template Flag"

    The "Project Indicator Attributes"."Template Flag" source column exists as "Project Indicator Attributes"."Template" in the BI catalog.

  • Hidden in view

The following table lists the prompts and filters used in the report.

Filter on Column Type Rules

Project Business Unit

Dashboard prompt

  • Choice list

  • Select multiple values enabled

  • Default selection: All values

Project Organization

Dashboard prompt

  • Choice list

  • Values limited by Project Business Unit

  • Select multiple values enabled

  • Default selection: All values

Project Status

Dashboard prompt

  • Choice list

  • Select multiple values enabled

  • Default selection: All values

Project Number

Dashboard prompt

  • Choice list

  • Select multiple values enabled

  • Default selection: All values

Template

Filter

Equals 'N'

Project Type

Filter

Prompted

The following table lists the views in the report.

View Displayed Information

View Name

Project List

View Sections

Project Tasks

Table Column and Measures

  1. Project Number

  2. Project Name

  3. Project Status

  4. Project Manager

  5. Project Type

  6. Project Start Date

  7. Project Finish Date

Project Tasks Analysis: Explained

This topic provides an overview of the Project Tasks analysis.

Overview

The Project Tasks analysis displays the list of tasks for projects. You can navigate to the Project Tasks analysis from the Project List analysis.

Key Insights

This report answers the following business question:

Which tasks are associated to a project?

Frequently Asked Questions

The following table lists frequently asked questions about this report.

FAQ Answer

How do I find this report?

Reports and Analytics pane - Shared Folders - Projects - Project Financials Sample Reports - Project List

Who uses this report?

Project Administrator

When do I use this report?

When you need to review the tasks for a project.

What can I do with this report?

Review project tasks and task dates.

What type of report is this?

Oracle Transactional Business Intelligence

Related Subject Area

This report uses the Project Control - Budgets Real Time subject area.

Report Details

The following table lists the selected columns, underlying formulas, and customized column properties for the report.

Selected Column Source and Customized Properties

Project Number

"Project"."Project Number"

Task Number

"Task"."Task Number"

Task Name

"Task"."Task Name"

Task Description

"Task"."Task Description"

Planned Start Date

"Task"."Task Start Date"

Planned Finish Date

"Task"."Task Completion Date"

Actual Start Date

"Task"."Actual Start Date"

Actual Finish Date

"Task"."Actual Finish Date"

Estimated Finish Date

"Task"."Estimated Finish Date"

The following table lists the prompts and filters used in the report.

Filter on Column Type Rules

Project Number

Filter

  • Prompted

  • Default value: 0001 PJS CDRM AM

The following table lists the views in the report.

View Displayed Information

View Name

Project Tasks

View Sections

None

Table Column and Measures

  1. Project Number

  2. Task Number

  3. Task Name

  4. Task Description

  5. Planned Start Date

  6. Planned Finish Date

  7. Actual Start Date

  8. Actual Finish Date

  9. Estimated Finish Date

Project Performance

Budget vs Actual Cost Comparison Analysis: Explained

This topic provides an overview of the Budget vs Actual Cost Comparison analysis.

Overview

The Budget vs Actual Cost Comparison analysis displays the comparison of budget and actual costs to analyze variances. Results are grouped by business unit and project currency.

Key Insights

This report answers the following business question:

How do my actual costs compare to my budget costs?

Frequently Asked Questions

The following table lists frequently asked questions about this report.

FAQ Answer

How do I find this report?

Reports and Analytics - Shared Folders - Projects - Project Financials Sample Reports

Who uses this report?

Project Manager

When do I use this report?

When you need to compare the budget and actual costs of a project.

What can I do with this report?

You can view the list of projects by:

  • Project Business Unit

  • Project Manager

What type of report is this?

Oracle Transactional Business Intelligence

Related Subject Areas

This report uses the Project Costing - Actual Costs Real Time and Project Control - Budgets Real Time subject areas.

Report Details

The following table lists the selected columns, underlying formulas, and customized column properties for the report.

Selected Column Source and Customized Properties

Project Business Unit

"Project"."Project Business Unit"

Currency

"Currency Exchange Details"."Apps Common Currency Code"

Project Manager

  • "Project"."Current Project Manager"

  • Ascending sort

Project Number

"Project"."Project Number"

Budget Cost

Formula customized as:

IFNULL("Project Control - Budgets Real Time"."- Budget Cost Measures"."Current Budget Cost", 0)

Actual Cost

Formula customized as:

IFNULL("- Expenditure Item and Cost Distribution Measures"."Cost", 0)

Variance

  • Calculated measure

  • Formula customized as:

    IFNULL("Project Control - Budgets Real Time"."- Budget Cost Measures"."Current Budget Cost",0) - IFNULL("- Expenditure Item and Cost Distribution Measures"."Cost",0)

  • Conditional formatting:

    • If Current Budget Cost < 0, then column data is displayed in number format with 2 decimal places, the 1000s separator enabled, and negative values shown in red.

    • If Current Budget Cost > 0, then column data is displayed in number format with 2 decimal places and the 1000s separator enabled.

The following table lists the prompts and filters used in the report.

Filter on Column Type Rules

Project Business Unit

Dashboard prompt

  • Choice list

  • Required

  • Select multiple values enabled

  • Default selection SQL:

    SELECT MIN("Project"."Project Business Unit") FROM "Project Costing - Actual Costs Real Time"

Project Manager

Dashboard prompt

  • Choice list

  • Values limited by Project Business Unit

  • Select multiple values enabled

  • Default selection: All values

The following table lists the views in the report.

View Displayed Information

View Name

Budget vs Actual Cost Comparison by Business Unit

View Sections

  • Project Business Unit

  • Currency

Table Column and Measures

  1. Project Manager

  2. Project Number

  3. Budget Cost

  4. Actual Cost

  5. Variance

Project Income Statement Analysis: Explained

This topic provides an overview of the Project Income Statement analysis.

Overview

The Project Income Statement analysis displays the comparison of revenue and costs to calculate the net income or loss for a project. This analysis groups revenue by revenue category and expenses by expenditure category.

Key Insights

This report answers the following business questions:

  • Is my project profitable?

  • Can I view my project expense and revenue grouped by expense and revenue categories?

Frequently Asked Questions

The following table lists frequently asked questions about this report.

FAQ Answer

How do I find this report?

Reports and Analytics - Shared Folders - Projects - Project Financials Sample Reports

Who uses this report?

Project Manager

When do I use this report?

When you need to determine if a project is making profit or incurring loss.

What can I do with this report?

You can:

  • Review project expenses and revenue by expense and revenue categories

  • Gain insight into the consolidated financial picture of your project.

  • View income statements by project number

What type of report is this?

Oracle Transactional Business Intelligence

Related Subject Areas

This report uses the Project Billing - Revenue Real Time and Project Costing - Actual Costs Real Time subject areas.

Report Details

The following table lists the selected columns, underlying formulas, and customized column properties for the report.

Selected Column Source and Customized Properties

Project Name

  • "Project"."Project Name"

  • Excluded from view

Project Number

"Project"."Project Number"

Category

"Revenue Details"."Revenue Category"

union joins with

"Expenditure Type"."Expenditure Category Name"

Amount

"Project Billing - Revenue Real Time"."Revenue Transaction Measures"."Revenue Amount"

union joins with

"- Expenditure Item and Cost Distribution Measures"."Cost" * -1

Type

'Revenue'

union joins with

'Expenses'

Income

'Net Income/Loss'

Transaction Number

  • Formula customized as:

    cast("Expenditure Item"."Expenditure Item" as char)

  • Excluded from view

Income Category

  • 'Revenue'

    union joins with

    'Expenses'

  • Descending sort

Amount

"Project Billing - Revenue Real Time"."Revenue Transaction Measures"."Revenue Amount"

union joins with

"- Expenditure Item and Cost Distribution Measures"."Cost"

Currency Code

"Currency Exchange Details"."Apps Common Currency Code"

Currency Type

  • Formula customized as:

    CONCAT(CONCAT(CONCAT(CONCAT ('All amounts displayed in ',CASE WHEN VALUEOF (NQ_SESSION.PREFERRED_CURRENCY) = 'Local Currency' THEN 'Ledger Currency' WHEN VALUEOF (NQ_SESSION.PREFERRED_CURRENCY) = 'Document Currency' THEN 'Transaction Currency' ELSE VALUEOF (NQ_SESSION.PREFERRED_CURRENCY) END),' ('),"Currency Exchange Details"."Apps Common Currency Code"),')')

  • Currency format customized as:

    Currency Type value (Currency Code value)

The following table lists the prompts and filters used in the report.

Filter on Column Type Rules

Project Number

Dashboard prompt

  • Choice list

  • Required

  • Default selection SQL:

    SELECT MIN("Project"."Project Number") FROM "Project Billing - Revenue Real Time"

Project Number

Filter

  • Prompted

  • Default value: PJS CPBF Flow

The following table lists the views in the report.

View Displayed Information

View Name

  • Revenue and Expense

  • Net Income

  • Currency Note

View Sections

Income Category (Revenue and Expense)

Table Column and Measures

  1. Revenue and Expense

    1. Category

    2. Amount

  2. Net Income

    1. Net Income/Loss

  3. Currency Note

    1. Currency Type

Project Revenue

Revenue by Contract Analysis: Explained

This topic provides an overview of the Revenue by Contract analysis.

Overview

The Revenue by Contract analysis displays actual revenue for contracts for a specified billing type, contract business unit, and accounting year ordered by contract number. You can drill down to contract lines and revenue recognized transactions from this analysis using the Revenue in Ledger Currency column.

Key Insights

This analysis answers the following business questions:

  • Which contracts have actual revenue in the current accounting year?

  • Which contracts have the lowest actual revenue in the current accounting period?

  • What is the actual revenue trend for accounting periods in the selected accounting year?

Frequently Asked Questions

The following table lists frequently asked questions about this report.

FAQ Answer

How do I find this report?

Reports and Analytics - Shared Folders - Projects - Project Financials Sample Reports

Who uses this report?

  • Grants Accountant

  • Project Accountant

  • Project Manager

  • Project Team Member

When do I use this report?

When you need to view contracts listed by their actual revenue values.

What can I do with this report?

You can:

  • View contracts in this analysis by:

    • Accounting Year

    • Billing Type

    • Business Unit

  • Drill down to the:

    • Project Revenue - Recognized Transactions analysis using the Revenue in Ledger Currency column.

    • Project Revenue - Contract Lines analysis using the Revenue in Ledger Currency column.

What type of report is this?

Oracle Transactional Business Intelligence

Related Subject Area

This report uses the Project Billing - Revenue Real Time subject area.

Report Details

The following table lists the selected columns, underlying formulas, and customized column properties for the report.

Selected Column Source and Customized Properties

Contract Business Unit

  • "- Contract Business Unit"."Contract Business Unit Name"

  • Total After

Billing Type

  • "Revenue Details"."Revenue Billing Type"

  • Total After

Contract Number

"Project Contract Header Details"."Contract Number"

Contract Name

"Project Contract Header Details"."Contract Name"

Contract Status

"Project Contract Header Details"."Contract Status Name"

Contract Start Date

"- Contract Header Dates"."Contract Start Date"

Contract End Date

"- Contract Header Dates"."Contract End Date"

Last Recognized Date

"- Contract Header Dates"."Contract Header Last Revenue Recognition Date"

Revenue in Ledger Currency

  • "Revenue Transaction Measures"."Revenue Amount"

  • Action link to the

    • Project Revenue - Recognized Transactions analysis

    • Project Revenue - Contract Lines analysis

Ledger Currency Value

  • "Currency Exchange Details"."Apps Common Currency Code"

  • Column added to Measure Labels

Accounting Year

  • Formula customized as:

    CAST("Fiscal Calendar"."Fiscal Year Number" AS char)

  • Column added to Measure Labels

  • Hidden in view

  • Total After

Accounting Period Name

  • "Fiscal Calendar"."Fiscal Period"

  • Ascending sort

  • Column added to Measure Labels

The following table lists the prompts and filters used in the report.

Filter on Column Type Rules

Business Unit

Dashboard prompt

  • Choice list

  • Required

  • Select multiple values enabled

  • Default selection: All values

Accounting Year

Dashboard prompt

  • Choice list

  • Required

  • Select multiple values enabled

  • Default selection server variable: NQ_SESSION.CURRENT_FSCL_YEAR

Billing Type

Dashboard prompt

  • Choice list

  • Required

  • Select multiple values enabled

  • Default selection: All values

CAST("Fiscal Calendar"."Fiscal Year Number" AS char)

Filter

Prompted

The following table lists the views in the report.

View Displayed Information

View Name

Revenue by Contract

View Sections

None

Table Column and Measures

  1. Contract Business Unit

  2. Billing Type

  3. Contract Number

  4. Contract Name

  5. Contract Status

  6. Contract Start Date

  7. Contract End Date

  8. Last Recognized Date

  9. Revenue in Ledger Currency

  10. Ledger Currency

  11. Accounting Period

  12. Accounting Year

Project Revenue - Recognized Transactions Analysis: Explained

This topic provides an overview of the Project Revenue - Recognized Transactions analysis.

Overview

The Project Revenue - Recognized Transactions analysis displays actual revenue for the transactions of the contract or contract line and accounting period selected in the Project Revenue by Contract or Project Revenue - Contract Lines analyses, sectioned by transaction type and ordered by the transaction number or event number. You can drill down to the Project Revenue - Recognized Transactions analysis by clicking on the Revenue in Ledger Currency column data on the Project Revenue by Contract or Project Revenue - Contract Lines analyses.

Key Insights

This report answers the following business question:

Which transactions are recognized for revenue for a contract or contract line in the given accounting period?

Frequently Asked Questions

The following table lists frequently asked questions about this report.

FAQ Answer

How do I find this report?

Reports and Analytics pane - Shared Folders - Projects - Project Financials Sample Reports

Who uses this report?

  • Grants Accountant

  • Project Accountant

  • Project Manager

  • Project Team Member

When do I use this report?

When you need to review the revenue recognized transactions.

What can I do with this report?

Review revenue recognized transactions for a contract and accounting period.

What type of report is this?

Oracle Transactional Business Intelligence

Related Subject Area

This report uses the Project Billing - Revenue Real Time subject area.

Report Details

The following table lists the selected columns, underlying formulas, and customized column properties for the report.

Selected Column Source and Customized Properties

Accounting Period

"Fiscal Calendar"."Fiscal Period"

Contract Number

  • "Project Contract Header Details"."Contract Number"

  • Total After

Line Number

"Project Contract Line Details"."Contract Line Number"

Project Number

"Project"."Project Number"

Transaction Task Number

"Task"."Task Number"

Transaction Type

"Revenue Details"."Billing Transaction Type"

Transaction/Event Number

Formula customized as:

IFNULL("Expenditure Item"."Expenditure Item", IFNULL("Revenue Details"."Event Number", 0))

Expenditure/Event Type

Formula customized as:

IFNULL("Revenue Details"."Revenue Expenditure Type", IFNULL("Revenue Details"."Revenue Event Type", null))

Person

"Employee"."Employee Name"

Bill Rate

"Revenue Calculation"."Bill Rate"

Revenue in Ledger Currency

"Revenue Transaction Measures"."Revenue Amount"

Currency Code (Ledger Currency)

  • "- Contract Business Unit"."Contract Business Unit Currency Code"

  • Column heading is blank

The following table lists the prompts and filters used in the report.

Filter on Column Type Rules

Accounting Period Name