Object Workflow Triggering Email Is Not Working As Expected. (Doc ID 2497284.1)

Last updated on NOVEMBER 17, 2019

Applies to:

Goal

On : 11.13.18.10.0 version, Opportunities

Object Workflow Triggering email is not working as expected.

We are facing some Issue with Object Workflow. The Issue is as below.

The Requirement is: Whenever a New Opportunity is getting created for an Account with a Financial Parent(Financial Parent is a Custom DCL field in Account Object), an Email should be sent to the Account Owner of the Financial Parent.

To achieve this requirement we have Created one Text Field in Opportunity Object to hold email Address of Financial Parent Owner.
Below is the script we have used to get the email address into Text Field.

def voPerson = newView('PersonProfile')
def searchExpression = 'PartyId = ' + Organization?.dnvgl_FinanceParent_Obj_c?.OwnerPartyId
voPerson.appendViewCriteria(searchExpression)
voPerson.executeQuery()
  if(voPerson?.first() != null){
  def row = voPerson.first()
  def emailAddress = row.getAttribute('PrimaryEmailAddress')
  setAttribute('dnvgl_FinancialParentOwnerEmail_c',emailAddress)
}

And we have created an Object work flow for Opportunity Object with Event point Condition (When a record is created) and in email notification To Address I have selected the Custom Text field which holds the email.

But email is not getting triggered to the email that is in the Text field.
 How to achieve all the above?
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.