Oracle General Ledger Command Center

This chapter covers the following topics:

General Ledger Command Center

General Ledger Command Center Overview

The Oracle General Ledger Command Center offers a centralized platform to manage and monitor various aspects of your business's financial accounts. It provides easy access to critical financial information and functions, allowing you to gain a comprehensive view of the financial health and performance of your organization.

As a chief financial officer, the Command Center empowers you with comprehensive information about your organization's financial position, enabling you to identify and prioritize across different cost center levels. As a financial manager or controller, you can compare numbers across multiple financial periods to monitor financial performance. As a business manager, evaluate your organization's financial performance through a roll-up view of the organization's financial data. As a GL supervisor or a GL accountant, you can use key metrics, drillable graphs, and network diagrams to identify and track journals that require attention. As a financial manager, track the account balances at the end of the fiscal period to monitor the financial activities of the organization. As a financial or budget manager, you can compare budgeted figures with actual amounts to identify variances and get an overview of the organization's financial health. As an accountant or financial analyst, you can monitor budgets at different levels in the organization to ensure accuracy of financial data and entries in the general ledger.

Depending on your role, use the General Ledger Command Center to:

The General Ledger Command Center contains the following dashboards:

These dashboards are organized by role under the following responsibilities and menus:

Dashboard Role Responsibility and Menu
Account Analysis General Accounting Manager, Financial Analyst General Ledger Super User > General Ledger Command Center
Journal Processing GL Supervisor, GL Accountant General Ledger Super User > General Ledger Command Center
Balances Financial Manager General Ledger Super User > General Ledger Command Center
Budget Financial Manager, Budget Manager, Account, Financial Analyst General Ledger Super User > General Ledger Command Center

Note: You can use the General Ledger Command Center only after the installation and common configurations are completed as described in My Oracle Support Knowledge Document 2495053.1, Installing Oracle Enterprise Command Center Framework, Release 12.2. For additional ECC Overview information, see Overview of Enterprise Command Center Framework, Oracle E-Business Suite User's Guide.

Searching Enterprise Command Center Dashboards

To search for and refine (filter) the data on a dashboard, you can select a value from the Available Refinements component or use the Search field to find a keyword, value, or specific record. When you submit a search or select an available refinement, the search term or refinement is added to the Selected Refinements list, and all of the dashboard data is refined. You can add multiple refinements and remove any of them at any time. Use Saved Search to create and save your search. You can edit, delete, or refer to this saved search.

Use an asterisk (*) or a percent sign (%) to perform a partial keyword or record search that matches any string of zero or more characters. You can also use a question mark (?) to perform a partial search matching any character.

Additional Information: For more information about searching for and refining data in enterprise command centers, see Search in Highlights of an Enterprise Command Center, Oracle E-Business Suite User's Guide.

Account Analysis Dashboard

See General Ledger Command Center Overview.

The Account Analysis dashboard offers insight into all PTD (Period-to-Date) account activities, whether posted or unposted, from open and closed accounting periods. It provides an overview of journal entry sources, including chart of account (COA) segments and subledger data with amounts in the journal currency and the ledger currency.

Use the dashboard to:

Access the Account Analysis dashboard using the following navigation:

(N) General Ledger Super User (responsibility) > General Ledger Command Center

Note: The value set for the GL: Data Access Set profile option and the data set definition determine your access to the ledger set or a ledger, and specific balancing segments, or specific management segments within a ledger.

Account Analysis Dashboard

the picture is described in the document text

Journal Lines Table

the picture is described in the document text

Default Value

The dashboard does not have any default prefilters based on open periods. The number of latest open periods available on the dashboard is determined by the value set for the GL: Number of Latest Open Periods for ECC profile option by your administrator. To view and analyze data, click the Open Periods metric and select the period that you want to work with. You can filter by more than one period to compare data. Note that if you do not select a period, the Period Activities chart shows data only for the latest years.

You must select one or more periods to view data in the following tables:

If you have access to multiple ledgers, select the ledger that you want to work with first.

