Workflow Notification Agent Listeners Fail With Unhandled User-defined Exception ORA-06512: At "APPS
Last updated on MAY 31, 2016
Applies to:Oracle Workflow - Version 188.8.131.52 to 184.108.40.206 [Release 11.5.10]
Information in this document applies to any platform.
On Oracle Applications 220.127.116.11 version,
the Workflow agent listeners goes down with error:
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms