You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

Encountering error for Learning Overdue alert notifications

Summary:

oracle.jbo.JboException: JBO-29000: Unexpected exception caught: java.sql.SQLIntegrityConstraintViolationException, msg=ORA-00001: unique constraint (FUSION.HRC_ALERT_KEEPS_U1) violated
ORA-06512: at "FUSION.HRC_ALERT_API", line 1506
ORA-06512: at line 1


	at oracle.apps.hcm.common.core.alerts.processing.beans.data.AlertRunDataAdapterImpl.handleKeepBeforePhase3(AlertRunDataAdapterImpl.java:1880)

	at oracle.apps.ess.hcm.common.core.alerts.program.HcmResourceAlertRun.handlePhase3(HcmResourceAlertRun.java:1453)

	at oracle.apps.ess.hcm.common.core.alerts.program.HcmResourceAlertRun.execute(HcmResourceAlertRun.java:377)

	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.GeneratedMethodAccessor3016.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:7383)

	at oracle.as.scheduler.adapter.ra.rdp.RequestProcessor.execStage_Initiate(RequestProcessor.java:6764)

	at oracle.as.scheduler.adapter.ra.rdp.RequestProcessor.process_execute(RequestProcessor.java:5050)

	at oracle.as.scheduler.adapter.ra.rdp.RequestProcessor.dispatchHandler(RequestProcessor.java:2885)

	at oracle.as.scheduler.adapter.ra.rdp.RequestProcessor.processExecuteEvent(RequestProcessor.java:753)

	at oracle.as.scheduler.adapter.ra.rdp.RequestProcessor.processExecuteEvent(RequestProcessor.java:644)

	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)

Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (FUSION.HRC_ALERT_KEEPS_U1) violated
ORA-06512: at "FUSION.HRC_ALERT_API", line 1506
ORA-06512: at line 1

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!