Statement Printing Error: ORA-1422 Exact Fetch Returns More Than Requested Number Of Rows
Last updated on AUGUST 24, 2016
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'
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