My Oracle Support Banner

Common Problems and Solutions Process Customer Payments – Process Receipts: Lockbox Receipts (Doc ID 1390986.1)

Last updated on JULY 31, 2020

Applies to:

Oracle Fusion Receivables - Version 11.1.1.5.1 and later
Information in this document applies to any platform.

Purpose

 If you are a Software-as-a-Service (SaaS) customer, the following section need not be performed by you. Please log a Service Request in My Oracle Support for Oracle to do this for you.

 

Summary

Lockbox is a service that commercial banks offer corporate customers to enable them to outsource their accounts receivable payment processing. Lockbox ESS program can process millions of transactions a month. AutoLockbox eliminates manual data entry by automatically processing receipts that are sent directly to your bank. This program can import the payment information from the data files provided by the banks, validate the information and create payments in the receivables system. This program can automatically identify the customer who remitted the receipt and optionally use AutoCash rules to determine how to apply the receipts to customer's outstanding debit items. In Fusion, we have a new feature in Lockbox program to improve the reference matching capabilities of Lockbox program called AutoApply where the invalid references from the bank data file will be matched against the valid references in the system with user defined matching rules.
Different phases in the Lockbox program

Import

This phase AutoLockbox reads and formats the data from your bank data file and writes it into the Lockbox interface table using Oracle SQL *Loader.

Validation

The validation program validates data in the Lockbox interface table against the Receivables data. Validation failures will be written into the Lockbox Execution Report.

AutoApply

This is a new feature in Fusion in which if enabled, the system will try to resolve the invalid transaction and customer references provided in the data file against corresponding values in Receivables, using a reference scoring based on the AutoMatch Rule Set setup.

PostBatch

This process will create payments and applications in receivables from the validated data and updates the customer balances
Prerequisite Setups to run Lockbox program

1. Define Receipt class with appropriate Remittance bank account associated


2. Define Receipt Source which is of automatic batch numbering, manual type and with default receipt class, receipt method and bank account



3. Define Lockbox setup with appropriate Receipt Source, Receipt Method and Receipt Match By



4. Define Transmission Format so that the layout is in accordance with the bank's requirements.



5. Associate proper Receipt Match By's at the following levels in the decreasing order of preference as per required by business


6. Define AutoCash Hierarchy with appropriate AutoCash Rules if used in PostBatch.
Associate proper AutoCash Hierarchy at the following levels in the decreasing order of preference as per required by business


7. If AutoApply feature is used, define AutoMatch Rule Set with appropriate matching rules Associate proper AutoMatch Rule Set at the following levels in the decreasing order of preference as per required by business where ever you have assigned a to Receipt Match By


8. If Application Exception Rules is used in PostBatch, define the same and associate it at the following levels in the decreasing order of preference as per required by business

 

Troubleshooting Steps

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
  
 
 Summary
 Import
 Validation
 AutoApply
 PostBatch
Troubleshooting Steps
 Lockbox Validation Error Correction
 Enabling logging in Lockbox/PostBatch
 Enabling SQL Trace in Lockbox/PostBatch
 Dependent Technologies
 Problems & Solutions
 1. Import program failing with invalid control file/data file
 Problem:
 Solution:
 2. Validation program marking the transaction reference invalid even though the valid reference exist in the system
 Problem:
 Solution:
 3. Receipt source is not showing in the list of values while creating Lockbox setup
 Problem:
 Solution:
 4. AutoApply is not generating the recommendations for closely matching transaction references in the system
 Problem:
 Solution:
 5. AutoApply Process is not kicking off after the Lockbox validation program
 Problem:
 Solution:
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.