Oracle General Ledger Command Center

This chapter covers the following topics:

• General Ledger Command Center Overview
• Account Analysis Dashboard
• Journal Processing Dashboard
• Balances Dashboard

General Ledger Command Center

General Ledger Command Center Overview

The Oracle General Ledger Command Center provides key insight into all the financial accounts of your business. As a chief financial officer, you can use the command center to get comprehensive information about your organization's financial position. You can identify and prioritize areas of cost optimization or revenue enhancement across different cost center levels. As a financial manager or a controller, compare numbers across multiple financial periods to monitor the 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.

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

• Improve account analysis by reviewing financials data in the following ledger categories.

  • Primary Ledger

  • Secondary Ledger (SL)

  • Alternate Ledger Currency (ALC)

    Note: ECC supports Alternate Ledger Currency type for subledger or journal-level reporting currency.

• Gain visibility into the analysis.

  • Review posted and unposted account activities.

  • Analyze financial trends by reviewing the historical data.

• Examine subledger details and journal sources.

  • Drill down to subledgers and transactions in the subledgers.

• Review business transactions at all levels of the account hierarchy.

• Review financial data across all levels of the cost center hierarchy to assess overall performance.

• Gain insight into journal processing primary and secondary ledgers.

  • Correct interface lines.

  • Edit unposted journals.

  • Process pending journals to keep your accounts up to date.

• Get a comprehensive insight into the General Ledger balances data primary and secondary ledgers.

  • Review the year-to-date (YTD) beginning and ending balances.

  • Analyze detailed trial balances.

  • Evaluate business performance using balances data, specifically account balances at the end of the fiscal period.

  • Use balance data to communicate financial information.

• Optimize and improve the accounting cycle in primary and secondary ledgers.

  • Maintain accurate financial records.

  • Maintain compliance with accounting standards.

  • Accelerate the financial close.

  • Close ledgers on time.

The General Ledger Command Center contains the following dashboards:

• Account Analysis: Use this dashboard to review and analyze all account activities, whether posted or unposted, from open accounting periods. See Account Analysis Dashboard.

• Journal Processing: Use this dashboard to correct journal errors and review journals that are ready for import. See Journal Processing Dashboard.

• Balances: Use this dashboard to review and analyze year-to-date balances and detailed trial balance. See Balances Dashboard.

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

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 you can use the Search field to find a keyword, a value, or a 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 that matches any single 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. The dashboard provides an overview of journal entry sources including chart of account (COA) segments and the subledger data with amounts in the journal currency and the ledger currency.

Use the dashboard to:

• Review debit, credit, and period activities by ledger, accounting period, account type, source, and category for primary and secondary ledgers.

• Evaluate financial performance of your company across multiple fiscal years, quarters, or periods, for example, you can perform year-on-year or quarter-over-quarter comparison.

  • Review financial data of revenue or expenses over specific periods in the primary and secondary ledgers.

  • Compare historical data across two or more periods using the horizontal analysis technique. For example, as a treasury manager, compare cash on hand at the end of the current accounting period with the previous period to investigate differences.

• Ensure that all accounting distributions are correctly made for accurate checks and balances in your financial system.

  • Get a complete overview of the parent and child accounts of the account hierarchy in your organization.

    • Review account balances at the summary level to know the financial position.

    • Take informed financial decisions based on the available data.

  • Check the account balances at different levels of cost centers within the cost center hierarchy to track the financial performance for those accounts.

    • Gain a comprehensive view of costs across different levels of the hierarchy, facilitating a holistic understanding of expenditure.

• Analyze account activities from posted and unposted journals for all general ledger accounts.

• Review details for journals to trace each transaction to its source.

• Use the Network Diagram to track an account balance graphically to find the source of the transaction.

• Drill down from summary information to a subledger and then to transactions in the subledger.

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

General Ledger Controls - Closed Periods Metric

Journal Lines Table

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:

• Period Activities by Chart of Accounts

• Period Activities by Account Hierarchy

• Period Activities by Cost Center Hierarchy

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:

• Period Activities tab

• Period Activities by Chart of Accounts table

• Period Activities by Account Hierarchy table

• Period Activities by Cost Center Hierarchy table

• Journal Details results table

Using the Account Analysis Dashboard

The following table describes the dashboard:

Component	Description
General Ledger Controls (summary bar)	The summary bar displays key metrics to summarize ledger controls for the selected ledger in the following fields: Ledgers: This metric shows how many ledgers are currently represented in the dashboard. If this metric has a value greater than 1, click the value to select a ledger. 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.

• Period Activities by Chart of Accounts

• Period Activities by Account Hierarchy

• Period Activities by Cost Center Hierarchy

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

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:

• The Cost of Sales node.

• The Cost Management node, which is the source of journals.

• The Journal nodes for the source with details about each journal.

• The Journal Line nodes for each journal with details about the journal line.

Performing Actions from the Nodes in the Network Diagram

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

Journal Node Actions

Journal Line Node Actions

View Journal Entry Lines Page

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:

• Identify journal import errors using the Errors metric and the Error Lines table.

• Track journals import process for primary and secondary ledgers.

• Review and correct the error lines by drilling down to the Correct Journal Import Data window.

• Review the interface lines that are ready for import and process these lines in Oracle General Ledger.

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 following table describes the dashboard:

Component	Description
Journal Import Controls (summary bar)	The summary bar displays key metrics to summarize journal import details in the following fields: Ledgers: This metric shows how many ledgers are currently represented in the dashboard. If this metric has a value greater than 1, click the value to select a ledger. 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. 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:

• Review year-to-date (YTD) balances for primary and secondary ledgers.

  • Examine the net period activities and closing balances across account types and natural accounts for an accounting period.

  • Drill down to examine the ending balance for each account.

  • Compare balances, for example, Cash and Accounts Receivable accounts to monitor cash flow and then drill down further to review accounts that contribute to the Cash and Accounts Receivables accounts such as Support Sales and Consulting Sales.

• Review accounts at different levels of the cost center hierarchy.

  • Review year-to-date (YTD) balance breakdown by cost center hierarchy.

• Review detailed trial balance data.

• Monitor the financial activities of the organization by tracking account balances at the end of the fiscal period.

• Identify trends and patterns in your finances by comparing closing balances.

  • Track changes to General Ledger account balances.

  • Evaluate the organization's financial position by comparing the closing balance of a set of accounts with the same in the previous periods.

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

Balances Dashboard Components

The following table describes the dashboard:

Component	Description
Controls (summary bar)	The Controls summary bar displays key metrics to summarize balances. Ledgers: This metric shows how many ledgers are currently represented in the dashboard. If this metric has a value greater than 1, then click the value to select a ledger. 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.