My Oracle Support Banner

R12:CE: CECAMTLD CAMT Bank Statement Loader Errors: "SQLCODE:-1422 Sqlerrm :ORA-01422: Exact Fetch Returns More Than Requested Number of Rows" (Doc ID 2774150.1)

Last updated on MARCH 14, 2022

Applies to:

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

Symptoms

When trying to load a CAMT bank statement, the Bank Statement Loader program errors with below message visible in the log file:

CECAMTLD: CAMT Bank Statement Loader has the following error:

SQLCODE:-1422 Sqlerrm :ORA-01422: exact fetch returns more than requested number of rows

Steps to reproduce:

  1. In Cash Management, Go to the Submit Requests window
  2. Submit the CAMT Bank Statement Loader

Changes

 no changes

Cause

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
Symptoms
Changes
Cause
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.