Exchange with Oracle Workflow (Oracle Advanced Queuing)

[Former Member]

Dear colleagues

I am looking for a standard solution for setting up a message exchange between SAP ERP and Oracle EBS.

And the very first idea would be to use a JMS adapter of course.

I googled for common usage of SAP PI and Oracle AQ and found some info that standard JMS implementations by SAP and Oracle are not fully compatible, and additional development is required.

For example, the following limitations are mentioned when integrating Oracle AQ via the SAP JMS Adapter:

1. The SAP JMS adapter only support queues. It DOES NOT support topics.

2. The SAP JMA adapter only supports the following queue message type:

• SYS.AQ$_JMS_TEXT_MESSAGE

• SYS.AQ$_JMS_BYTES_MESSAGE

Colleagues, may I ask you please for confirmations or rejoinders if you have the experience?

[Former Member · Accepted solution]

Thanks Shabarish

Is there an officially published roadmap or promise to get topics supported in the next release of PI?

[Shabarish_Nair · Accepted solution]

i tried to search but unable to locate the document.

But i am sure i have seen it as part of a presentation from SAP.

[Shabarish_Nair · Accepted solution]

>

> Thanks Shabarish
> 
> Is there an officially published roadmap or promise to get topics supported in the next release of PI?

mark your calendar for that.. you will find the info then

[Shabarish_Nair]

> For example, the following limitations are mentioned when integrating Oracle AQ via the SAP JMS Adapter:
> 1. The SAP JMS adapter only support queues. It DOES NOT support topics.
> 2. The SAP JMA adapter only supports the following queue message type:
> * SYS.AQ$_JMS_TEXT_MESSAGE
> * SYS.AQ$_JMS_BYTES_MESSAGE
> 
> Colleagues, may I ask you please for confirmations or rejoinders if you have the experience?

you are right about this.

So in this case why don't you avoid the usage of topics while designing your scenarios?

the ideal and right way would be to go ahead with JMS adapter.

FYI¬¬

Topics will be supported in the JMS adapter in the next release of PI