ECM: Automatic reconciliation Results in 'Not Found in System' (NTF) exception when the Case of Payment Reference is Different Between Bank Statement and System Transaction (Doc ID 2066642.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

PeopleSoft Enterprise FIN Cash Management - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Automatic reconciliation results in 'Not Found in System' (NTF) exception when the case of Payment Reference is different between Bank Statement and System transaction

STEPS:
1) Load a Bank Statement with payment reference as 'testref' in lowercase
2) Import an External Transaction into PeopleSoft using CI and this transaction has the reference in lowercase
3) Once the External Transaction is loaded into PeopleSoft, the case of the reference changes to Upper
4) Run Automatic Reconciliation process (FSPRECON) and notice that the bank statement transaction line has an exception 'Not Found In System'

EXPECTED BEHAVIOR:
Automatic Reconciliation process should successfully reconcile the transactions irrespective of the case of the reference

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