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.
Infolet Report Failing / Erroring with Direct and Indirect Reporting Line
Hi all, I'm hoping someone can tell me if what I'm trying to achieve here is possible.
The report itself should look at anyone who has learning that's due and then apply the case statement to it to return who's is currently overdue.
I've built an OTBI report (I can attach the catalog file if needed / possible) that does the following:
The case when statement looks like this:
CASE WHEN "Assignment Status"."Name" = 'Active' AND CAST("Learning Record Details"."Due Date" AS TIMESTAMP) < CAST(CURRENT_DATE AS TIMESTAMP) THEN 'Overdue'
WHEN "Assignment Status"."Name" = 'Active' AND CAST("Learning Record Details"."Due Date" AS TIMESTAMP) >= CAST(CURRENT_DATE AS TIMESTAMP) THEN 'Outstanding'
WHEN "Assignment Status"."Name" = 'Completed' AND CAST("Learning Record Details"."Completion Date" AS TIMESTAMP) > CAST("Learning Record Details"."Due Date" AS TIMESTAMP) THEN 'Completed (Past Due Date)'
WHEN "Assignment Status"."Name" = 'Active' THEN 'Active (No Due Date)'
WHEN "Assignment Status"."Name" = 'Completed' THEN 'Completed' ELSE 'No Criteria Matches'
END
Tagged:
0