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_PERSON_ALLOCATED_TASKS_DFF SQL Type
Content
Hello Guys,
We would create a task to allow the employee to confirm their Hire Date. We used "Configurable Form" by configuring the DFF "PER_PERSON_ALLOCATED_TASKS_DFF" with a SQL type Field.
We just try to use this SQL expression:
select DISTINCT pos.DATE_START, PP.PERSON_NUMBER
from PER_PERIODS_OF_SERVICE pos
JOIN PER_ALL_ASSIGNMENTS_F PAF on POS.PERIOD_OF_SERVICE_ID = PAF.PERIOD_OF_SERVICE_ID
JOIN PER_PEOPLE_F PP ON PP.PERSON_ID = PAF.PERSON_ID
where paf.PERSON_NUMBER = 31790
In this way, We had the possibility to bring in the field the Start Date, but we need to extract the information of current pending worker, is there a way to keep in a query a dynamic person_id of the employee?
Tagged:
1