Reports Error: Journal Entries Report Completes In Error - Sql-02112: Select..Into Returns Too Many Rows (Doc ID 1361540.1)

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

Symptoms

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
XLA_MO_REPORTING_API.Initialize(:p_reporting_level,:p_reporting_entity_id,'AUTO','N');

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.

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