Database Software

Hi

I’ve created a workflow to basically call a few procedures to load data. Before this happens I send a notification with a yes/no response to the “data owner”. When the data is load he send the yes response and the workflow continues. When this process is done another notification with a yes/no response get send. However before this notification get send I get the following error:

Workflow Errors: XX_BSC_M, RUN-F1-03-MAR-2008-3

Failed Activity Success Notification
Activity Type Notice
Error Name -25316
Error Message ORA-25316: Late in the current transaction to begin an Enqueue/Dequeue operation
Error Stack Wf_Event.Dispatch(oracle.apps.wf.notification.send) Wf_Notification.SendSingle(MARNUS, XX_BSC_M, SUCCESS_MSG, 03-MAR-08, WF_ENGINE.CB)
Wf_Notification.Send(MARNUS, XX_BSC_M, SUCCESS_MSG, 03-MAR-08, WF_ENGINE.CB)
Wf_Engine_Util.Notification_Send(XX_BSC_M, RUN-F1-03-MAR-2008-3, 191198, XX_BSC_M:SUCCESS_MSG)
Wf_Engine_Util.Notification(XX_BSC_M, RUN-F1-03-MAR-2008-3, 191198, RUN)

When I retry the activity I get the following:

Retry Activity: XX_BSC_M, RUN-F1-03-MAR-2008-3

Selected Activity Success Notification
Activity Status Error
Activity Type Notice
Notification Subject Error ORA-01403: no data found Error Name: 100 Error Stack:
Notification Recipient

Although I’m getting the error the “Submit” button is available and if pressed the failed activity get the status Forced and the Notification gets resubmitted and the Workflow continues as normal. If I remove that notification the same error happens at the next notification in the process.

Workflow Server: Apps Release 12
Workflow Builder: 2.6.3.5

Any help or advice will be appreciated

Thanks