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.