How Standard Business Events Work With WF_BPEL_Q? (Doc ID 549040.1)

Last updated on JUNE 02, 2023

Applies to:

Goal

How do standard Business events work with WF_BPEL_Q?

Problem Scenario :

When a standard business event is associated with a BPEL subscription is raised, it goes to WF_DEFERRED queue and then to the WF_ERROR queue with either of the following error messages:

1) "ORA-01403: no data found" .

OR

2) "ORA-24033: no recipients for message
Wf_Event_QH.Enqueue(APPS.WF_BPEL_Q, SQL err is ORA-24033: no recipients for message)
Wf_Event.Enqueue(oracle.apps.ar.hz.PartySite.create, WF_EVENT_QH)
Wf_Event.Send(oracle.apps.ar.hz.PartySite.create)
Wf_Rule.Default_Rule(oracle.apps.ar.hz.PartySite.create, 4254112FCA341054E043C0A862191054)"

Expected behavior is that the Event should be enqueued in the WF_BPEL_Q for further processing.

Expected Flow: The normal flow involved for Standard Business Events with BPEL is as follows :

a) User from Jdeveloper creates/configures an adapter as a partner link and selects the APPS event to listen

b) These are the background items
1. Create tables for queue named wf_bpel_q
2. Start wf_bpel_q
3. Create and start wf_bpel_qagent listener, which listens on wf_bpel_q.
4. Create subscription for the event for which the partner link was created

c) When the BPEL process is deployed in the BPEL PM, the listener keeps polling the WF_BPEL_Q with whatever frequency was defined.


d) Once the event is raised, it is enqueued into the WF_BPEL_Q and the listener (spawned by BPEL PM) which is listening to this event, would dequeue the item and start the BPEL process.

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.