Oracle Payables Command Center

This chapter covers the following topics:

• Payables Command Center Overview
• Supplier Balance Dashboard
• Holds Dashboard
• Discounts Dashboard
• Period Close Dashboard

Payables Command Center

Payables Command Center Overview

Oracle Payables Command Center uses the Oracle Enterprise Command Center Framework to help you to analyze and to act on payables process data from across your enterprise. Improve your decision making and maximize operational efficiency with the sophisticated guided navigation and powerful search capability of the command center. Identify operational issues through metrics, graphs, and tag clouds, and take immediate action by drilling down directly to the underlying business processes in Oracle Payables.

Note: You can view data for one ledger at a time. Select a ledger by clicking the Ledgers metric in the summary bar.

As a payables manager, use the Payables Command Center to:

• Optimize days payable outstanding (DPO).

  • Resolve processing issues and accelerate payments to capture discounts.

  • Eliminate early payments and pre-payments.

• Optimize cash outflow.

  • Estimate cash outflow based on due date.

  • Forecast cash requirements in different currencies.

• Improve supplier relationships.

  • Release invoice holds effectively and avoid late payments.

  • Track the status of recent payments.

• Manage period close process proactively.

  • Gain visibility into the accounting process.

  • Identify any potential bottlenecks early in the closing cycle.

  • Reduce adjustments by identifying missed and incorrect posted entries.

Use the following dashboards in Payables Command Center:

• Supplier Balance: Use this dashboard to access payables information and manage open supplier transactions. See Supplier Balance Dashboard.

• Holds: Use this dashboard to review the payables invoices that are currently on hold and initiate the process to resolve the holds. See Holds Dashboard.

• Discounts: Use this dashboard to review the discounts that are available on unpaid invoices and analyze the benefits that you can gain by processing the supplier payments. See Discounts Dashboard.

• Period Close: Use this dashboard to get insight into all transactions that affect the closing process for accounting periods and speed up the period close and reconciliation process. See Period Close Dashboard.

Note: You can use the Payables 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, Release 12.2. For additional ECC overview information, see Overview of Enterprise Command Centers, Oracle E-Business Suite User's Guide.

Searching Enterprise Command Center Dashboards

Use the dashboard sidebar to refine (filter) the data on each dashboard. You can select a value or record from the Available Refinements component, or use Search to find a keyword, a value, or a specific record. The type-ahead feature suggests matches for your entry that correspond to the available refinements. When you submit a search, the search term is added to the Selected Refinements list, and the dashboard data is refined to include only records that match the search. 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. You can also use data sets to further refine your search.

Use an asterisk (*) or percent (%) 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.

Supplier Balance Dashboard

See Payables Command Center Overview.

Use the Supplier Balance dashboard to identify which supplier has the highest invoice amount and when that amount is due. Take an action on that invoice. For example, drill down to pay that specific invoice. This dashboard also lists the recently paid invoices. You can track details of recently paid invoices.

From the Payables Manager responsibility, navigate to the Supplier Balance dashboard:

(N) Payables Command Center > Supplier Balance

Important: To correctly display invoice validation statuses from Oracle Payables on the Supplier Balance dashboard, your system administrator must run the Payables Command Center Data Load concurrent program with the Full Load option. Otherwise, some components may show errors.

Supplier Balance Dashboard

The following table describes the dashboard:

