Custom Object FCL Associated to Standard Object FCL not Getting Set to the Standard Object Value

(Doc ID 2268121.1)

Last updated on MAY 19, 2017

Applies to:

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


On : version, Opportunities

Custom Object (Opportunity RFI) has been created and added as a sub-tab of Opportunity. Relationship between the two objs with DCL based on Opty object and Opty Name
There is a Department field on each object, Custom object record is to get the values set in the Opportunity and set it as the value in Custom object record
When Before insert trigger is fired, the Department field is not being set to the same value as the department field in Opportunity.

The customer object field should have the same value of the same FCL of opportunity

The issue can be reproduced at will with the following steps:
1. Create custom object and add as sub tab of Opportunity
2. Create Dynamic Choice List – Related Object = Opportunity, List Selection Display Value = Opportunity Name (Name)
3. Create custom field on Opportunity Fixed Choice list – Lookup Type
4. Opportunity has a custom field where the lookup Type has the same values as the custom object lookup type.
5. A Relationship has been created between Opportunity and custom object.
6. A Before Insert into Database Trigger created to set the value of customer object field to be the same value of the same FCL on Opportunity

if(Opportunity_c != null || Opportunity_c != ''){
return false

7. Open an Opportunity
8. Click subtab to create custom object record
9. Once custom object record is created, the field is not set with the same value in related opportunity record
10. Also before the record was created the Opportunity name was not set on the custom object so the relationship is not firing when record is created.

The issue has the following business impact:
Due to this issue, users cannot create related custom object records that are related to standard objects .


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