How to expose either the "Customer Contact Profile" or the "Relationship" below Account or Contact?

(Doc ID 2129409.1)

Last updated on JUNE 20, 2017

Applies to:

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

Goal

Currently there is standard object "Customer Contact Profile" acting as intersect table between Account and Contact objects.
This "Customer Contact Profile" is exposed as ootb below the Account Object. However we could not expose this intersect table "Customer Contact Profile" under the Contact object.

On the other hand, from the Contact object, one can use the "Relationship" object to link the Contact record to another Contact or to an Account record (ootb feature)
However this "Relationship" object cannot be exposed under Account.

So, how do we go about creating M:N relationships between Accounts and Contacts? (e.g. one Account can have multiple Contacts linked to it and one Contact can be linked to multiple Accounts, with different Roles of course)
Seems we have at least 2 standard intersect tables in between 2 high Level Objects, but None of them can be exposed simultaneously from both sides.

How to expose either the "Customer Contact Profile" or the "Relationship" below Account or Contact?
 

Solution

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