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.
Identify Hire Dates that are any date in the Next Week
Summary:
I have an OTBI report using subject area Workforce Management - Work Relationship Real Time. On the Advanced tab, I have already entered the prefix SET VARIABLE PARAM_EFFECTIVE_DATE='4712-12-31'; so that it will pick up future dates.
The report runs several times during the week, identifying new hires (Work Relationship Start Dates) that are any date in the NEXT WEEK (Sun - Sat).
FOR EXAMPLE:
If the report runs on Mon 6/3/24, it will pick up Hire Dates that are any date during NEXT week, for example 6/9, 6/12, 6/15
If the report runs again on Thur 6/6/24, it will pick up those same Hire Dates that are NEXT week 6/9, 6/12, 6/15
Tagged:
0