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.
Issue with Views in HCM cloud Learning Management (WLF_LRNR_COMPLETION_DETAILS_V) in Specialization
Summary
Joins are missing in the Specialization item type part in the Views WLF_LRNR_COMPLETION_DETAILS_V and WLF_LRNR_COMPLETION_SUMMARY_VContent
In the code of the views while checking in https://docs.oracle.com/en/cloud/saas/human-resources/21a/oedmh/work-life.html#wlflrnrcompletionsummaryv-3497, there seems to be an important join missing. So the view keeps running for item type 'ORA_SPECIALIZATION' and gets timed out.
In the SECTION_COURSE_ASG_INFO cte part, the join is only with item_id, instead it should have been with the specialization assignment record id also, which should've been inherited from the above steps.
Tagged:
1