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 FEBRUARY 22, 2023

Applies to:

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


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, from <Note 1352529.1>, shows if more than one active Statement Site is defined per account.

The result is 'No Rows Returned'


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

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