Viewing Historical General Ledger Data for Comparative Analysis

The Account Analysis dashboard enables you to compare and analyze accounting data across fiscal years, quarters, and periods for primary and secondary ledgers.

You can compare data on the following dashboard components:

Using the Account Analysis Dashboard

The following table describes the dashboard:

Component Description
Ledger (filter chip) The Ledger filter displays the ledger that you can access. The account analysis data is displayed in the context of a ledger. If you have access to multiple ledgers, then first select a ledger to display relevant data based on the selected filter.
General Ledger Controls (summary bar) The summary bar displays key metrics to summarize ledger controls for the selected ledger in the following fields:
  • Ledger Category

  • Ledger Currency: This metric displays the ledger functional currency.

  • Open Periods: This metric shows the number of open periods for the selected ledger. You must select an open period to view data for account analysis.

  • Closed Periods: This metric shows the number of closed periods in the selected ledger with the number of journals. Select a closed period if you want to view data for account analysis.

    Important: The summary bar displays the Closed Periods metric only if a ledger has closed periods in the number of fiscal years that is set as a value for the GL: Historical Range for ECC profile option.

  • Unposted Journals: This metric shows the number of journals that are not yet posted to Oracle General Ledger. Selecting the metric makes the Unposted Journal Aging tab active.

  • Posting Errors: This metric shows the number of journals with posting errors. In the Journal Details table, the Posting Status column shows the error description, and the Status column shows the error type.

Period Activities (chart) The Period Activities chart by default, shows the amounts for period activities in the functional currency by an account type and period name. If you select more than one period, then the Period Activities chart displays the historical data first followed by the recent data. To view details for a general ledger account from the account type dimension, drill down to general ledger accounts in each category and then to the specific general ledger account. For example, the Asset account type includes categories such as Payments, Purchase Invoices, Receiving, and Sales Invoices. Click the Asset bar graph to drill down to category graphs and from category graphs to general ledger accounts in each category.
You can review period activities for a period or compare period activities across multiple fiscal years, quarters, or periods. Using the horizontal analysis technique, you can visually review the accounting differences between periods for each line item. For example, you can perform the horizontal analysis for expenses incurred in Feb-22 and Feb-23 to do a year-to-year comparison. To compare data for multiple periods, you can drill down to general ledger accounts in each category and then to that specific general ledger account.
Journal Source (tab) This tab contains the following charts to gain insight into journal sources.
  • Journals by Source: This pie chart shows the percentage of journals for each subledger source and manual source. The hover text for a segment displays the number of journals in that source. If there are manual entries, then use the chart information to investigate the manual entries.

  • Journals by Category: This pie chart shows the percentage of journals for each subledger category. The hover text for a segment displays the number of journals in that category.

Unposted Journals Aging (tab) The Unposted Journals Aging chart shows the number of unposted journals in each predefined aging bucket. Journal aging indicates the number of days a journal has remained in the Unposted status without any action performed on it after being imported into Oracle General Ledger.
Period Activities by Chart of Accounts (pivot table) The Period Activities by Chart of Accounts table displays data for chart of account (COA) segments for the selected ledger, and the segment labels are reflected dynamically on the dashboard within the context of the selected ledger. You can show, hide, or reorder the COA segments using the runtime options. You can view the period, posting status and the sum of debit, credit, and PTD amounts for journals. By default, this table displays only five segments of the accounting structure.
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. See Using the Account Inquiry Drawer.
Period Activities by Account Hierarchy (pivot table) The Period Activities by Account Hierarchy table displays the period activities for the account hierarchy of the Natural Account segment. Note: The value set for the FND: KFF Hierarchy Level for ECC profile option determines the account levels that this table displays for the Natural Account segment. For example, if the profile option value is set to 3, then you can view data for three levels of the account hierarchy. This table displays only those accounts that have data. For a parent account, you can view the parent account code, account, account code, posting status, subtotal, and the sum of debit, credit, and PTD amounts. By default, this table displays only five segments of the accounting structure.
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. See Using the Account Inquiry Drawer.
Period Activities by Cost Center Hierarchy (pivot table) 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 five 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. See Using the Account Inquiry Drawer.
Journal Details (table) This table shows the details for general ledger journal headers.
To view line details for a subledger line, click the icon in the Journal column of that line. The Journal Details > Journal Lines table displays details for subledger lines. The currency of the entered debit and the entered credit is the journal currency. Click Journal Details to navigate back to the journal headers view.

