My Oracle Support Banner

Fusion Applications OTBI: Counts Data seems inconsistant when we compare one analysis to another (Doc ID 1593135.1)

Last updated on OCTOBER 21, 2020

Applies to:

Oracle Fusion Application Toolkit Cloud Service - Version 11.1.5.0.0 and later
Oracle Fusion Profile Management - Version 11.1.1.5.1 and later
Oracle Fusion Application Toolkit - Version 11.1.1.5.1 and later
Information in this document applies to any platform.

Symptoms

Fusion Apps 11.1.7.0.0 Cloud OTBI

Unexpected behavior
===================

CUSTOM Pivot report shows 2223 and detail report shows that there are 2131 performance goals.

Steps
=======

Navigation : Dashboards->Custom-> ..


1. Go to “goal counts” tab and leaving all the prompts to have default values, select only one BU from the BU prompt.
 

2. Notice the Grand total in “#of goals by goals category” report.

 
3. In the same tab, we have placed detail report which is same as above but displays data in tabular view.
 

Issue we notice

In the detail report from step 4, if you count the number of “performance goal names” you notice that
 

The pivot report shows 2223 and detail report shows that there are 2131 performance goals.


There is no count distinct any of these reports.

Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.