Display Contact fields in Account subview

Admins can configure the Contact subview in Account to display both standard and custom fields from the Contact object, leveraging the many-to-many relationship between Accounts and Contacts. By using join fields, this capability enables fields from the Contact object to be shown within a drawer interface and on the Contact subview, allowing users to easily view and edit these details as needed.

The feature provides the ability to enhance data visibility and accessibility for administrators managing Many to Many (M:M) related objects. By allowing admins to display fields from a target object (Contact in this case) using join fields, organizations can streamline data management processes, improve reporting capabilities, and facilitate better decision-making. This feature ultimately leads to increased efficiency, reduced manual data handling, and a more user-friendly experience for administrators, enabling them to focus on strategic tasks rather than data retrieval.

Steps to enable and configure

Leverage the Visual Builder Studio to expose your applications. To learn more about extending your application using Visual Builder, visit Oracle Help Center > your apps service area of interest > Books > Configuration and Extension.

  • In App composer create Join Field PlaceOfBirth for "Customer Contact Profile" object
  • In VB for "AccountContact" layout create a field OrganizationContactEO_JOIN_ContactToPersonJoin_PlaceOfBirth and set "labelHint": "[[$functions.getJoinFieldLabel('OrganizationContactEO_JOIN_ContactToPersonJoin_PlaceOfBirth')]]",
  • map field template "OrganizationContactEO_JOIN_ContactToPersonJoin_PlaceOfBirth":"/joinFieldTemplate"
  • Write following Java script code:

define(['vx/oracle_cx_fragmentsUI/ui/self/resources/js/utils/joinFieldMetadataHelper'], (JoinFieldMetadataHelper) => {
  'use strict';

  class DataDescriptionModule {

    getJoinFieldLabel(attrName){

      return JoinFieldMetadataHelper.getJoinFieldLabelSync(attrName);

    }

    getJoinFieldHelp(attrName){

      return JoinFieldMetadataHelper.getJoinFieldToolTipSync(attrName);

    }

  }

  return DataDescriptionModule;
});