My Oracle Support Banner

How To Use Reconciliation Matching Rule - Advanced Criteria To Remove Leading Zero From Bank Statement Reference? (Doc ID 2605927.1)

Last updated on OCTOBER 30, 2019

Applies to:

Oracle Fusion Cash Management Cloud Service - Version 11.13.19.04.0 and later
Information in this document applies to any platform.

Goal

The solution addresses the business requirement of remove leading zeros from reconciliation reference if the corresponding record is having leading zeros in the bank statement file (as Oracle does not allow payment document number with leading zero).

In some cases, the bank reference contains zeros in the middle, in addition to leading zeros, within the same file, and same bank account. For example, the bank file can contain a combination of the following:

5100001
05100000002
00051000003
00510000004
00005111114

 

Solution

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
Goal
Solution
References


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