Capital Expenditures Dashboard

The Capital Expenditures dashboard displays the capital expenditure items for your assets.

The dashboard uses the Project Costing - Assets Real Time subject area.

The dashboard consists of the Capital Expenditures analysis.

Key Insights

This dashboard 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 the frequently asked questions about this dashboard.

FAQ

Answer

How do I find this dashboard?

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

Who uses this dashboard?

Project Manager

When do I use this dashboard?

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 dashboard?

You can review the following for your assets:

  • Ungrouped cost

  • Unassigned cost

  • Assigned cost

  • Transferred cost

  • Capitalized cost

What type of dashboard is this?

Oracle Transactional Business Intelligence

Details

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

Column

Type

Rules

Project Name

Filter

Prompted

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

Project Accounting Period Name

Dashboard prompt

  • Choice list

  • Required

  • Select multiple values enabled

The following table lists the views in the Capital Expenditures Report.

View

Displayed Information

View Name

Capital Expenditures Report

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