Using the Account Inquiry Drawer

The Account Inquiry drawer enables you to graphically track the source of a transaction or the subledger transaction for an account balance. To display the Account Inquiry drawer, click an account number link in the Account Code column in the following tables.

If you select multiple periods to compare data, then the components of this drawer display data for the multiple periods.

The components of this drawer are as follows:

Row Expander

Period Activities by Cost Center Hierarchy - Account Inquiry

the picture is described in the document text

The default view is Row Expander. Click the Balance row to drill down to the Source, GL Journal, and GL Lines rows.

Timeline View

To view creation and posting details for a journal in chronological order, click the Timeline icon.

Using the Network Diagram

Network Diagram

the picture is described in the document text

To trace the source of transactions and view details for journal lines, click the Network Diagram icon. For example, you want to review the account activities for the Cost of Sales account with the account code 5110. When you click the Network Diagram icon, the network diagram displays the nodes in the following sequence:

Performing Actions from the Nodes in the Network Diagram

In the network diagram, right-click nodes to perform actions.

Journal Node Actions

the picture is described in the document text

Journal Line Node Actions

the picture is described in the document text

View Journal Entry Lines Page

the picture is described in the document text

The following table describes the actions that are available when you right-click a node.

Node Action Action Description
Journal Journal Timeline Use this action to open the timeline of a journal and view details.
Journal Line Drill Down to Subledger Journal When you select this action the View Journal Entry Lines page opens inline in the Account Inquiry drawer. View details for a subledger journal and source transactions from Oracle E-Business Suite applications and non-Oracle systems.
Note that a manual source does not have corresponding subledger journals.

Journal Processing Dashboard

See General Ledger Command Center Overview.

When you run the Journal Import process, the GL_INTERFACE table is where Journal Import receives the accounting data that you import from Oracle and non-Oracle feeder systems. If journal lines in the GL_INTERFACE table have errors, the journals cannot be imported to Oracle General Ledger. To ensure that Oracle General Ledger has all the primary and secondary ledger journal entries required for financial analysis, use the Journal Processing dashboard to review and resolve journal processing issues.

Use the dashboard to:

Access the Journal Processing dashboard using the following navigation:

(N) General Ledger Super User (responsibility) > General Ledger Command Center

Note: The value set for the GL: Data Access Set profile option and the data set definition determine your access to the ledger set or a ledger, and specific balancing segments, or specific management segments within a ledger.

Default Value

The dashboard does not have any default prefilters based on open periods. The number of latest open periods available on the dashboard is determined by the value set for the GL: Number of Latest Open Periods for ECC profile option by your administrator. To view and analyze data, click the Open Periods metric and select the period that you want to work with.

Journal Processing Dashboard

the picture is described in the document text

The following table describes the dashboard:

Component Description
Ledger (filter chip) The Ledger filter displays the ledger that you can access. The journal processing data is displayed in the context of a ledger. If you have access to multiple ledgers, then first select a ledger to display relevant data based on the selected filter.
Journal Import Controls (summary bar) The summary bar displays key metrics to summarize journal import details in the following fields:
  • Ledger Category

  • Open Periods: This metric shows the number of open periods for the selected ledger. You must select an open period to view data for journal processing.

  • Period

  • Errors: This metric shows the number of lines with errors in the GL_INTERFACE table. These are the records in the table with a status other than New. Selecting the metric applies a refinement and makes the Error Lines table active.

  • Ready for Import: This metric shows the number of subledger lines in the GL_INTERFACE table for import into Oracle General Ledger. The status of these lines is New. Selecting the metric applies a refinement and makes the Ready for Import table active.

