APPLIES TO:
Oracle Purchasing – Version 12.1.3 and later
Information in this document applies to any platform.
SYMPTOMS
When attempting to send some Purchase Orders (POs) by XML Gateway after the PO has been approved, the XML workflow ends with the following error :
ERROR
———————–
ERROR_MESSAGE 3142: Process ‘POXML/651904-983696’ has no activities waiting to receive event ‘oracle.apps.po.event.xmlpo’.
Attribute Name Value
—————————— ——————————————————————————–
EVENT_MESSAGE WF_EVENT_T(50, ’09-DEC-14′, ’09-DEC-14′, NULL, WF_PARAMETER_LIST_T(WF_PARAMETER_
T(‘APPLICATION_ID’, ‘178’), WF_PARAMETER_T(‘DOCUMENT_DIRECTION’, ‘OUT’), WF_PARA
METER_T(‘DOCUMENT_NO’, ‘1165058’), WF_PARAMETER_T(‘ECX_DEBUG_LEVEL’, ‘0’), WF_PA
RAMETER_T(‘ECX_DOCUMENT_ID’, ‘1165058:0:104’), WF_PARAMETER_T(‘ECX_PARAMETER1’,
NULL), WF_PARAMETER_T(‘ECX_PARAMETER2’, ‘0’), WF_PARAMETER_T(‘ECX_PARAMETER3’, ‘
134475:50544:178’), WF_PARAMETER_T(‘ECX_PARAMETER4’, ‘651904’), WF_PARAMETER_T(‘
ECX_PARAMETER5’, ‘104’), WF_PARAMETER_T(‘ECX_PARTY_ID’, ‘704’), WF_PARAMETER_T(‘
ECX_PARTY_SITE_ID’, ‘46594’), WF_PARAMETER_T(‘ECX_PARTY_TYPE’, ‘S’), WF_PARAMETE
R_T(‘ECX_TRANSACTION_SUBTYPE’, ‘PRO’), WF_PARAMETER_T(‘ECX_TRANSACTION_TYPE’, ‘P
O’), WF_PARAMETER_T(‘MESSAGE_TEXT’, ‘PO_XML_NEW_PO_EVENT_MSG’), WF_PARAMETER_T(‘
MESSSAGE_ID’, NULL), WF_PARAMETER_T(‘ORG_ID’, ‘104.’), WF_PARAMETER_T(‘PARTY_TYP
E’, ‘S’), WF_PARAMETER_T(‘PO_NUMBER’, ‘1165058’), WF_PARAMETER_T(‘RESPONSIBILITY
_ID’, ‘50544.’), WF_PARAMETER_T(‘TRADING_PARTNER_ID’, ‘704’), WF_PARAMETER_T(‘TR
ADING_PARTNER_SITE’, ‘46594’), WF_PARAMETER_T(‘TRADING_PARTNER_TYPE’, ‘S’), WF_P
ARAMETER_T(‘USER_ID’, ‘134475.’), WF_PARAMETER_T(‘XMLG_DOCUMENT_ID’, ‘1165058:0:
104’), WF_PARAMETER_T(‘XMLG_INTERNAL_TXN_SUBTYPE’, ‘PRO’), WF_PARAMETER_T(‘XMLG_
INTERNAL_TXN_TYPE’, ‘PO’), WF_PARAMETER_T(‘XML_EVENT_KEY’, ‘651904-983696’), WF_
PARAMETER_T(‘#CONTEXT’, ‘POXML:651904-983695’), WF_PARAMETER_T(‘SUB_GUID’, ‘A242
DC2FF79D70A7E030238229893C61’), WF_PARAMETER_T(‘#CURRENT_PHASE’, ‘101’), WF_PARA
METER_T(‘ERROR_NAME’, ‘WFENG_EVENT_NOTFOUND’), WF_PARAMETER_T(‘ERROR_TYPE’, ‘ERR
OR’)), ‘oracle.apps.po.event.xmlpo’, ‘651904-983696’, NULL, WF_AGENT_T(‘WF_DEFER
RED’, ‘EBSPRD.ICORP.ITAB.LOCAL’), NULL, ‘2E9AD5EA0E9A2445E040180A0B5F06F7’, ‘314
2: Process ‘POXML/651904-983696’ has no activities waiting to receive event ‘ora
cle.apps.po.event.xmlpo’.’, ‘
Wf_Engine.Event(POXML, 651904-983696, POXMLSEND, oracle.apps.po.event.xmlpo)
Wf_Rule.Default_Rule(oracle.apps.po.event.xmlpo, 2E9AD5EA0E9A2445E040180A0B5F06F
7)’)
CAUSE
The issue was caused by a duplicate subscription to the business event oracle.apps.po.event.xmlpo.
As per Bug 13249864 : ISSUES WITH POXML
The following script returned to lines as shown below:
select wes.phase, wes.status, wes.wf_process_type, wes.wf_process_name
from wf_event_subscriptions wes, wf_events we
where we.name = ‘oracle.apps.po.event.xmlpo’ and wes.event_filter_guid =
we.guid
and wes.wf_process_type = ‘POXML’;
Returns:
PHASE STATUS WF_PROCESS_TYPE WF_PROCESS_NAME
50 ENABLED POXML POXMLSEND
101 ENABLED POXML POXMLSEND
SOLUTION
To resolve the issue perform the following:
1. Run the sql script below to identify possible duplicate subscriptions on business event “oracle.apps.po.event.xmlpo”:
select wes.phase, wes.status, wes.wf_process_type, wes.wf_process_name
from wf_event_subscriptions wes, wf_events we
where we.name = ‘oracle.apps.po.event.xmlpo’ and wes.event_filter_guid =
we.guid
and wes.wf_process_type = ‘POXML’;
2. If there is more that one row returned, then disable the duplicate subscriptions.
a. From the Administrator Workflow Responsibility
b. Select the Business Events tab
c. Search for “oracle.apps.po.event.xmlpo”
d. Disable the duplicate subscriptions identified by query above.
