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.
Query to Fetch withdrawn assignments in Learning
Summary: I am trying to fetch the learners who got withdrawn from the courses in Learning.
Content (required): We discover that thousands of learning assignment records have been withdrawn from the various trainings in Learning for the last few months. So, to see the impacted records, wanted to build the report using BI Publisher, and tried with one Person number but ended up with duplicate rows.
FYI: The specific person does have only one withdrawn record from the UI Learning, whereas from the attached SQL query, getting the same record more than five times.
Version (include the version you are using, if applicable):
Tagged:
0