Oracle Learning Cloud Alert Composer - Overdue Learning Assignment Alert Issues After 26C Update

Summary:

Hello Experts,

We are configuring a Resource Alert in Oracle Learning Cloud to notify learners about overdue required learning assignments.

Content (please ensure you mask any confidential information):

Current Filter Configuration:

${assignmentType} = 'ORA_REQUIRE_ASSIGNMENT'
TRUNC(${assignmentDueDate}) <= ${AlertFilterUtils.getCurrentDate()}
${assignmentStatus} = 'ORA_ASSN_REC_ACTIVE'

Questions:

1. Is TRUNC(${assignmentDueDate}) <= ${AlertFilterUtils.getCurrentDate()} the correct and Oracle-supported approach for overdue learning alerts?
2. Has the behavior of date filtering changed in release 26C?
3. Is there any recommended date filter pattern specifically for Learning Resource Alerts?

Group By Error:

The alert executes but generates the following error:
1. oracle.jbo.JboException:
2. getting more than 100 nodes With current group by expression,