Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
PER_EXT_ASG_USER_PERSON_TYPE not fetching any values while recurring through while loop
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.
0