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
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
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
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