Workflow Notification Agent Listeners Fail With Unhandled User-defined Exception ORA-06512: At "APPS (Doc ID 2143917.1)

Last updated on MAY 31, 2016

Applies to:

Oracle Workflow - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.

Symptoms

On Oracle Applications 11.5.10.2 version,
the Workflow agent listeners goes down with error:

Java.sql.SQLException:
 ORA-20002: 3837: An unhandled error '-6550 -
 ORA-06550: line 1, column 7:
 PLS-00306: wrong number or types of arguments in call to 'SYNCRN'
 ORA-06550: line 1, column 7: PL/SQL: Statement ignored' encountered when dispatching event 'oracle.apps.jtf.cac.task.updateTask'
 with key 'oracle.apps.jtf.cac.task.updateTask-119356803' ORA-06512: at "APPS.WF_EVENT", line 1583


The issue can be reproduced at will with the following steps:
1. Log into Oracle Applications and select the 'Workflow Administrator Web Applications' responsibility.
2. Under Oracle Applications manager(OAM), click on the workflow agent listener

The issue has the following business impact:
Due to this issue, deferred agent activities are not processed as the agent listeners goes down.

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