Oracle Receivables Command Center

This chapter covers the following topics:

• Receivables Command Center Overview
• Outstanding Receivables Dashboard
• Billing Process Dashboard
• Payment Process Dashboard
• Payment History Dashboard
• Period Close Dashboard

Receivables Command Center

Receivables Command Center Overview

Oracle Receivables Command Center enables receivables managers and analysts to analyze and to act on receivables data from across their enterprise. Use the command center to review open receivables, billing, and payment transactions. Operational efficiency and insight is enhanced through key metrics, drillable graphs, and tag clouds so that you can quickly identify problem areas and outstanding items that require intervention.

Use the command center to:

• Minimize customer account delinquency.

  • Compare current and delayed transactions against unapplied receipts.

  • Contact customer and expedite collection, and tailor collection strategy per customer.

• Reduce Days Sales Outstanding (DSO).

  • Resolve billing process bottlenecks.

  • Reconcile payment exceptions and discrepancies.

• Fit collection strategy per customer.

  • Analyze payment trends, overdue balances, adjustments, and credit memos.

  • Recognize potential problems early and minimize delays.

• 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 Receivables Command Center:

• Outstanding Receivables: Use this dashboard to get insight into outstanding receivables, specific transactions, and potentially challenging customers that require attention. See Outstanding Receivables Dashboard.

• Billing Process: Use this dashboard to review outstanding issues such as incomplete transactions, adjustments pending approval, and auto-invoice import processing errors. See Billing Process Dashboard.

• Payment Process: Use this dashboard to identify payment related transactions such as unapplied and on account receipts, receipt and remittance batches requiring attention, and lockbox errors. See Payment Process Dashboard.

• Payment History: Use this dashboard to review recent historical information about both paid transactions and applied receipts across customers. See Payment History 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: The Oracle Receivables Command Center configuration and setup must be completed before the installation and common configurations are completed as described in My Oracle Support Knowledge Document 2495053.1, Installing Oracle Enterprise Command Center Framework. 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 sidebars 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 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.

Outstanding Receivables Dashboard

See Receivables Command Center Overview.

The Outstanding Receivables dashboard offers insight into outstanding receivables and customers requiring attention. It provides an overview of open receivables transactions and associated key metrics.

Use the dashboard to:

• Monitor the health of outstanding receivables to ensure prompt follow-up on payment commitments.

• Assess the aging distribution of current and past-due transactions.

• Identify the transactions that are problematic.

• Negotiate on past-due invoices.

• Preview customer invoices to expedite collection.

  Select and initiate payments for transactions as a group.

From the Receivables Manager responsibility, navigate to the Outstanding Receivables dashboard:

(N) Receivables Manager > Receivables Command Center

First select a ledger to display relevant data based on the selected filter, then you can search for operating unit, customer, open receivables transactions, and associated key metrics.

Outstanding Receivables Dashboard

The following table describes the dashboard:

Component	Description
Open Receivables (summary bar)	The summary bar displays key metrics to summarize open receivable transactions 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 single ledger. Currency: This metric shows the currency of the current ledger. Outstanding Balance: This metric shows the sum of all open transactions in functional currency. Past-Due Balance: This metric shows the sum of all transactions with a due date greater than the system date. Current Balance: This metric shows the sum of all transactions current open balance for all transaction types except credit memo type. On-Account Credit Memo Balance: This metric shows the sum of all on account credit memo. Click a metric to refine the dashboard data.
Open Receivables (charts)	Transaction Aging for Outstanding Receivables: This chart shows the aging periods and the amount due for open transactions by operating unit. The transactions are grouped by age according to the setting of the Aging Buckets profile option. The amount due is represented in the functional currency. Top Past-Due Customers: This chart displays the top customers with past-due transactions amounts or number by operating unit. Transaction amounts are represented in the functional currency.
Transaction List (results table)	This table contains detailed information about open receivables transactions. You can perform the following row-level actions: To preview the customer invoice and view details, click the link icon in the Preview column for the associated record. To open and investigate a transaction, click the link in the Transaction Number column to navigate to the Transactions window in Oracle Receivables.
Options (table-level actions)	Export: Use this action to export the search results in a comma-separated values (CSV) file format.

Billing Process Dashboard

See Receivables Command Center Overview.

The Billing Process dashboard highlights outstanding issues in billing such as incomplete transactions, adjustments that are waiting for approval, and auto-invoice import processing errors.

Use the dashboard to:

• Resolve billing process bottlenecks.

• Take corrective actions such as complete transactions and approve adjustments that are pending.

• Resolve import errors.

From the Receivables Manager responsibility, navigate to the Billing Process dashboard:

(N) Receivables Manager > Receivables Command Center

Billing Process Dashboard

The following table describes the dashboard:

Component	Description
Billing Process Exceptions (summary bar)	The summary bar displays the following key metrics about the billing process for open receivables transactions 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. Currency: This metric shows the currency of the current ledger. Incomplete Transactions: This metric shows the sum of all incomplete transactions. Pending Adjustment Amount: This metric shows the sum of all adjustments that are waiting for approval. Pending Adjustments: This metric shows the number of adjustments that are waiting for approval. Pending Adjustment Type: This metric shows the number of adjustment types that are waiting for approval. Import Errors: This metric shows the number of import errors. Click a metric to refine the dashboard data.
Billing Process (charts)	Incomplete Transactions This chart shows the sum of incomplete transaction amounts for bill-to-customers or an operating unit. Pending Adjustments This chart shows the sum of pending adjustment transaction amounts for bill-to-customers or an operating unit.
Pending Billing Details (results tables)	This component contains the following tables, each of which presents detailed information about portions of the billing process. You can also perform row-level actions from these tables Incomplete Transactions table: To complete a transaction, click the link in the Incomplete Transaction Number column to open the transaction in the Transactions window. Pending Adjustments table: To act on a pending adjustment for a transaction, click the link in the Adjustment Number column to open the adjustment transaction in the Transactions window. Import Processing Errors table This table shows details for errors, such as error count, error type, and message.
Options (table-level actions)	Export: Use this action to export the search results in a comma-separated values (CSV) file format.

