Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Understanding “Dunning Plans” in Advanced Collections

Posted on January 20th, 2013 by Sanjit Anand ||Email This Post Email This Post

Dunning Plans in Advanced Collections replaced the Receivables Dunning Letter processing in Release 11i. Dunning Plans are relatively “simpler” way of implementing Advanced Collections.

If Dunning letters are used as part of the standard collection process, the Dunning Plans in Release 12 helps achieve the same result but adds more functionality by combining the score calculated using the scoring engine to pick the correct Dunning letter format.This implementation option also lets users create call back tasks in addition to sending the Dunning letters.

Dunning Letters in Release 12 are defined in the BI Publisher.

In 12 the word “delinquency” is new to most 11i users and this means an overdue item. .

dgreybarrowThere are 2 types of Dunning Plans that you may setup.

1. Days Overdue Method – based on the aging buckets you are using to collect your payments

You will setup the Dunning Plan and include Aging Bucket lines for each Aging Bucket Line you have assigned in your Aging Bucket.
For Example – if you are using a 7 Bucket Aging, then the Dunning Plan will have at least 6 Aging Bucket Lines.

2. Staged Method – based on the date of the last letter sent or Dunning Stage

When a Delinquency is created, the Staged Dunning Level is null. Once you run the Staged Dunning and that Delinquency is included in a letter, the Staged Dunning Level count is incremented. You may see this on the Transaction Tab if you bring up the Transaction and show the Staged Dunning Level count.

dgreybarrow Dunning plans limitations

  • Delinquency scoring engine and dunning plan scoring engine is one and same
  • Scoring engine values are used both for delinquency status determination and aging bucket line determination so it can be tricky to obtain desired functionality
  • A transaction can only be scored using one scoring engine – if you add a new scoring engine only new transactions will be scored with this
  • AR Aging Buckets are used for days overdue determination only – unless you customise scoring components
  • Only one aging bucket can be used per dunning plan

dgreybarrowRunning Concurrent Programs for Dunning Plans

You must run the following concurrent programs in Oracle Advanced Collections to execute dunning plans:

  • IEX: Promise Reconciliation: This program updates the open promise information in Advanced Collections with payments received in Oracle Receivables to determine outstanding items.
  • IEX: Territory Assignment: This program assigns collectors to customers who are using Oracle Territory Manager. You can assign collectors at the customer, account, or bill-to level. This program retrieves a list of available collectors for each territory and assigns the first collector on the list. If you are using Territory Assignment, it is advisable to run this concurrent program first whenever you run the IEX: Scoring Engine Harness.
  • IEX: Scoring Engine Harness: You can select up to five scoring engines to run at the same time. The scoring harness assigns a value to an object such as a customer, account, or bill to location. Another score determines whether transactions are delinquent, pre-delinquent, or current.
  • IEX: Send Dunnings for delinquent customers: This program sends the results of the scoring engine harness to Oracle XML Publisher to send out dunning correspondence.
  • IEX: Create Dunning And Broken Promise Call Backs: If you have dunning callbacks as part of your dunning plan, run this program to create callback work items to a collector’s task list in the Collector’s Work Queue.

dgreybarrow Dunning in Correspondence History

When you select the Correspondence history type on the History tab, Oracle Advanced Collections provides a review of all dunning events initiated by the dunning process. You can view this information by customer, account, bill to location, or delinquency data level. Summary level information on all dunning events are also displayed in the All history.

dgreybarrowWant to Preview the Dunning Letters Before They are Sent to Customers with Dunning Plans

Collections supports preview and selective dunning with “IEX: Send dunning for Delinquent customers” concurrent program ONLY.

There is no Preview/Draft functionality for Strategies when submitting the IEX: Bulk XML Delivery Manager manually.

Added the following parameters to “IEX: Send Dunnings for delinquent customers” concurrent program.
a. Preliminary : possible values are Yes/No
b. Process errors only : possible values are Yes/No
c. No of workers :

Following parameters can be used to process only particular/set of customer/account/bill to locations.
d. Customer name low :
e. Customer name high :
f. Account number low :
g. Account number high :
h. Billto location low :
i. Billto location high :

arrow“IEX: Send Dunnings for delinquent customers” concurrent program always spawns the “Oracle Collections Delivery XML Process (IEX: Bulk XML Delivery Manager)” to process/send the dunning letters.

dgreybarrow Migrating 11i Dunning Letter Sets to R12 Staged Dunning

  • Concurrent program “IEX: Dunning Letter Sets Migration for Staged Dunning”
  • and a profile option called ‘IEX: AR Dunning to IEX Dunning Migrated’ in 12.1.3

will allow you to migrate the dunning letter sets from 11i AR Dunning to R12 Advanced Collections.

