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