Payment Process Dashboard

See Receivables Command Center Overview.

The Payment Process dashboard identifies payment related exceptions such as unapplied and on account receipts, receipt and remittance batches that require attention, and lockbox errors.

From the Receivables Manager responsibility, navigate to the Payment Process dashboard:

(N) Receivables Manager > Receivables Command Center

Payment Process Dashboard

The following table describes the dashboard:

Component	Description
Payment Process (summary bar)	The summary bar shows metrics that indicate payment related transaction problems. 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. Currency: This metric shows the currency of the current ledger. Unapplied Receipts: This metrics shows the number of receipts that have not been applied to transactions or placed on account. Unapplied Receipt Balance: This metric shows the sum of all receipts that are not applied to transactions. Receipt Batches: This metric shows the number of receipt batches that require attention. Remittance Batches: This metric shows the number of remittance batches that require attention. Lockbox Errors: This metric shows the number of transmission process errors that the AutoLockbox process displays when you run it to import your invoice-related receipts. Click a metric to refine the dashboard data.
Top 10 Customers with Unapplied Receipts (tag cloud)	This tag cloud displays the ten customers with the highest number of receipts that have not been applied to transactions or placed on account.
Receipt Batch Number (Count District) By Operating Unit (chart)	This chart shows the receipts batch count by operating unit. You can view the batch count by receipt batch process status.
Credit Balance (chart)	This chart shows the sum of unapplied amounts by operating unit and customer.
Unapplied Receipts (results table)	This table shows details for unapplied receipts including receipt number, unapplied amount, and receipt amount. To apply a receipt to the corresponding invoice, click the link in the Receipt Number column to open the Receipts window.
Receipts Batches Requiring Attention (results table)	To act on a receipt batch, click the link in the Receipt Batch Number column to open the Receipt Batches window.
Remittances Batch Requiring Attention (results table)	To act on a remittance batch, click the link in the Remittance Batch Number column to open the Remittances window.
Lockbox Errors (results table)	To edit transmission data, click the link in the Transmission Name column to open the Lockbox Transmission Data window.
Options (table-level actions)	Export: Use this action to export the search results in a comma-separated values (CSV) file format.

Payment History Dashboard

See Receivables Command Center Overview.

The Payment History dashboard provides an overview of paid transactions and payments, and associated key metrics. Use the dashboard to get insight into recent historical payment patterns across customers and operating units.

From the Receivables Manager responsibility, navigate to the Payment History dashboard:

(N) Receivables Manager > Receivables Command Center

Payment History Dashboard

The following table describes the dashboard:

Only transactions that are fully paid during the period (or final payment was applied) and receipts that are fully applied are displayed on this dashboard. If a transaction has been partially paid or a receipt only partially applied, then it will be displayed in either the Outstanding Receivables or the Payment Process dashboard.

Component	Description
Historical Receivables Metrics (summary bar)	The summary bar displays key metrics about receivable transactions 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. Weighted Average Days Paid: This metric shows the average number of days between the sale and the receipt of final payment weighted by receivables amount for receivables transactions that are paid off completely in the historical period. Weighted Average Days Delinquent: This metric shows the average number of days between the invoice due date and the final paid or the applied date. Paid Receivables Transactions: This metric shows the number of receivables transactions that are paid fully during the specific historical period. Applied Receipts: The metric shows the number of receipts that are applied (based on the final or full application during the specific historical period. The dashboard uses the value that is specified in the AR: History Range for ECC profile option to calculate Weighted Average Days Paid, Paid Receivables Transactions, and Applied Receipts metrics.
Weighted Average Days Paid by Customer (chart)	This chart shows customers and their payment time in weighted average days.
Weighted Average Days Delinquent by Customer (chart)	This chart shows customers and their late payment time in weighted average days.
Paid Transactions (results table)	You can perform the following row-level actions: To preview a customer invoice, click the link in the Preview column. To act on a transaction, click the link in the Transaction Number column to open the Transactions window.
Payments (results table)	To view the payment history for a receipt and to act on it, click the link in the Receipt Number column to open the Receipts window.
Options (table-level actions)	Export: Use this action to export the search results in a comma-separated values (CSV) file format.

Period Close Dashboard

See Receivables 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 receipts 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.

  • Investigate exception details at the transaction level.

    • Drill down to the source transaction to investigate the unaccounted transactions (receipts or invoices).

    • 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 the period close process.

  • Complete the accounting process.

  • Solve accounting errors.

  • Transfer accounted journals to GL.

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

(N) Receivables Manager > Receivables Command Center

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, which include customer invoices, bills receivables, adjustments, and receipts. 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 Error: 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 Event Type chart and Total Number of Events by Category 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 Transactions window. To review or act on the receipt of an unaccounted transaction, select Receipt to navigate to the Receipts 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 entry 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 a pending accounting event. To review a pending event, select Invoice to navigate to the Transactions window. To review or act on the receipt for a pending event, select Receipt to navigate to the Receipts 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 Event Type: This chart shows the number of events that are not yet posted to Oracle General Ledger by event type. Total Number of Events by Category: This chart shows the number of events that are not yet posted to Oracle General Ledger by journal category. 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 details for an untransferred journal, select Invoice to navigate to the Transactions window. To review or act on the receipt for an untransferred journal, select Receipt to navigate to the Receipts window. To review subledger journal lines for 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 format.