Project Cost Account Reconciliation Dashboard

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

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

The dashboard consists of the Project Cost Account Reconciliation analysis.

Key Insights

This dashboard 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 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?	Grants Accountant Project Accountant
When do I use this dashboard?	When account balance discrepancies exist between General Ledger and Project Costing.
What can I do with this dashboard?	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 dashboard is this?	Oracle Transactional Business Intelligence

Details

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

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 Project Cost Account Reconciliation analysis.

View	Displayed Information
View Name	Project Cost Account Reconciliation
View Sections	None
Table Column and Measures	Ledger Accounting Period Account Event Class Accounting Class Project Number Task Number Transaction Number Distribution Line Number Ledger Currency Debit Amount Credit Amount