CAMT Bank Statement Loader With Process Option Load, Import And AutoReconciliation Is Not Working (Doc ID 2153243.1)

Last updated on JUNE 24, 2016

Applies to:

Oracle Cash Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Bank Statement Load and Import

CAMT File Processing Sqlerrm :ORA-06502: PL/SQL: numeric or value error: character string buf

Issue is exactly the same as '12.1.3 CAMT File Processing Failed Sqlerrm :ORA-06502: PL/SQL: numeric or value error: character string buffer too small (Doc ID 1946660.1)'. Only the solution does not apply.

This only happens when the 'CAMT Bank Statement Loader' program is launched with process option 'Load, Import and AutoReconciliation'. With process option Load and Import and then separate AutoReconciliation there is no problem.


ERROR
-----------------------
ORA-06502
SQLCODE:-6502 Sqlerrm :ORA-06502: PL/SQL: numeric or value error: character string buffer too small



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run the CAMT Bank Statement Loader' program with process option 'Load, Import and AutoReconciliation'

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot run the CAMT Bank Statement Loader' program with process option 'Load, Import and AutoReconciliation', they need first to run With process option Load and Import and then separate AutoReconciliation.

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