Interface Line Errors (chart) This pie chart shows the percentage of interface lines in each error status. You can identify the error status using the status code. The hover text for a pie chart segment displays the number of interface lines with error in that error status.
Interface Line by Source and Category (chart) This chart shows the number of interface lines with errors from each journal source and source categories. For example, if the journal source is Cost Management, then Inventory, Receiving, and WIP can be the source categories.
Journal Processes (tabbed component)
Error Lines (table)
This table displays details for the error lines such as error, error description, source, category, and group ID.
To correct an error line, click the link icon in the Correct column to navigate to the Correct Journal Import window.
Note that when you navigate from the dashboard, the line parameters do not default to the Correct Journal Import window. In the Find Journal Import Data window that appears, search for the line that you want to correct by entering the group ID of that line.
Journal Processes (tabbed component)
Ready for Import (table)
To import journal entries into Oracle General Ledger, you can use the following methods:
  • Import journal entries using the Import Journals window

  • Import journal entries by running the Journal Import program


See How to Import Journals.

Balances Dashboard

See General Ledger Command Center Overview.

The Balances dashboard presents detailed data for year-to-date (YTD) balances and trial balances.

Use the dashboard to:

Important: The Balances dashboard displays balances data only for the "Actual" balance type.

Access the Balances dashboard using the following navigation:

(N) General Ledger Super User (responsibility) > General Ledger Command Center

Note: The value set for the GL: Data Access Set profile option and the data set definition determine your access to the ledger set or a ledger, and specific balancing segments, or specific management segments within a ledger.

Default Value

The dashboard does not have any default prefilters based on open periods. The number of latest open periods available on the dashboard is determined by the value set for the GL: Number of Latest Open Periods for ECC profile option by your administrator. To view and analyze data, click the Periods metric and select the period that you want to work with. You can select one or more periods to review data. If you do not select a period, then the YTD Balances chart shows data only for the latest years. To view data in the Detailed Trial Balance aggregated table, you must select one or more periods. If you have access to multiple ledgers, select the ledger you want to work with first.

Balances Dashboard

the picture is described in the document text

Balances Dashboard Components

The following table describes the dashboard:

Component Description
Ledger (filter chip) The Ledger filter displays the ledger that you can access. The balances data is displayed in the context of a ledger. If you have access to multiple ledgers, then first select a ledger to display relevant data based on the selected filter.
Controls (summary bar) The Controls summary bar displays key metrics to summarize balances.
  • Ledger Category

  • Ledger Currency: This metric displays the ledger functional currency.

  • Fiscal Year: Select the fiscal year for which you want to view the balances data. You can select multiple fiscal years for data comparison.

  • Periods: Select the specific period for which you want to view data.

  • Balancing Segment: This metric shows the number of balancing segments in the selected ledger. Select a balancing segment to refine data.

YTD Balances (chart) This chart shows the sum of ending balances in the functional currency by period name and account type. If you select more than one period, then the chart displays the historical data first followed by the recent data. You can review ending balance amounts across multiple fiscal years, quarters, or periods.
Use this chart to track the overall financial health of the company. The chart displays all General Ledger balances, regardless of the account nature (debits as positive amounts and credits as negative amounts). All amounts are positive, and this gives a complete picture of the company's assets, liabilities, equity, income, and expenses.
To view ending balances for a natural account for a period, drill down from the account type dimension to a specific account. When you drill down to a specific account, the Detailed Trial Balance table shows the details for that account.
Detailed Trial Balance (pivot table) This table enables you to review summarized actual account balances and activity for a ledger by balancing segment, cost center, account code, account, full account, and account segment values. You can also view the balancing of the accounts at different levels of cost center hierarchy with a subsummary. By default, this table displays only five segments of the accounting structure.
The table also displays the beginning balance, period activity, and ending balance for the filtered periods. Amounts are in the ledger currency and display debits as positive amounts and credits as negative amounts. At runtime, you can use the Hide/Show Attributes component to show or hide segments as needed using runtime options.

