Fetch Value From Related Object In Custom Object (Doc ID 2249549.1)

Last updated on APRIL 04, 2017

Applies to:

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

Goal

We have a formula field called Program manager on Signup_c custom object.

We want to pull the value of Program manager field and pass it to EmailAddress criteria item in the field.

/
// Code to Query Resource
def vo = newView('Resource');
def vc = vo.createViewCriteria()
def vcr = vc.createRow()
def vci1 = vcr.ensureCriteriaItem('EmailAddress')
vci1.setOperator('=')
vci1.setValue('jdharmarajan@serencorp.com')
vc.insertRow(vcr)
vo.appendViewCriteria(vc)
vo.executeQuery()
while(vo.hasNext()){
def row = vo.next();
def fName = row.getAttribute('PersonFirstName')
def lName = row.getAttribute('PersonLastName')
def fullName = fName+ " " +lName
return fullName;
}
 

Solution

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