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 join a Timesheet Row to an Absence Row (HWM_TM_RPT_ENTRY_V to ANC_PER_ABS_ENTRIES)
Summary:
If we have a person with 2 timesheet rows on the same day, each representing half day of absence, and we have 2 absence rows each of a different absence type - how can we join the correct row to the correct row?
Content (required):
Trying to write a report which takes the number of hours from the timesheet row (HWM_TM_RPT_ENTRY_V.TE_MEASURE_ABSENCE) and the type from the absence row (ANC_PER_ABS_ENTRIES.ABSENCE_TYPE_ID).
We were joining on the resource/person id and date of entry, however if you have 2 timesheet records for the same day, and 2 absence rows for that day, then you end up with 4 rows coming back in the report (2*2) as we cannot match 1 timesheet row to 1 absence row.
1