Belgium Localization, Not Able to Reconcile Bank Statements When Receipts are Imported Through CLE: Multi Org process (Load and Lockbox) program

(Doc ID 2089523.1)

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.

Symptoms

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.


Example:
--------------
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"

STEPS
-----------------------
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



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