Component	Description
Open Payables (summary bar) Note: Amounts are displayed in the ledger currency, and the conversion of foreign currency invoices uses the invoice exchange rate.	Use the metrics in this summary bar to monitor the health of open payables transactions. Supplier Balance: This metric shows the sum of all invoices in the ledger that are unpaid or partially paid, except for expense reports and prepayments. Employee Balance: This metric shows the sum of unpaid expense reports. Unapplied Prepayment: The sum of all prepayment invoices that are available and are not fully applied. Selecting this metric applies the Prepayment invoice type and the Available validation status. The Unapplied Prepayment results tab becomes active. Past-Due Invoices: This metric shows the sum of all invoices that are overdue (invoices with a due date greater than the system date). Invoices Due in 7 Days: This metric shows the sum of all invoices due within the next seven days.
Invoice (Count Distinct) by Validation Status (tag cloud)	This tag cloud displays the top ten validation statuses for the open invoices with the number of invoices at each status and drill down to the invoice type.
Charts and Graphs Note: Amounts are displayed in the ledger currency, and the conversion of foreign currency invoices uses the invoice exchange rate.	Aging of Past-Due Invoices: By default, this bar chart shows the sum of scheduled accounted amount by age and operating unit. Select a different metric to view the sum of invoice accounted amount or invoice count by age and operating unit. You can drill down by either dimension. To display data, this chart uses the template specified in the AP: ECC Aging Template profile option. Supplier Open Balance: By default, this chart shows suppliers with open balances by the sum of scheduled accounted amount and operating unit. Select a different metric to view the sum of invoice accounted amount or invoice count by supplier and operating unit. You can drill down by supplier.
Detailed Insight (tabbed component) Open Invoices (results table)	This table displays schedules for all unpaid or partially paid invoices that are accessible to you. You can perform the following row-level actions: To act on an invoice, click the link in the Invoice Number column to navigate to the Invoice Workbench (Payables Manager) window. To pay an invoice in full, click the link in the Scheduled Amount column to navigate to the Payments (Payables Manager) - Pay Scheduled Payment window.
Detailed Insight (tabbed component) Unapplied Prepayment (results table)	Use this table to view details for the prepayment invoices that are available and are not fully applied.
Detailed Insight (tabbed component) Paid Invoices (results table)	Use this table to view details for invoices or schedules that were partially paid or fully paid. To display the payment history, the dashboard considers the number of days specified in the AP: ECC Payment History Range profile option. To view the payment details for an invoice, click the link in the Invoice Number column to navigate to the Invoice Workbench (Payables Manager) window.
Options (table-level actions)	Export: Use this action to export the search results in a comma-separated values (CSV) file.

Holds Dashboard

See Payables Command Center Overview.

Use the Holds dashboard to see payables invoices that are currently on hold. Identify and drill down on problematic invoices to resolve issues such as supplier disputes. The dashboard shows purchase-order matched and non-matched invoices.

From the Payables Manager responsibility, navigate to the Holds dashboard:

(N) Payables Command Center > Holds

Holds Dashboard

The following table describes the dashboard:

Component	Description
Hold Metrics (summary bar) Note: The invoice date is displayed at the schedule level. Note: Amounts are displayed in the ledger currency, and the conversion of foreign currency invoices uses the invoice exchange rate.	This summary bar displays the following metrics: Past-Due Invoices on Hold: This metric shows the sum of invoices that are on hold and have due dates in the past. Held Invoices Due Within 7 Days: This metric shows the sum of invoices that are on hold and due in the next seven days. Discount Lost Due to Holds: This metric shows the total discount amount available on invoices that are on hold and have missed at least one discount date. Invoice Amount on Hold: This metric shows the sum of all invoices that are on hold (not payment hold). The hold invoice count is displayed as hover text. Invoices on Hold: This metric shows the number of invoices on hold.
Top 10 Holds by Invoices (tag cloud)	This tag cloud shows the ten holds most frequently applied, sized by frequency.
Charts and Graphs Note: Amounts are displayed in the ledger currency, and the conversion of foreign currency invoices uses the invoice exchange rate.	The following charts are available: Scheduled Accounted Amount (Sum) by Supplier Name: This chart displays the total invoice amount on hold for individual suppliers, stacked by hold names. Invoice Accounted Amount (Sum) by Hold Aging, Operating Unit: This chart displays the sum of invoice amounts in functional currency for each operating unit using predefined hold buckets.
Hold Details (results tables)	The results tables display details for invoices on hold and for discounts on held invoices. To perform invoice actions, click the link in the Invoice Number column to navigate to the Invoice Workbench (Payables Manager) window.
Options (table-level actions)	Export: Use this action to export the search results in a comma-separated values (CSV) file.

Discounts Dashboard

See Payables Command Center Overview.

Use the Discounts dashboard to review the discounts that are available on unpaid invoices. The dashboard includes a breakdown of the discount amounts by invoices and discount expiration dates, and so on. Use this information available, maximize discounts by managing the timing of invoice payments.

From the Payables Manager responsibility, navigate to the Discounts dashboard:

(N) Payables Command Center > Discounts

Discounts Dashboard

The following table describes the dashboard:

Component	Description
Discount Metrics (summary bar) Note: Amounts are displayed in the ledger currency, and the conversion of foreign currency invoices uses the invoice exchange rate.	These metrics help you to review the discount opportunities available on unpaid invoices. Discounts Available in the Next 7 Days: This metric shows the sum of all available discounts (first, second, or third) expiring in the next seven days. Discounts on Held Invoices: This metric shows the discount amount available but at risk due to holds.
Top 10 Suppliers by Discount Amount (tag cloud)	This tag cloud displays the ten suppliers with the highest number of discountable schedules available on outstanding balances.
Charts and Graphs Note: Amounts are displayed in the ledger currency, and the conversion of foreign currency invoices uses the invoice exchange rate.	First Discount Available (Sum) by Discount Available, Supplier Name: This chart displays the sum of first available discounts by discount amount and supplier name. First Discount (Sum) by Discount Percentage by Supplier Name: This chart displays the sum of first available discounts by supplier name and discount percentage.
Payment Schedules with Discounts (results table)	This table displays invoices with discount terms. You can perform the following row-level actions: To act on an invoice, click the link in the Invoice Number column to navigate to the Invoice Workbench (Payables Manager) window. To pay an invoice in full, click the link in the Scheduled Amount column to navigate to the Payments (Payables Manager) - Pay Scheduled Payment window.
Options (table-level actions)	Export: Use this action to export the search results in a comma-separated values (CSV) file.

Period Close Dashboard

See Payables Command Center Overview.

The Period Close dashboard shows data for open accounting periods and offers insight into the period close process in your enterprise to ensure that all transactions are processed, accounted, and transferred to Oracle General Ledger (GL). If the accounting transactions are not closed during the subledger period, then new transactions in the past periods are affected, which invalidates the already accounted and reported results in GL.

Use the dashboard to:

• Review all invoices and payments created in the period.

• Manage period close process proactively.

  • Gain visibility into the accounting process and subledger accounting events.

  • Review and analyze period close exceptions for a ledger, an operating unit, and an accounting period.

  • Drill down to the source transaction to review unaccounted transactions (invoices or payments).

  • Drill down to subledger journal lines and journal errors.

  • Identify any potential bottlenecks early in the closing cycle.

  • Reduce adjustments by identifying missed and incorrect posted entries.

• Increase efficiency.

  • Reduce period close time.

  • Accelerate delivery of financial results to internal management.

  • Identify improvements that need to be made over the next period.

• Optimize month-end processes and improve accounting cycle.

  • Track period close process.

  • Complete the accounting process.

  • Solve accounting errors.

  • Transfer accounted journals to GL.

From the Payables Manager responsibility, navigate to the Period Close dashboard:

(N) Payables Command Center > Period Close

The Period Close dashboard shows data in the context of the selected ledger and the associated operating units. To calculate accounted and untransferred events, the dashboard considers the primary, secondary, and reporting currency ledgers' data including that of the subledger and journal.

Period Close Dashboard

The following table describes the dashboard:

