My Oracle Support Banner

How to Fetch Primary Contact's Phone Fax Email In BI Reports (Doc ID 2459278.1)

Last updated on OCTOBER 12, 2018

Applies to:

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


In BI Analysis report using subject area ( Sales: CRM Customer Overview/Sales: CRM Customers and Contacts Real Time), the customer is trying to fetch Primary contact and details like Job title, phone number, fax, Email etc of Primary contact for an particular account.

Sales: CRM Customer Overview > customer > Primary Contact Name results into primary contact of an account
When they are trying to fetch Sales: CRM Customer Overview >Customer Contact Profile >Job Title/Primary Phone/Primary Fax result into all the primary Phone/Fax of all contacts present in that account not of the primary contact.

How can this be achieved?


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

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