Fusion Applications OTBI: When Creating A Sale Pipeline Report Using "Product Name" Or "Product Type" From "Product" Object The Revenue Field Is Empty / Blank . (Doc ID 1572046.1)

Last updated on FEBRUARY 23, 2017

Applies to:

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

Symptoms

Fusion Applications Transactional Business Intelligence analysis design

 

After creating a report that uses "Sales - CRM Pipeline" subject area.
Observed that when using "Opportunity Revenue" field from "Pipeline detail facts" under "Fact" object along with "Product Name" or "Product Type" from "Product" object the Revenue field is empty.
But if  "product name" or product type" are removed from the report than revenue field show values.

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