Custom Alert Composer Notification to Managers

Summary:

Hello!

We have a custom alert composer notification created to go to line managers when their direct report's learning is overdue. I have some errors that occurred and was looking for some insight.

Error Log:

oracle.jbo.JboException: getting more than 100 nodes With current group by expression , which is not supported 71362.please modify the group by expression 
	at oracle.apps.hcm.common.core.alerts.processing.utils.MessageProcessor.execute(MessageProcessor.java:320)
	at oracle.apps.ess.hcm.common.core.alerts.program.HcmResourceAlertMessageBuilder.execute(HcmResourceAlertMessageBuilder.java:156)
	at oracle.apps.fnd.applcp.request.exec.AsyncExecutableWrapper.executeHelper(AsyncExecutableWrapper.java:164)
	at oracle.apps.fnd.applcp.request.exec.ExecWrapperBase.execute(ExecWrapperBase.java:178)
	at oracle.apps.fnd.applcp.request.exec.AsyncExecutableWrapper.execute(AsyncExecutableWrapper.java:139)
	at oracle.as.scheduler.rp.JavaSysExecWrapper$1.run(JavaSysExecWrapper.java:427)
	at java.security.AccessController.doPrivileged(Native Method)
	at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:314)
	at oracle.security.jps.internal.jaas.AccActionExecutor.execute(AccActionExecutor.java:70)
	at oracle.security.jps.internal.jaas.AbstractSubjectSecurity$ActionExecutorWrapper.execute(AbstractSubjectSecurity.java:282)
	at oracle.security.jps.internal.jaas.CascadeActionExecutor$SubjectPrivilegedExceptionAction.run(CascadeActionExecutor.java:82)
	at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:386)
	at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:163)
	at weblogic.security.Security.runAs(Security.java:62)
	at oracle.security.jps.wls.jaas.WlsActionExecutor.execute(WlsActionExecutor.java:50)
	at oracle.security.jps.internal.jaas.CascadeActionExecutor.execute(CascadeActionExecutor.java:55)
	at oracle.security.jps.internal.jaas.AbstractSubjectSecurity$ActionExecutorWrapper.execute(AbstractSubjectSecurity.java:282)
	at oracle.as.scheduler.security.internal.SecurityExecutorBase.execute(SecurityExecutorBase.java:162)
	at oracle.as.scheduler.rp.JavaSysExecWrapper._executeJob(JavaSysExecWrapper.java:344)
	at oracle.as.scheduler.rp.AsyncJavaSysExecWrapper.initiateExecution(AsyncJavaSysExecWrapper.java:126)
	at oracle.as.scheduler.rp.EndpointProcessor.initiateExecute(EndpointProcessor.java:992)
	at oracle.as.scheduler.rp.EndpointProcessor.initiateExecuteWrapper(EndpointProcessor.java:911)
	at oracle.as.scheduler.adapter.EndpointImpl.initiateExecute(EndpointImpl.java:439)
	at oracle.as.scheduler.ejb.EssAppEndpointBean.initiateExecute(EssAppEndpointBean.java:162)
	at oracle.as.scheduler.ejb.ESSAppEndpoint_t596cy_MDOImpl.__WL_invoke(Unknown Source)
	at weblogic.ejb.container.internal.MessageDrivenLocalObject.invoke(MessageDrivenLocalObject.java:127)
	at oracle.as.scheduler.ejb.ESSAppEndpoint_t596cy_MDOImpl.initiateExecute(Unknown Source)
	at sun.reflect.GeneratedMethodAccessor2461.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at oracle.as.scheduler.adapter.ra.rdp.RequestProcessor.invokeInitiateExecute(RequestProcessor.java:7374)
	at oracle.as.scheduler.adapter.ra.rdp.RequestProcessor.execStage_Initiate(RequestProcessor.java:6755)
	at oracle.as.scheduler.adapter.ra.rdp.RequestProcessor.process_execute(RequestProcessor.java:5041)
	at oracle.as.scheduler.adapter.ra.rdp.RequestProcessor.dispatchHandler(RequestProcessor.java:2876)
	at oracle.as.scheduler.adapter.ra.rdp.RequestProcessor.processExecuteEvent(RequestProcessor.java:744)
	at oracle.as.scheduler.adapter.ra.rdp.RequestProcessor.processExecuteEvent(RequestProcessor.java:635)
	at oracle.as.scheduler.adapter.ra.WorkUnitWorkerBase.processWork(WorkUnitWorkerBase.java:230)
	at oracle.as.scheduler.adapter.ra.WAWorker.run(WAWorker.java:368)
	at weblogic.connector.security.layer.WorkImpl.runIt(WorkImpl.java:72)
	at weblogic.connector.security.layer.WorkImpl.run(WorkImpl.java:47)
	at weblogic.connector.work.WorkRequest.run(WorkRequest.java:123)
	at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:681)
	at weblogic.invocation.ComponentInvocationContextManager._runAs(ComponentInvocationContextManager.java:352)
	at weblogic.invocation.ComponentInvocationContextManager.runAs(ComponentInvocationContextManager.java:337)
	at weblogic.work.LivePartitionUtility.doRunWorkUnderContext(LivePartitionUtility.java:60)
	at weblogic.work.PartitionUtility.runWorkUnderContext(PartitionUtility.java:41)
	at weblogic.work.SelfTuningWorkManagerImpl.runWorkUnderContext(SelfTuningWorkManagerImpl.java:655)
	at weblogic.work.ExecuteThread.execute(ExecuteThread.java:420)
	at weblogic.work.ExecuteThread.run(ExecuteThread.java:360)