Anil R Patil's Oracle Applications Blog

An Oracle Applications Knowledge Repository and Solution Center

Posts Tagged ‘anilrpatil’

Rectifying Lockbox Errors Programmatically

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: , , , , , , , , , | Leave a Comment »

Advanced Collections – Creating Tasks for Pre-Delinquency Calls

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: , , , , , , , , , | 2 Comments »

 
Follow

Get every new post delivered to your Inbox.

Join 47 other followers