Statement Printing Error: ORA-1422 Exact Fetch Returns More Than Requested Number Of Rows
(Doc ID 1518637.1)
Last updated on DECEMBER 04, 2019
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