Oracle Receivables Command Center

This chapter covers the following topics:

Receivables Command Center

Receivables Command Center Overview

Oracle Receivables Command Center enables receivables managers, analysts, and accounts receivable specialists 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:

Use the following dashboards in Receivables Command Center:

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:

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 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 outstanding receivables 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. The Ledger list displays the ledgers that you can access with the total number of transactions for each ledger.
Open Receivables (summary bar) The summary bar displays key metrics to summarize open receivable transactions for the selected ledger in the following fields:
  • 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.

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:

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

(N) Receivables Manager > Receivables Command Center

Billing Process 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 billing process 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.
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.
  • 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.

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 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 payment process 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. The Ledger list displays the ledgers that you can access with the total number of receipts for each ledger.
Payment Process (summary bar) The summary bar shows metrics that indicate payment related transaction problems.
  • 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.

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.

Cash Application Dashboard

See Receivables Command Center Overview.

The Cash Application dashboard offers comprehensive insight into cash receipts and outstanding transactions of customers that require attention.

Use the dashboard to:

From the Receivables Manager responsibility, navigate to the Cash Application dashboard:

(N) Receivables Manager > Receivables Command Center

Cash Application Dashboard

the picture is described in the document text

Top 10 Customers with Open Balance Chart

the picture is described in the document text

The following table describes the dashboard.

Component Description
Data Sets The dashboard uses the following data sets to display data:
  1. Payment Process

  2. Outstanding Receivables


Click the Information icon to view the last successful run of the data load with the time stamp.
Ledger (filter chip) The Ledger filter displays the ledger that you can access. If you have access to multiple ledgers, then first select a ledger to display relevant data based on the selected filter.
To filter and review cash receipts data:
  1. Select a ledger. The cash application data is displayed in the context of a ledger.

  2. To focus on a specific customer, click the Customer filter, which displays the top customers with the total unapplied amount. Selecting a customer refines the data and all the dashboard components show data related to that customer.

    Cash Application Dashboard - Customer Filter Chip

    the picture is described in the document text

Cash Application (summary bar) You can view the following key cash application metrics:
  • Unapplied Receipts: This metric shows the total count of unapplied receipts.

  • Unapplied Balance: This metric shows the total unapplied accounted amount in the functional currency.

  • Open Transactions: This metric shows the total count of open transactions. Open transactions include invoices, debit memos, and deposits.

  • Open Balance: This metric shows the total accounted amount due in the functional currency.

Aged Unapplied Receipts (pie chart) The pie chart shows the total unapplied accounted amount by receipt aging. This chart provides information about the delayed receipts or receipts that are added to system but are not applied. You gain visibility into the aging of the receipts and can prioritize receipts based on aging, focusing efforts on older or critical transactions.
The chart uses the following predefined receipt aging buckets:
  • 1-7 Days

  • 8-15 Days

  • 15+ Days


You can view information of the filtered receipts in the Unapplied Cash Receipts grid.
Top 10 Customers with Open Balance (chart) This bar chart shows the ten customers with the highest total accounted amount due and customer name. This data is retrieved from the Outstanding Receivables Dashboard. Use this information to focus on high-value customers that require attention for payment collection. Click a customer bar graph to view details of the unapplied cash receipts for that customer in the Unapplied Cash Receipts grid.
Unapplied Cash Receipts (results grid) Based on the refinements or filter that you select, this grid displays a list of unapplied cash receipts with the following key information:
  • Customer name and location

  • Receipt number, date, amount, and receipt currency

  • Ledger currency

  • Receipt accounted amount

  • Receipt reference, if available

  • Account number

  • Receipt state

  • Payment status

  • Unapplied amount and unapplied accounted amount

  • Customer comment, if available


Reviewing cash receipts:
  • Review the receipt state to see whether a receipt is applied or unapplied.

  • Use the payment status to see whether a receipt is fully paid or not.

  • Review the unapplied amount for receipts in both the Applied and Unapplied state.

  • Review cash receipts with the "Open" payment status for applied and unapplied receipts. Receipts can be in the Applied state, but still have unapplied amount with the Open payment status.


The grid includes a Find Matches button for each unapplied and applied cash receipt with the Open payment status to locate potential matches for the unapplied cash. See Using the Find Matches Feature.
Options (table-level actions) Export: Use this action to export the search results in a comma-separated values (CSV) file format.

Using the Find Matches Feature

When you click the Find Matches button for an applied or unapplied cash receipt with the Open payment status, the Cash Application drawer appears.

Cash Application

the picture is described in the document text

Components of the Cash Application Drawer

You can view customer information for the selected record such as account number, receipt number, receipt date, receipt currency, ledger currency, receipt amount, receipt accounted amount, unapplied amount, and unapplied accounted amount.

The Outstanding Transaction table lists all open transactions that are available for application to the selected receipt. This table shows the transaction class, transaction number, transaction date, transaction currency, due date, amount due, ledger currency, accounted amount due, and installment (which shows the number of installments as an invoice may have more than one installment). Oldest invoices are listed first. Note that this table lists only the transaction classes of Invoice, Debit Memo, and Deposit.

To apply a cash receipt:

  1. Review the open transactions.

  2. To search for the invoice with the matching amount, click the filter in the Accounted Amount Due column.

  3. Click the Range icon to specify the Min and Max amount.

  4. Enter the minimum and maximum amounts and click Select Filter. The table lists the outstanding transactions that match the filter.

  5. Select the unapplied receipt and outstanding transaction. If you select more than one transaction, then you can verify the total amount using the footer summary.

  6. Click Apply. The Cash Application page appears with Receipt and Applications regions.

  7. Review the details and click Submit. A confirmation message appears that the application has been applied correctly.

  8. The cash application is refreshed immediately. The unapplied cash receipt that you processed no longer appears on the dashboard.

Applying Cross-Currency Receipts

You can apply receipts that are in one currency to one or more transactions in different currencies. For example, you can apply a USD receipt to one invoice denominated in British pounds (GBP) and another in Canadian dollars (CAD). You can apply receipts to invoices, debit memos, and deposits.

To apply a cash receipt:

  1. In Available Refinements, click Pending Receipt.

  2. Click Receipt Currency.

  3. Select Receipt Currency refinement.

  4. To focus on a specific currency receipt, click the Exclude filter for other currencies. The Unapplied Cash Receipts grid displays receipts with the selected currency.

  5. Click Find Matches. The Cash Application drawer appears with the list of outstanding transactions.

  6. Review the unapplied amount and the unapplied accounted amount.

  7. Select the transaction or transactions to which you want to apply this receipt.

  8. Click Apply. On the Cash Application page, the rate type and the rate information is automatically displayed along with the functional amount.

  9. In the Applied Amount field, the dashboard automatically displays the appropriate amount, which you can edit.

  10. In the Allocated Applied Amount field, manually enter the required amount. When you tab out, the cross currency rate and exchange gain/loss for this application is automatically calculated.

  11. Click Submit to apply invoice to the receipt. You can view the latest changes on the dashboard.

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 picture is described in the document text

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
Ledger (filter chip) The Ledger filter displays the ledger that you can access. The payment history 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.
Historical Receivables Metrics (summary bar) The summary bar displays key metrics about receivable transactions for the selected 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:

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 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 period close 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. The Ledger list displays the ledgers that you can access with the total number of events for each ledger.
Closing Controls (summary bar) The summary bar shows the following key metrics to investigate the period close process for the selected 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.