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)
Tagged:
0