13Oracle Fusion Advanced Collections Reports

This chapter contains the following:

Oracle Fusion Advanced Collections Predefined Reports

You can generate some predefined reports that can be used in various stages throughout the collections process.

How to schedule a report?

You can schedule a report from your Scheduled Process Work area and Reports and Analytics Work area.

  • Schedule a report from Scheduled process work area:

    On the Navigator, click on Tools and then click Scheduled Processes to Schedule a report.

  • Schedule a report from Reports and Analytics Work Area:

    On Navigator, click on Tools and then click on Reports and Analytics work area

    or,

    Click the Reports and Analytics link on Oracle Business Intelligence Catalog.

You can create various predefined reports based these areas:

  • Aging

  • Dunning

  • Promises

Aging Reports

Here are the three types of predefined aging reports:

Report Name Description Parameters (*Required)

Aging By Common Currency

You can translate all your open transaction into a common currency based on the seven bucket aging method.

  • *Currency Conversion Type

  • *Targeted Currency

  • Business Unit

  • From Customer Name

  • To Customer Name

  • As-of Account Date

  • *Aging Bucket Method

  • Show Open Credits

Collections Aging 4 Bucket Report

You can view your customer's open transaction information based on the four bucket aging method.

  • *Business Unit

  • From Customer Account

  • To Customer Account

  • From Customer Name

  • To Customer Name

  • *Order By

  • *Report Summary

  • *Aging Bucket Method

  • *Report Format

  • *Show Open Credits

  • As-of General Ledger Date

  • From Balance Due

  • To Balance Due

  • *Show Receipts At Risk

Collections Aging by Collector 7 Bucket Report

You can view your customer's open transaction information by collector based on the seven bucket aging method.

  • *Business Unit

  • From Customer Account

  • To Customer Account

  • From Customer Name

  • To Customer Name

  • *Order By

  • *Report Summary

  • *Aging Bucket Method

  • *Report Format

  • Show Open Credits

  • As-of Accounting

  • Date

  • From Balance Due

  • To Balance Due

  • *Show Receipts At Risk

  • From Collector Name

  • To Collector Name

Dunning Report

Here is the predefined dunning report:

Report Name Description Parameters (*Required)

Validate Customer Dunning Setup Report

Displays customer dunning setup issues and provides solution.

  • *Business Unit

  • *Business Level

  • *Show Errors Only

  • From Customer Name

  • To Customer Name

  • From Customer Account

  • To Customer Account

Promises Report

Here is the predefined promise report:

Report Name Description Parameters (*Required)

Promise Reconciliation Report

Displays promise information by collector and is based on payments received and the promise status.

  • Business Unit

  • *From Date

  • *To Date

  • *Currency

  • State

  • Status

  • *Report Format

  • Collector Name

How to run a predefined report?

Here are the steps to run a predefined reports:

  1. Navigate to the Scheduled Processes work area.

  2. Click the Schedule New Process button.

  3. Search the Process Name.

  4. Enter the required parameters of the process.

  5. Enter the applicable process options and schedule.

  6. Click Submit.

Aging Reports

Using collections aging reports you can list your customer's open transactions information which can help you in creating collection strategies and tasks.You can view all your customer's open transactions based on the aging buckets you have defined.

Here are the types of aging report you can create:

Aging 4 Bucket Report

In this report, you can view your customer's open transaction information based on the four bucket aging method.

This image shows a sample of Collections Aging 4 Bucket Report.

This graphic illustrates the Aging 4 Bucket Report.

Report Parameters

This table shows all the required parameters for creating Collections Aging 4 Bucket Report:

Parameter Name Description

Aging Bucket Method

Either Staged or Aged, based on your company setup.

Order By

Select by Customer or Transaction Type.

Report Summary

Yes to display in summary, No to display in detail.

Show Open Credits

Yes or No to display open credits.

Show Receipts At Risk

Yes or No to display receipts at risk.

Aging by Collector 7 Bucket Report

In this report, you can view your customer's open transaction information by collector using the seven bucket aging method.

This image shows a sample of Collections Aging by Collector 7 Bucket Report.

This graphic illustrates the Aging 7 Bucket Report.

Report Parameters

This table shows all the required parameters for creating Collections Aging by Collector 7 Bucket Report:

Parameter Name Description

Aging Bucket Method

Either Staged or Aged, based on your company setup.

As-of Accounting Date

Period start date for the report.

Order By

Select by Customer or Transaction Type.

Report Format

Select the format such as HTML, PDF, or Excel.

Report Summary

Yes to display in summary, No to display in detail.

Aging by Common Currency Report

In this report, you can view all open transaction information converted to one common currency for all Business Units or a specific Business Unit.

This image shows a sample of Aging by Common Currency Report

This graphic illustrates the Aging by Common Currency
Report.

Report Parameters

This table shows all the required parameters for creating Aging by Common Currency Report:

Name Description

Targeted Currency

