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

Last updated on AUGUST 24, 2016

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

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