We have one business event with Custom Subscription where action type is Custom with plsql code. This event works fine most of the times, however we face issue intermittently with following error
[Mar 30, 2017 8:14:28 AM
UTC]:1490861668060:-1:-1:acizslpsccapp107.cummins.com:10.208.137.45:-1:-1:1:20420:SYSADMIN(0):-1:Thread[inboundThreadGroup1,5,inboundThreadGroup]:10.208.137.45:6893:1490861608040:109:ERROR:[SVC-GSM-WFALSNRSVC-17807-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: 3000: Invalid value(s) passed for arguments.
ITEMTYPE=WFERROR ITEMKEY=23411 ANAME=NULL' encountered during execution of Rule
function 'wf_rule.error_rule' for event 'xxc07707.ont.order.line.shipto.update' with key '27916'.
ORA-06512: at
"APPS.WF_EVENT", line 1605
ORA-06512: at line 1
I am just trying to see if anyone has faced similar error and knows the cause