Lockbox Process Fails When Passing MICR (Bank Account + Routing Number) (Doc ID 2019179.1)

Last updated on NOVEMBER 23, 2015

Applies to:

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

Symptoms

On : 11.1.9.2.0 version, Process Customer Payments-Process Bank Deposits

ACTUAL BEHAVIOR
---------------
When running Lockbox, after populating the interface tables using Lockbox Import Interface spreadsheet template, and passing the customer's bank account and transit routing number, the customer account is not derived.

EXPECTED BEHAVIOR
-----------------------
The customer account should be derived when passing the bank account and routing number via lockbox.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Populate the Lockbox Import Interface spreadsheet template, including the bank account and routing number.
2. Run the lockbox import and validation process.
3. The receipt data is imported but the customer account is not derived and the receipt is Unapplied and Unidentified.


Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms