Posted by anilrpatil on October 24, 2009
The Objective of this document is to explain how we migrated Call Notes from AR to Advanced Collections
Our client is implementing Advanced Collections. The Client is currently using AR Collections Workbench to manage its Collections Activities. As such the Call notes are currently maintained in AR in the Customer Calls form as a Response Note or a Call Topic Note . These notes are either at the account level or a transaction level. When the Collectors switch to the Collections form in Advanced Collections, the AR Call notes cannot be viewed in the Notes Tab. Hence there is a need to migrate the AR Call notes from AR to Advanced Collections
Click here to read our solution
[Keywords: JTF_NOTES_PUB, API, CRM Notes]
Posted in Advanced Collections, Receivables | Tagged: Advanced Collections, anilrpatil, API, JTF, JTF_NOTES_PUB, Oracle Applications, Oracle Financials | Leave a Comment »
Posted by anilrpatil on October 24, 2009
Automation of manual activities is the norm and that’s where Oracle Standard API’s helps me a lot. The Business scenario for my client is as follows
1. The Client imports feeder system transactions data into Oracle Receivables using RA INTERFACE
2. Credit Memo’s are imported as On-Account Credit Memo’s because there is not enough matching data available in the feeder system that would allow creating Credit transactions against the Invoices through autoinvoice.
3. The Credit Memo number and the related transaction number are maintained in a custom staging table.
4. The requirement was to be able to apply these On-Account Credit Memo’s to the Invoices.
Click here to read our solution
[Keywords: On-Account Credit Memo, AR_RECEIPT_API_PUB]
Posted in Receivables | Tagged: anilrpatil, On-Account Credit Memo, AR_RECEIPT_API_PUB, Oracle Financials, Oracle Applications | Leave a Comment »
Posted by anilrpatil on October 23, 2009
The Objective of this document is to explain how we implemented Different Strategies for Different Operating Units in Advanced Collections using Strategy Filters
Our client is implementing Advanced Collections on a Multi-Org environment. The Client has operations in many countries and each country is defined as an operating unit. The work culture is different in most of the countries and hence the Collections Strategies are also different. A common global strategy cannot be applied to the Accounts of different countries and hence the need to have different strategies assigned to the Accounts pertaining to different operating units
[Keywords: Advanced Collections Strategies, Advanced Collections Filters]
Posted in Advanced Collections | Tagged: Advanced Collections, Advanced Collections Filters, Advanced Collections Strategy, anilrpatil, Oracle Applications, Oracle Financials | Leave a Comment »
Posted by anilrpatil on October 18, 2009
The purpose of this document is to explain how we rectified some of the recurring Lockbox Errors our client encountered using a custom concurrent program.
The users run the Lockbox process daily. Many receipts are rejected because either the lockbox data is incorrect or it conflicts with the Customer Setup data. The users have to manually correct the lockbox transmission data, which is a time consuming activity. There was therefore a need to write a small magic program (magic – because that’s what my client calls it) that would do the data rectification and clear most of the Lockbox errors. We created a custom concurrent program that the users ran after the first run of the Lockbox process.
The details of the different types of recurring errors encountered and our solution for the same is as follows…
Click here to read our solution for rectifying the lockbox errors
[ Keywords: Lockbox, Receipts, MICR, AR_PLB_BAD_MICR_NUM, AR_PLB_CUSTOMER_CONFLICT, AR_PLB_CUST_NUM_CONFLICT, Cash Application ]
Posted in Receivables | Tagged: Lockbox, Receipts, MICR, AR_PLB_BAD_MICR_NUM, AR_PLB_CUSTOMER_CONFLICT, AR_PLB_CUST_NUM_CONFLICT, Cash Application, anilrpatil, Oracle Financials, Oracle Applications | Leave a Comment »
Posted by anilrpatil on October 14, 2009
One of our Clients has implemented Advanced Collections and is running their strategies at ‘Account Level’. To manage the collections activities proactively, they felt the need of notifying the Collectors in advance of some high dollar amount invoices that would get due in the next ‘x’ number of days. The Collectors can then give a pre-delinquency phone call to the customer to check if all is fine and if they can expect the payment on or before the due date. This would help them in better Collections. If there are any issues like Invoice not received, Error in Billing or any other issue, they can get it resolved well in advance. The need was for a fully automated solution that would create a task to notify the collectors and the collectors can access and work on their task from their Collections Work Queue.
This document describes how we created tasks for ‘Pre-Delinquency Calls’ and assigned the tasks to the Collectors. Click here to read about our solution
[ Keywords: Advanced Collections, API, Delinquency, Deleinquent, JTF, JTF_TASKS_PUB, Tasks ]
Posted in Advanced Collections | Tagged: Advanced Collections, Delinquent, Delinquency, Tasks, API, JTF, JTF_TASKS_PUB, anilrpatil, Oracle Financials, Oracle Applications | 1 Comment »
