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

PER_EXT_ASG_USER_PERSON_TYPE not fetching any values while recurring through while loop

edited Jan 27, 2020 11:22PM in HCM Integrations 4 comments

Content

We are recurring a while loop that checks person relationships and in that, we are trying to check the user person type for that assignment like employee contingent worker etc. while recursing through while loop no data is fetched for the person.


l_abs    = 1

WHILE (PER_EXT_WORK_REL_DATE_START.EXISTS(l_abs)) LOOP
 (
   l_person_type=PER_EXT_ASG_SYSTEM_PERSON_TYPE[l_abs]

The above statement simply does not grab any value and prints the default value. Can anyone suggest the correct DBI or explain the issue with this dbi.

 

 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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