The currency you want displayed in the report. The default is USD.

Aging Bucket Method

Either Staged or Aged based on setup.

Frequently Asked Questions

This table lists some frequently asked questions about the aging reports.

FAQ Answers

Where can I find these reports?

On the Navigator menu click on the Scheduled Processes work area to schedule and run these reports.

Who uses these reports?

  • Financial Manager

  • Financial Specialist

When do I use these reports?

You can use these reports to:

  • Review aging typically on a daily or weekly basis.

  • Understand the aging and risk exposure of outstanding receivables.

What can I do with these reports?

Use these reports to formulate strategies with task or tasks to collect on outstanding delinquent customers.

What type of reports are these?

Oracle Business Intelligence Publisher

Promise Reconciliation Report

In Collections Promise Reconciliation Report you can view all the promise details of each collector based on business unit and date range. You can use this report to reconcile promises to pay with broken promises.

This image shows a sample of Collections Promise Reconciliation Report:

This graphic illustrates the Promise Reconciliation
Report.

Report Parameters

This table shows all the required parameters for creating Collections Promise Reconciliation Report.

Name Description

Business Unit

Select the appropriate business unit.

Collector Name

Specify by collector if appropriate.

Currency

Select the appropriate currency.

Date From

Starting date range.

Date To

Ending date range

Report Format

Select format such as HTML, PDF, or Excel.

Frequently Asked Questions

This table lists some frequently asked questions about the Collections Promise Reconciliation Report.

FAQ Answers

Where can I find this report?

On the Navigator menu click on the Scheduled Processes work area to schedule and run these reports.

Who uses this report?

  • Financial Manager

  • Financial Specialist

When do I use this report?

You can use this report to review and keep track of customer promise to pay commitments.

What can I do with this report?

You can track the payment progress of customers who have made promises to pay on their accounts.

What type of report is this?

Oracle Business Intelligence Publisher

Validate Customer Dunning Setup Report

In the Validate Customer Dunning Setup Report you can view all the dunning setup issues of your customers. You can use this report to verify and identify gaps of dunning configurations. For example the report can display missing customer e-mail, fax, or contact name. This report only shows those customers who have open transactions.

This image shows a sample of Validate Customer Dunning Setup Report

This graphic illustrates the Validate Customer
Dunning Setup Report details.

Report Parameters

This table shows all the required parameters for creating Validate Customer Dunning Setup Report.

Name Description

Business Unit

Select the appropriate business unit.

From Collector Name

Starting range of collectors.

To Collector Name

Ending range of collectors.

From Customer Account

Starting range of customer accounts.

To Customer Account

Ending range of customer accounts.

From Customer Name

Starting range of customer names.

To Customer Name

Ending range of customer names.

Frequently Asked Questions

This table lists some frequently asked questions about the Validate Customer Dunning Setup Report.

FAQ Answers

Where can I find this report?

On the Navigator menu click on the Scheduled Processes work area to schedule and run these reports.

Who uses this report?

  • Financial Manager

  • Financial Specialist

When do I use this report?

You can use this report when configuring your dunning setups for customers, accounts, or by collector.

What can I do with this report?

Use this report to validate and identify gaps in the dunning setup for customer, accounts, or by collector.

What type of report is this?

Oracle Business Intelligence Publisher

Collections Confirmation Notices

This topic includes detailed information about the various activities for the collections confirmation notices.

Overview

The collections confirmation notices provide details on submitted activities: disputes, payments, and promises. You can use these notices to inform customers of the action taken on their accounts.

Confirmation Notices include:

  • Collections Dispute Confirmation Delivery: Provides the details of the dispute submitted. The notice contains the dispute number, amount, and creation date prior to approval.

  • Collections Payment Confirmation Delivery: Provides the details of the payment submitted. The notice contains the dispute number, amount, and creation date prior to approval.

  • Collections Promise Confirmation Delivery: Provides the details of the promise submitted. The notice contains the promise amount and date.

Key Insights

These confirmation notices are used to provide a printed form of the commitment to customers reaffirming the agreement made during a conversation with the customer. These notices are generated only when they are configured in Manage Collections Preferences, in the Correspondence section, and set to Yes to automatically generate the notice.

Report Parameters

These notices are automatically generated if configured to do so, when you submit a dispute, apply a payment, or enter a promise. Therefore no parameters are required.

Frequently Asked Questions

The following table lists frequently asked questions about the collections confirmation notices.

FAQ Answers

How do I find these notices?

Schedule and run these notices from the Scheduled Processes work area on the Navigator menu.

Who uses these notices?

  • Financial Manager

  • Financial Specialist

When do I use these notices?

Use these notices to:

  • Correspond with customers who have recent activity applied to their accounts.

  • Document and record the activity applied to a customer account.

What can I do with these notices?

Inform customers through correspondence of activity performed on their account.

What type of notices are these?

Oracle Business Intelligence Publisher