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.
How to extract the hire date of the first work relationship in oracle HCM
Summary:
How to extract the hire date of the first work relationship in oracle HCM
Content (required):
Hi,
we would like to build a BI Publisher Report, which contains several pieces of information (both personal and employment pieces of information) about all the employees of our company. Inside this report we would like to enter the hire date of the first work relationship of the employee (for instance if the employee was hired on 31/12/2019 and this first work relationship terminated on 31/12/2020 and finally he/she was rehired on 21/12/2021; we would like to extract the 31/12/2019 hire date). We tried with ORIGINAL_DATE_OF_HIRE field in the per_periods_of_service, however several employess have a wrong first hire_date.
Tagged:
0