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.
BI Reporting Display only max date for user
Summary
Need course completion report to show only 1 record per user (most recent)Content
Course completion report: Currently filtered to show only the last 1 year of records. Also, need it to only show the most recent completion for each user. Since this is part of a learning plan users get a reminder 30 days in advance and so most have 2 records in the past year.
I can't use the learning plan report because after the 30-day renewal the users last completion date gets cleared from the learning plan report even though they still have another 30 days of compliance.
The plan is for this report to be run daily and the file will be transferred automatically thus the need for this report to be filtered when it's run.
0