Anil R Patil's Oracle Applications Blog

An Oracle Applications Knowledge Repository and Solution Center

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 ]

Advertisement

Leave a Reply

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

Please log in to WordPress.com to post a comment to your blog.

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Connecting to %s

 
Follow

Get every new post delivered to your Inbox.

Join 37 other followers