Oracle Applications Adapater Receives Business Event from EBS but Within The Received Message the Event Specific Data Element is Not Populated
Last updated on MAY 01, 2015
Applies to:Oracle SOA Platform - Version 126.96.36.199.0 to 188.8.131.52.0 [Release 11gR1]
Information in this document applies to any platform.
***Checked for relevance on 08-Mar-2012***
***Checked for relevance on 09-August-2013***
You are using the Oracle Applications Adapter component of Oracle Fusion Middleware 11g to implement a business process for the BPEL component that integrates with Oracle E-Business Suite via Business Events. When the BPEL process receive a payload corresponding to the Business Event subscribed to via the Applications Adapter, the event_data element (which is expected to provide data specific to the event type) is empty.
For example, you may configure the Oracle Applications Adapter to receive receive business events that indicate the approval of Purchase Orders to be dispatched to partners via the XML Gateway, as described by the following product documentation:
11g Release 1 (11.1.1)
Part Number E10537-02
At runtime, the approval of PO's is triggering the creation of business events which are received as input through the Applications Adapter that initiates a running BPEL instance to process the payload. However, though the received message has many fields populated, there is no information within the message providing the line items of the approved Purchase Order (i.e. the event data element of the message is an empty element: <EVENT_DATA/>).
The issue can be verified by executing a SQL query, similar to the following, which views the relevant entries in the WF_BPEL_QTAB table, which holds the business event messages that are dispatched to BPEL:
SET pause "---MORE---"
COL q_name format a9
COL state format 999
COL enq_time format a20
, TO_CHAR(q.enq_time,'DD-MON-YYYY HH24:MI:SS') "ENQ_TIME"
, q.user_data.event_name "EVENT_NAME"
FROM WF_BPEL_QTAB q
WHERE q.user_data.event_name = 'oracle.apps.po.event.xmlpo'
ORDER BY q.enq_time desc;
These will show that the event data XML element (which is used to hold the different data that would be specific to each event type) is an empty element </EVENT_DATA>, for example:
<CORRELATION_ID NULL="TRUE" xmlns=""/>
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