My Oracle Support Banner

Statement Printing Error: ORA-1422 Exact Fetch Returns More Than Requested Number Of Rows (Doc ID 1518637.1)

Last updated on JUNE 05, 2018

Applies to:

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

Symptoms

Attempting to run Statements and receive the following error:

ORA-1422 exact fetch returns more than requested number of rows

If the Profile Option "MO: Security Profile" is NULL at the responsibility under which the statements are run, it runs successfully.

The Statement log can also show the following error:

arxsgp: Error in main.
-2112 SQL-02112: SELECT..INTO returns too many rows

The following query has been taken from <Note 1352529.1>, which shows if more than one active Statement Site is defined per account.

The result is 'No Rows Returned'

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
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.