dgreybarrow Know five most common Dunning Plan Issues

  • Missing Corresponding Template – you are missing a template name on an aging line or stage line in the Dunning Plan setup. See Note: 466328.1
  • AgingBucketLineId NotFound – you are missing an aging line in your Dunning Plan setup or you have not covered the range from 1-100 for each Aging line.
  • The send dunning flag in customer profile is set to no – The Send Dunning flag must be checked on the Customer Account or Bill To depending on your Business Level.
  • Missing Score – You have not run the IEX: Scoring Engine Harness for the scoring engine that you linked in the Dunning Plan. That Dunning Plan uses the scores created by the linked engine to send the Dunning Letters.
  • Required min Dunning amount in customer profile – You must set the minimum Dunning on the Account or Bill To depending on the Business Level.

Next Post will more focus on Scoring .

Posted in Advance Collection | No Comments »

Implementing Oracle Advanced Collections

Posted on November 19th, 2012 by Sanjit Anand ||Email This Post Email This Post

Oracle Advanced Collections is an enterprise application for collection professionals that simplifies and optimizes the task of performing the various collection activities. This module provides visibility into the collections cycle, helping companies plan and manage effective collection activities thereby reducing the DSO.

It is integrated in the E-Business Suite and covers key collections activities from managing delinquencies to customer interaction to collections.

Oracle Collections is integrated with AR, trade management, Lease Management and Oracle Loans

Advanced Collections is used to contact delinquent customers to collect overdue invoices. The collection process can be handled at various levels

  • Customer
  • Account
  • Bill To
  • Delinquency

Oracle Advanced Collections can be configured for

  • Collection Strategies/Dunning Plans
  • Processing Payments and for capturing Promise to Pay details
  • Recording Disputes
  • Scheduling customer Call-backs
  • Sending Dunning letters to customers

dgreybarrow Mandatory Setups for Advanced Collections

  1. Setting Up Users and Reporting Hierarchy
  2. Setting Up a Group
  3. Verify Group Setup
  4. Setting Up Manager Roles
  5. Creating a Resource, and Assigning Roles and Resource Groups
  6. Setting Up Employees as FND Users and Assigning Responsibilities
  7. Setting Up Collectors
  8. Setting Up Employees as CRM Resources
    • Responsibility:- CRM Resource Manager : Navigation:- Maintain Resources -> Import Resources
  9. Setting Up Preferred Currency
  10. Setting Up and Enabling Currency Conversion
  11. Setting Up Currency Codes
  12. Setting Up the Accounting Calendar
  13. Setting Up Calendar Types
  14. Setting Up Period Type Mapping
  15. Setting Profile Options for Multiple Currency
  16. Setting Up Reporting Currencies
  17. Setting Up Quarters as a Time Period in the General Ledger
  18. Entering GL Daily Conversion Rates
  19. Running Concurrent Programs to Set Up Pseudo Period Rates
  20. Setting Up Lookup Codes
    • Responsibility:- Collections Administrator : Navigation:- Lookup Types
      Add Lookup codes for IEX_Delinquency_Status, IEX_Dispute_Reasons, IEX_History_Type, IEX_UWQ_Labels
  21. Setting Up AR Aging Buckets
  22. Setting Up Collections Operational Data level
    • Responsibility:- Collections Administrator : Navigation:- Setup Checklist -> Operational Setup -> General Collections Information
    • advance collection
    • Select values for Aging Bucket, Operational Data Level, Access Level and functionality access
    • Select values for Default tab, Default Search Type, Default Payment Method etc
  23. Setting Up Collectors Access Levels
  24. Setting Up Notes, Tasks, and Calendar
  25. Setting up Scoring Components
  26. Setting Up Scoring Engine
  27. Setting Up Strategies/Dunning Plans
    • Create Dunning Plans – Select Name, Dunning Level, Aging Bucket, Effective Dates etc.
      • Responsibility:- Collections Administrator : Navigation:- Setup Checklist -> Collections Method Setup -> Create Dunning Plans
    • Create Dunning Plans – Select Aging Bucket Line details
      • Responsibility:- Collections Administrator : Navigation:- Setup Checklist -> Collections Method Setup -> Create Dunning Plans
  28. Enabling Multi-Organization Access
    Responsibility:- Collections Administrator : Navigation:- Setup Checklist

dgreybarrow Profiles that need to be set

  • IEX: Strategy Disabled :IF Strategies are being used select ‘No’ else this should be ‘Yes’
  • IEU: Queue % :Select ‘Yes’ if the node has to be displayed in UWQ
  • IEU: Queue Order % :Enter the number to select the display sequence in the UWQ
  • IEX: Strategy Default Template (only if strategies are being used) :Select the Default Strategy to be used
  • MO: Security Profile :Grouping of Operating Units that can be accessed.
  • MO: Default Operation Unit :Identify the default Operating unit

dgreybarrow Key R12 Enhacement

  • Multi-Org Access Control
  • Enhanced Customer Credit Card and Bank Account Management
  • New Implementation Checklist and questionnaire
  • Collections Functionality of AR migrated to Oracle Advanced Collections
  • Functionalities of Collections Forms Administrator and Collections HTML Administrator combined to a single responsibility Collections Administrator
  • Configuration process has been simplified.
  • Setup is performed using a questionnaire and Setup Checklist
  • Scoring Engines, Strategies and Dunning Plans configuration performed using setup checklist

Posted in Advance Collection, Oracle Receivable | No Comments »