Workflow Hxcemp Ends In Error ORA-06508. E-Mail Notification (Doc ID 277778.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Time and Labor - Version 11.5 to 11.5.10 [Release 11.5]
Information in this document applies to any platform.

Symptoms

Timekeeper approval workflow ends in error

From WFstatus.sql:
Item Type = HXCEMP
Item Key = 478
User Key =
Error Name = WF_ERROR
Error Message = [WF_ERROR] ERROR_MESSAGE=3825: Error '-6508 - ORA-06508:
PL/SQL: could not find program unit being called' encountered during execution
of '' for event 'oracle.apps.wf.notification.send'.
FUNCTION_NAME=WF_XML.Generate ERROR_STACK=
WF_MAIL.GetLOBMessage2(5282, WFMAIL)
WF_XML.GenerateDoc(oracle.apps.wf.notification.send, 5282)
WF_XML.Generate(oracle.apps.wf.notification.send, 5282)
WF_XML.Generate(oracle.apps.wf.notification.send, 5282)
Wf_Event.setMessage(oracle.apps.wf.notification.send, 5282, WF_XML.Generate)
Wf_Event.dispatch_internal()
Error Stack =
Activity Id = 65844
Activity Label = FIND_AND_NOTIFY_APPROVERS:TC_APR_NOTIFICATION-1
Result Code = #MAIL
Notification Id = 5282
Assigned User = xxxxxx

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms