My Oracle Support Banner

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.


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


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

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