AQ Adapter Doesn’t Process XMLtype Messages (Doc ID 2431915.1)

Last updated on MAY 15, 2023

Applies to:

Symptoms

AQ adapter doesn’t process XMLtype messages.

We have an Oracle Multi consumer advanced queue (AQ). The queue has a XMLType as a payload.
We have subscribed a BPEL process on this AQ with the AQ Adapter. When we enqueue a message on the AQ with PL/SQL, we can see that the message changes from the AQ state “READY” to “PROCESSED”. So this means that the message is dequeued.
However we don’t see a flow instance for the BPEL process in the EM of the soasuite.
Also the soa_infra table sca_flow_instance doesn’t show an instance.

When we enqueue another message, then the state of that new message remains “READY” in the AQ.
As a side effect, when we are in this situation (having dequeued one message), we are unable to undeploy the bpel process.

We’ve also tried the same situation with an SCA composite using an OSB service. This produces the same results.


An AQ based on a RAW message or an OBJECT TYPE works fine.
And on 12.2.1.2 (after applying patch p24816844_122120_Generic) dequeueing of an XMLType also works fine.

Errors such as : 

Cause

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