My Oracle Support Banner

How to expose either the "Customer Contact Profile" or the "Relationship" below Account or Contact? (Doc ID 2129409.1)

Last updated on MARCH 29, 2019

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 to 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 there are 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

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
Goal
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.