Workflow mailer notification errors with Ora-08103 Object No Longer Exists Error In Wf_xml_generate (Doc ID 1302169.1)

Last updated on SEPTEMBER 29, 2016

Applies to:

Oracle Workflow - Version 12.1.2 to 12.2 [Release 12.1 to 12.2]
Information in this document applies to any platform.
Checked for relevance on 28-SEP-2016

Symptoms



The Sysadmin user receives WFERROR notifications with the error: "Ora-08103 Object No Longer Exists Error In Wf_xml_generate For Oracle.Apps.Wf.Notification.Send'. Outbound notifications may be in FAILED status. 

The complete error stack looks like this:
ERROR:[SVC-GSM-WFALSNRSVC-110844-10004 : oracle.apps.fnd.wf.bes.AgentListenerProcessor.read()]:Could not executeUpdate() on begin   WF_EVENT.setNavigationParams  (  p_agentName => :1, p_navigationThreshold => :2  );  WF_EVENT.LISTEN  (  p_agent_name => :3, p_wait => :4, p_correlation => :5, p_deq_condition => null, p_message_count => :6, p_max_error_count => :7  );end; -> java.sql.SQLException: ORA-20002: 3825: Error '-20002 - ORA-20002: 3101: Status row for item 'GLBATCH/7303756*103929', activity ID '187725' does not exist.' encountered during execution of Rule function 'WF_XML.ERROR_RULE' for event 'oracle.apps.wf.notification.send' with key '13525534'.
ORA-06512: at "APPS.WF_EVENT", line 1591
ORA-06512: at line 1
 

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