Reports Error: Journal Entries Report Completes In Error - Sql-02112: Select..Into Returns Too Many Rows
Last updated on APRIL 04, 2013
Applies to:Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.
Checked for relevance 04-Apr-2013
When running Journal Entries report and the report is failing with error:
AR-ARRGTA: Oracle error in main.
-2112 SQL-02112: SELECT..INTO returns too many rows
Trace shows the program failed in arjiaj in call to
The problem has to do with MOAC. When the Journal Entries Report is run under a responsibility that has only one operating unit assigned to the MO: Security Profile, the report completes successfully. But when Journal Entries report is run under a responsibility that has multiple operating units assigned to the MO: Security Profile, the report completes in error.
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