Unable to Obtain a Custom Field Value from the Resource New View in Groovy Script (Doc ID 2697776.1)

Last updated on JUNE 02, 2023

Applies to:

Symptoms

On : 11.13.20.04.0 version, Accounts, Contacts, Households

ACTUAL BEHAVIOR
---------------
For some users, unable to obtain a custom field value from the Resource new view in groovy script.

EXPECTED BEHAVIOR
-----------------------
The groovy script should return the custom field value from the Resource new view for each user.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Script:
if(matchingFieldName!=null && matchingFieldValue!=null && outputFieldName!=null) {
def vo = newView('Resource');
def vc = vo.createViewCriteria();
def vcr = vc.createRow()
def vci1 = vcr.ensureCriteriaItem(matchingFieldName);
vci1.setOperator('=')
vci1.setValue(matchingFieldValue)
vci1.setUpperColumns(true)
vc.insertRow(vcr)
vo.appendViewCriteria(vc)
vo.executeQuery();
if (vo.hasNext()) {
def srow = vo.next();
return srow.getAttribute(outputFieldName);
}
}

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot obtain a custom field value from the Resource new view in groovy script.

Changes

Cause

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