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

Auto lockbox – Let’s connect with Bank

Posted on June 29th, 2007 by Sanjit Anand ||Email This Post Email This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today

Auto Lockbox is a service that commercial banks offer corporate customers to enable them to outsource their accounts receivable payment processing. Auto Lockbox eliminates manual data entry by automatically processing receipts that are sent directly to your bank. You can also use Auto Lockbox for historical data conversion. For example, you can use Auto Lockbox to transfer receipts from your previous accounting system into Receivables. Auto Lockbox ensures that the receipts are accurate and valid before transferring them into Receivables.

Benefit of auto lockbox

  • Eliminates manual data entry
  • Streamlines the application of receipt to outstanding transactions
  • Effectively manages cash flow by reducing turnover for converting checks into cash

When can I use lockbox

  • apply receipt to outstanding invoice
  • import historical receipt data
  • auto lockbox report , such as the post quick cash Execution Report, are a good tool to reconcile auto lockbox receipt with the bank transmission

What is inside the lockbox process

This consist of 3 steps process, viz

1. Import: During this step, Lockbox reads and formats the data from your bank file into interface table AR_PAYMENTS_INTERFACE_ALL using a SQL *Loader script.

2. Validation: The validation program checks data in this interface table for compatibility with Receivables. Once validated, the data is transferred into QuickCash tables (AR_INTERIM_CASH_RECEIPTS_ALL and AR_INTERIM_CASH_RCPT_LINES_ALL) . At this point, you can optionally query your receipts in the QuickCash window and change how they will be applied before submitting the final step, Post QuickCash.

3. Post QuickCash: This step applies the receipts and updates your customer’s balances.

Process Flow
Here is schematic data flow and process flow of lockbox process


Set Up
These are the Normal Set Required for Auto lockbox. This is part of AR Set up:

  • Define Banks
    • Define Remittance Bank with Account use Internal where checks from customer are deposited.
  • Define Receipt Class
    • Define a Receipt class to determine the required processing steps for receipts to which you assign payment methods with this class.
  • Define Payment Methods
    • Define a payment method with all receipt accounts.
  • Define Receipt Source
    • Define Receipt Batch Source and attach receipt class, payment method and remittance bank account information to the Receipt Source.
  • Define Lockbox
    • Define Lockboxes to use the Receivables Autolockbox program.
  • Define Transmission Format
    • Define the Transmission Format which Auto Lockbox uses when importing data into Receivables.
  • Define AutoCash Rule Set
    • autocash rule sets determine how a quickcash receipt is applied to open debit items.
    • enter a sequence for automatiocally applying receipts
    • select one or more autocash rules for receipt application from the list of autocash Rule options
    • Define AutoCash Rule Sets to determine the sequence of rules that Post
    • QuickCash uses to update Customer’s account balances.
  • Control file
    • Create a control file which is used by SQL * Loader to import the data into interface table and it is placed in the directory $AR_TOP/bin
  • Data file
    • data are kept into directory $AR_TOP/bin
Related Posts

Posted in API Integration, Oracle Receivable | 9 Comments »Email This Post Email This Post |

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today
9 Responses
  1. Regarding Auto Lcokbox in AR receipt import - Exforsys Says:

    […] by Kurakin LockBox OracleApps Epicenter | Auto lockbox – Let’s connect with Bank Auto lockbox – Let’s connect with Bank Oracle API Availability – Oracle Receivables (AR) Oracle API Availability – Oracle Receivables […]

  2. 15 important things before you can do Auto lockbox setting? Says:

    […] Auto lockbox Implementation been never been an easy task. Though it requires own set up to handle this functionality. Therefore Its is very important to understand some key points before implementing Lockbox in Oracle. […]

  3. Lockbox - Functional Prospective Says:

    […] steps should be prerequisite as per this […]

  4. Led Smith Says:

    This info is very good.
    We are using a good interface system in my company: Conviface with this system this interface is easy to do it. Better that the Oracle Method.

  5. naseer Says:

    I want to import Receipts data from a third party application into Oracle Receivables. Can you guide me the required setup?

  6. Kamana Singh Says:


    I am trying to test a prototype of the AR lock box setup. I am trying to just populate the AR_PAYMENTS_INTERFACE_ALL table with the relevant receipt data to ensure the receipt gets imported successfully, before I start mapping the bank file to the AR_PAYMENTS_INTERFACE_ALL table.

    Can anyone send me the data that needs to be loaded into the AR_PAYMENTS_INTERFACE_ALL table from a working AR lock box implementation. I will modify the data per my test data as required.

    Thanks in Advance

  7. John Says:

    this is good… we used CONVIFACE in our project.

  8. John Says:

    this is good… we used CONVIFACE in our project

  9. Shripad Says:

    A very nice article.

Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.