Belgium Localization, Not Able to Reconcile Bank Statements When Receipts are Imported Through CLE: Multi Org process (Load and Lockbox) program
Last updated on JANUARY 04, 2017
Applies to:EMEA Add-on Localizations - Version 12.1.3 to 12.2.3 [Release 12.1 to 12.2]
Information in this document applies to any platform.
Belgium Localization, CLE: Multi Org process (Load and Lockbox) program is importing receipt number with IBAN Number.
Receipt number is created as Year/Sequence Currency sub-sequence/IBAN.
instead of receipt number with Bank Account Number, "Year/Sequence Currency sub-sequence/Bank Account Number".
As a consequence, it is not possible to reconcile bank statement with above imported receipts.
The lockbox creates the receipt number in AR 15/207EUR0011/BE82825280430068
and the statement loader places 15/207EUR0011/825280430068 on the statement line in the number field.
As these values are different the auto reconciliation does not work.
Receipt number is expected to be created as "15/207EUR0011/825280430068"
The issue can be reproduced at will with the following steps:
1. Upload bank data file in to server directory
2. Navigate to Receivables responsibility then execute CLE: Multiorg Process (Load and Lockbox) from Receivables responsibility
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms