1. Creating and Administering Analytics and Reports for Project Management
  2. Project Contract List Dashboard

Project Contract List Dashboard

The Project Contract List dashboard displays project contracts and contract status for a business unit grouped by customer.

The dashboard uses the Project Billing - Funding Real Time, Project Billing - Invoices Real Time, and Project Billing - Revenue Real Time subject areas.

The dashboard consists of the Project Contract List analysis and you can drill down to the Project Contract Lines from the Project Contract List analysis.

Key Insights

This dashboard 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 dashboard.

FAQ

Answer

How do I find this dashboard?

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

Who uses this dashboard?

  • Contract Administrator

  • Grants Accountant

  • Project Accountant

  • Project Billing Specialist

  • Project Team Member

When do I use this dashboard?

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

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

Oracle Transactional Business Intelligence

Details

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

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 Project Contracts analysis.

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

Related Topics