The number of rows returned when a report is run is different than when it is emailed to the end user (limited to 75 rows/records) (Doc ID 1556338.1)

Last updated on APRIL 14, 2015

Applies to:

Oracle Fusion Global Human Resources - Version 11.1.4.0.0 and later
Business Intelligence Suite Enterprise Edition - Version 11.1.1.6.12 to 11.1.1.6.12 [Release 11g]
Information in this document applies to any platform.

Symptoms

On : 11.1.4.0.0 version, Technology Management - BI & Reporting

ACTUAL BEHAVIOR
---------------

When you run a report online, the output shows the correct number of records. However, when scheduling the Analysis Agent , the email content shows only 75 records, some expected rows are missing.


STEPS
-----------------------

  1. Log into /analytics.
  2. Run the report in question and observe that the number of records are greater than 75.
  3. Now, schedule the report using the Analysis Agent.
  4. The emailed report will have only 75 rows or records.



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