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 - User entity PER_ASG_WORKING_HOUR_PATTERNS_UE does not return data
Content
We need to interface the workday patterns to the downstream systems, the workday patterns of the employees are either 1 week or 2 weeks
For eg
Example of 1 week pattern
===================
EMPLOYEE_NO,WEEK_NO,START_WEEK,HOURS_MON,HOURS_TUE,HOURS_WED,HOURS_THU,HOURS_FRI,HOURS_SAT,HOURS_SUN
6014, 1, T, 8, 8, 8, 8, 6,,
Example for 2 week pattern
===================
EMPLOYEE_NO,WEEK_NO,START_WEEK,HOURS_MON,HOURS_TUE,HOURS_WED,HOURS_THU,HOURS_FRI,HOURS_SAT,HOURS_SUN
6015, 1, T, 8, 8, 8, 8, 6,,
6015, 2, F, , 5, 5, 5, 5,,
I am trying to use the user entity PER_ASG_WORKING_HOUR_PATTERNS_UE to achieve this requirement. However the extract does not retrieve any data
Tagged:
0