Analyze Balances by Cost Center Hierarchy in Account Analysis Dashboard

This enhancement adds cost center hierarchy analysis to the Account Analysis Dashboard. Users can analyze period activities through parent and child cost center values, giving finance teams a clearer view of activity by department, segment, or operational hierarchy.

The enhancement requires Oracle Enterprise Command Center Framework Release 12.2 V12. The FND: KFF Hierarchy Level for ECC profile option controls the supported hierarchy levels at the site level.

Period Activities by Cost Center Hierarchy

Period Activities by Cost Center Hierarchy

The Period Activities by Cost Center Hierarchy table displays the period activities for the account balances at different levels of cost centers within a cost center hierarchy. Note: The value set for the FND: KFF Hierarchy Level for ECC profile option determines the account levels that this table displays for the cost center hierarchy. By default, this table displays only 5 segments of the cost center hierarchy.
You can switch between the aggregated table view and pivot table view using icons.
To examine account details for an account using the Account Inquiry drawer, click an account number link in the Account Code column. 
From the Account Inquiry, you can:

  • Drill into the account details. 
  • Review the account details to identify the journal line containing the suspected amount. 
  • Drill down into the related subledger journal. 
  • View the source transaction associated with the journal entry.

Steps to enable and configure

  • Confirm Oracle Enterprise Command Center Framework Release 12.2 V12 or later.
  • Validate the cost center segment hierarchy used by the accounting flexfield.
  • Set the FND: KFF hierarchy Level for ECC profile option to the required hierarchy depth.
  • Run or refresh the Account Analysis data load after hierarchy and profile option changes.
  • Validate the Period Activities by Cost Center Hierarchy tab using known parent and child cost centers.

Tips and considerations

  • Coordinate cost center hierarchy maintenance with financial reporting teams so hierarchy totals are consistent.
  • The hierarchy level is controlled at the site level; confirm the setting supports all ledgers using the dashboard.
  • Use the hierarchy tab for departmental or segment rollups, then drill to journal detail for transaction support.

Key resources

Oracle General Ledger User's Guide 
Oracle General Ledger Implementation Guide
Transfer of Information
R12.2.13 TOI: Implement and Use General Ledger - Oracle General Ledger Command Center - GL Balances Dashboard