My Oracle Support Banner

Using groovy trigger to obtain the value of a custom field from Resource object is not returning the expected values. (Doc ID 2429195.1)

Last updated on AUGUST 10, 2018

Applies to:

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

Symptoms

On : 11.13.18.02.0 version, Accounts, Contacts, Households

ACTUAL BEHAVIOR
---------------
Using groovy trigger to obtain the value of a custom field from Resource object is not returning the expected values.

EXPECTED BEHAVIOR
-----------------------
SQL shows the value should be TMLK, debug statement in groovy shows the value is 'CALL CENTER,TELEMARKETING ATIVO' and the PartyId is 300000497330146.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Sign-on to Sales Cloud application
2. Add trigger to
Custom object: Chamados_c
Object Trigger: After create
Groovy:
def partyID = adf.util.getUserPartyId()
def EmployeeObj = newView('Resource')
adf.util.applyFilter(EmployeeObj,[PartyId:partyID])

def rowEmployee = EmployeeObj.first()
def setores = rowEmployee.SetorSPC_c
throw new oracle.jbo.ValidationException(setores)

3. The value of setores is not the one shown in the UI on the Resource record or through SQL

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, the value returned is not what is expected.

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.