Implementing Oracle Advanced Collections

Posted on November 19th, 2012 by Sanjit Anand || 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

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
    • 
    • 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

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

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

1. Oracle R12 Financials Enhancements Cheat Sheet – > Advanced Collection
2. Dunning and EBS R12
3. Understanding Security in : Oracle Financials and Manufacturing
4. MOAC :”Multi-Org Preferences”
5. ADVANCED AUDIT