For more information, please refer to this announcement explaining best practices for getting answers to questions.
Custom Resource Reminder alert for ILT Activity resulting in error
Summary:
Hi Everyone,
We had created a resource alert for Reminder email 3 days before ILT activity. The filters used are as follows under resource learnerLearningRecords:
1. ${assignmentStatus} = 'ORA_ASSN_REC_ACTIVE'
2.EXISTS (select 'X' from WLF_LI_ACTIVITY_DETAILS_V AD where AD.COURSE_LEARNING_ITEM_ID = ${learningItemId} AND AD.LEARNER_ID =${assignedToId} AND AD.ACTIVITY_TYPE = 'ORA_ONSITE_IL' AND AD.ACTIVITY_DATE > sysdate+2 And AD.ACTIVITY_DATE <= sysdate+3).
However, the alert resulted in error yesterday - the alert log has been attached. This alert was deployed more than a year back and has been triggering emails as expected until this error.