Budget Dashboard

See General Ledger Command Center Overview.

The Budget dashboard offers insight into all PTD (Period-to-Date) budget activities. It provides details about the planned and actual budget, chart of account (COA) segments, budget variances, variance trends across periods, and the breakdown of the actual budget variance along with the budget utilization.

Important: The Budget dashboard tracks only ledger (functional) currency budgets.

Use the dashboard to:

Access the Budget dashboard using the following navigation:

(N) General Ledger Super User (responsibility) > General Ledger Command Center

Budget Dashboard

the picture is described in the document text

Note: The value set for the GL: Data Access Set profile option and the data set definition determine your access to the ledger set or a ledger, and specific balancing segments, or specific management segments within a ledger.

Understanding Budget Dashboard Calculations and Charts

Variance

To accurately display variance data, the dashboard uses the account type dimension. Note that the positive or negative variance trend depends on the nature of the account type.

Example

Variance is calculated as Actual minus Budget: Actual - Budget

Budget Utilization

Budget utilization is calculated as Actual Spend divided by Budget and multiplied by 100.

(Actual Spend/Budget) x 100

Budget Dashboard Components

The following table describes the dashboard:

Component Description
Ledger (filter chip) Select the filter criteria to view the budget data. Based on your filter selection, the budget data is filtered and displayed on different charts and tables.
  1. The Ledger filter chip displays the ledger that you can access. The budget data is displayed in the context of a ledger. If you have access to multiple ledgers, then first select a ledger to display relevant data based on the selected filter.

  2. Select the budget for which you want to view budget activities.

  3. Based on the budget, select an account or multiple accounts to view the budget utilization details for those accounts. The Budget Utilization filter displays the account with the highest budget utilization rate as the top utilized account in the budget.

    Budget Utilization Filter

    the picture is described in the document text

Budget Variance (chart) The Budget Variance chart focuses on the period-to-date (PTD) activities of the budget. It compares the actual budget amounts and the allocated amounts as part of budget allocation for an account in the functional currency. Select a different dimension to view the budget variance data by cost center or balancing segment.
Variance Trend (chart) The Variance Trend chart shows the PTD budget variance over a time period for an account type by period. Select a different group dimension to view budget variance by fiscal year or fiscal quarter.
Pivot Table Use this table to track the actual amount, budget amount, variance amount, and utilization percentage for balancing segments, accounts, and cost centers. The default columns are Balancing Segment Code, Balancing Segment, Cost Center Code, Cost Center, Account, and Account Code. Use the Hide/Show Attributes feature to add the segments for which you want to view the budget data. These segments can be the product, the subaccount, and the product. You can select Full Account and Full Account Description attributes to view further details of the budget structure. For example, to display the hierarchical structure in the account and the cost center, you can select the appropriate attributes such as Parent Cost Center 1 and Cost Center attributes. Note that if there are multiple parent accounts for a child account, then the table displays only the direct or the first parent account.
Use the Budget Utilization filter chip to refine the budget and utilization data for a specific account or accounts. You can a view breakdown of budget utilization by account, cost center, actual, budget, and variance. If product or project segments are available, then you can view utilization percentage for these data points.
Use the drill-down feature that is available for the Actual Amount link for each account to drill down from the actual amount to the view the source and journals of the actual amount.
To view the actual balance details:
  1. Click the amount link in the Actual column. The Actual Balance Details drawer appears.

    Actual Balance Details

    the picture is described in the document text

  2. In the Actual Balance Journal table, view details such as the source, category, batch name, journal name, journal debit, journal credit, and journal net. You can switch between pivot table and aggregated table view.

  3. Click the Journal Name link to open the View Journal Entry Lines page.

    Important: The drill-down from the Journal Name link is applicable only to subledger journal entries. If you click the Journal Name link for journal entries that are not subledger entries, then an error message is displayed.