Component	Description
Closing Controls (summary bar)	The summary bar shows the following key metrics to investigate the period close process for the selected ledger. 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 single ledger. Open Periods: This metric shows the number of accounting periods that are open. If there are open accounting periods, then there is a risk of entering transactions in the wrong accounting period. Unaccounted Events: This metric shows the number of transaction events that are not processed or unaccounted, which include invoices and payments. These unaccounted events prevent financial managers from closing an accounting period. Selecting this metric makes the following components active: Unaccounted Events tab with Total Number of Events by Event Type, Operating Unit chart and Total Number of Events by Transaction Type chart Event Details results table Draft Accounting: This metric shows the number of subledger journal entries that are in the Draft mode. Because you cannot transfer draft accounting entries to Oracle General Ledger, review this metric to process these entries using the Create Accounting program. Selecting this metric makes the following components active: Pending Accounting Events tab with Total Number of Events by Event Type, Journal Entry Status chart and Total Number of Events by Category chart Pending Events results table Accounting Errors: This metric shows the number of accounting errors reported by the Create Accounting program when the request is run in Oracle Subledger Accounting. Selecting this metric makes the following components active: Pending Accounting Events tab with Total Number of Events by Event Type, Journal Entry Status chart and Total Number of Events by Category chart Pending Events results table Untransferred Journals: This metric shows the number of journals that are not yet transferred to and posted in Oracle General Ledger. Selecting this metric makes the following components active: Untransferred Journals tab with Total Number of Events by Category chart and Total Number of Events by Journal Entry Status chart Journal Details results table
Unaccounted Events (tab)	This tab contains the following charts and a results table. Charts Total Number of Events by Event Type, Operating Unit: This chart shows the number of unaccounted events for each Oracle Subledger Accounting event type in an operating unit. Total Number of Events by Transaction Type: This chart shows the number of unaccounted events for each Oracle Subledger Accounting transaction type. Results Table The Event Details table shows information for unaccounted events. To perform the following actions, click the row-level Actions icon and select an action. The transaction type determines the action that you can perform for an unaccounted event. To review an unaccounted transaction, select Invoice to navigate to the Invoice Workbench (Payables Manager) window. To review or act on a receipt of an unaccounted transaction, select Payment to navigate to the Payments (Payables Manager) window.
Pending Accounting Events (tab)	This tab contains the following charts and a results table. Charts Total Number of Events by Event Type, Journal Entry Status: This chart shows the number of pending subledger (SLA) accounting events for each event type by the Oracle Subledger Accounting journal status. Total Number of Events by Category: This chart shows the number of pending accounting events for each event category. Results Table The Pending Events results table shows subledger details for pending accounting events. To perform the following actions, click the row-level Actions icon and select an action. The transaction type determines the action that you can perform for pending event. To review a pending accounting event, select Invoice to navigate to the Invoice Workbench (Payables Manager) window. To review or act on a payment of a pending accounting event, select Payment to navigate to the Payments (Payables Manager) window. To review subledger journal lines for a pending event, click Subledger Journal Lines. The Subledger Journal Entry Lines page opens in the Subledger Journal Lines drawer. To review subledger journal errors for a pending event, click Subledger Journal Errors. The Subledger Journal Entry Errors page opens in the Subledger Journal Errors drawer. Review the ledger and line errors on this page.
Untransferred Journals (tab)	This tab contains the following charts and a results table. Charts Total Number of Events by Category: This chart shows the number of events that are not yet posted to Oracle General Ledger by event category. Total Number of Events by Journal Entry Status: This chart shows the number of events that are not yet posted to Oracle General Ledger by journal entry status. Results Table The Journal Details results table shows subledger details for untransferred journals. To perform the following actions, click the row-level Actions icon and select an action. The transaction type determines the action that you can perform for an untransferred journal. To review an untransferred journal, select Invoice to navigate to the Invoice Workbench (Payables Manager) window. To review or act on an untransferred journal, select Payment to navigate to the Payments (Payables Manager) window. To review subledger journal lines for a pending an untransferred journal, click Subledger Journal Lines. The Subledger Journal Entry Lines page opens in the Subledger Journal Lines drawer.
Options (table-level actions)	Export: Use this action to export the search results in a comma-separated values (CSV) file.