Custom Subject Area : The Use Of Fields Of Child Object Reduce The Results In The Report (Doc ID 2141683.1)

Last updated on MAY 26, 2016

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.1.10.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.10.0.0 version, Custom Subject Area, Child Objects

ACTUAL BEHAVIOR
---------------
In a BI Report using CSA, when fields from a Child Object are selected along with fields from Parent Object, the result set is reduced.

EXPECTED BEHAVIOR
-----------------------
Customer expects All the results from the Parent Object to show irrespective of whether there are records (corresponding to the Parent) in the Child Object or not.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a CSA (with Opportunity as the Parent Object)
2. Add multiple child objects to the CSA
3. Publish the CSA and build a BI Report using the new CSA
4. In BI Report, select attributes from the Parent Object
Observe the number of records returned in the result
5. Modify the Report and add attributes from the Child Object
Observe that the number of records returned in the result gets reduced if there are no corresponding child records for any parent record.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, customer is unable to use the CSA accurately

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