Custom DCL pointing to Opportunity Revenue child object is read-only on Outlook Pages (Doc ID 2278190.1)

Last updated on JULY 12, 2017

Applies to:

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

Symptoms

On : 11.1.11.1.0 version, Microsoft Outlook


ACTUAL BEHAVIOR
---------------
After adding a custom DCL on Opportunity Revenue child object of Opportunity object in SUI and it is worked fine. But when the field was added in Edit Opportunity Revenue Search on Opportunity Outlook pages It saved successfully.
When attempting to take it off it is frozen (grayed out and inaccessible).
Outlook logs present an error [ERROR] [Script Engine]: widget_controllers.js(1953,2) : Script run-time error. Singe- and poly-join columns are not supported by Outlook data-source ( 0x80004005)

EXPECTED BEHAVIOR
-----------------------
Custom field should be available to be taken off in Edit Opportunity Revenue Search on Opportunity Outlook pages.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Application Composer -> Sales -> Opportunity -> Opportunity Revenue -> Pages -> Outlook Pages -> Revenue Form -> Default Layout - Find the DCL correctly exposed.
2. Navigate to Application Composer -> Sales -> Opportunity -> Pages -> Outlook Pages -> Opportunity Revenue Search Decor DCL appears Grayed out on Selected fields column.
3. Outlook Opportunity form is not rendering correctly and showing as Contact native form.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot use Opportunity in Outlook.

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