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.
HCM Extract not giving output as expected.
Summary
HCM Extract not giving output as expected.Content
Hi All,
For employee code: 22688, transfer was done in the system on 5th Sep-19.
In the output data of 6th Sep-19 we are getting incorrect data, we are getting Manager code '24003' insted of '20600'.
Please find the below Fast Formula we are using in this Extract to get the Manager code for the current employee's and the terminated employee's
DEFAULT FOR PER_ASG_MGR_PERSON_NUMBER is ' '
DEFAULT FOR PER_ASG_REL_ACTUAL_TERMINATION_DATE is '4712/12/31 00:00:00' (DATE)
l_term_date = PER_ASG_REL_ACTUAL_TERMINATION_DATE
Tagged:
0