This chapter covers the following topics:
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.
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.
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:
Click a metric to refine the dashboard data. |
Open Receivables (charts) |
|
Transaction List (results table) | This table contains detailed information about open receivables transactions. You can perform the following row-level actions:
|
Options (table-level actions) | Export: Use this action to export the search results in a comma-separated values (CSV) file format. |
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.
Click a metric to refine the dashboard data. |
Billing Process (charts) |
|
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
|
Options (table-level actions) | Export: Use this action to export the search results in a comma-separated values (CSV) file format. |
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.
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. |
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.
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:
|
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. |
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.
|
Unaccounted Events (tab) | This tab contains the following charts and a results table.
|
Pending Accounting Events (tab) | This tab contains the following charts and a results table:
|
Untransferred Journals (tab) | This tab contains the following charts and a results table.
|
Options (table-level actions) | Export: Use this action to export the search results in a comma-separated values (CSV) file format. |