1. Creating and Administering Analytics and Reports for Project Management
  2. CIP Account Dashboard

CIP Account Dashboard

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

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

The dashboard consists of the CIP Account Analysis.

Key Insights

The dashboard answers the following business questions:

  • Do the capitalizable costs in Oracle 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 the frequently asked questions about this dashboard.

FAQ

Answer

How do I find this dashboard?

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

Who uses this dashboard?

Project Accountant

When do I use this dashboard?

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

What can I do with this dashboard?

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

Oracle Transactional Business Intelligence

Details

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

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 CIP Account Analysis.

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