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

Last updated on DECEMBER 27, 2022

Applies to:

Symptoms

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 with Unidentified status

Changes

Cause

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