You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started with Redwood for Oracle Cloud HCM   Begin Now

Groovy Script not importing Grade fields from HCM

We are Attempting to bring in the Primary Point of Contact's Grade from HCM into Helpdesk Classic screens- the script being used works for other fields but not Grade- any ideas

Here is the script:

def vo = newView('oraHcmUserNoDetailVO')

def Assignmentvo=newView('oraHcmAssignmentVO');

def gradevo = newView('oraHcmGradeVO')

def criteria = vo.createViewCriteria();

def criteriaRow = criteria.createRow();

def criteriaItem1 =criteriaRow.ensureCriteriaItem('Username'); // We can also use partyid

criteriaItem1.setOperator('=');

criteriaItem1.setValue(adf.context.getSecurityContext()?.getUserProfile()?.getUserID()); 

criteria.insertRow(criteriaRow);

vo.appendViewCriteria(criteria);

vo.executeQuery();

def row

def PersonID

if(vo.hasNext())

{

row=vo.next()

PersonID=row?.PersonId;

Assignmentvo.appendViewCriteria("PersonId=${PersonID} and PrimaryAssignmentFlag='Y' and AssignmentStatusType='ACTIVE'")

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!