Not able to see record in AQ$_WF_BPEL_QTAB_S

you have create a event in Oracle EBS and a soa is subscribing to that event using Oracle apps adpater.

Everything was going fine but all of a sudden after migrating your code to next environment the code is not working.

There are few important steps that one take care of while migrating the code for apps adapter.

The first thing is when you create an apps adapter two sql files are created for you.

XX_BPEL_WFEVENT_.sql
and
XX_BPEL_WFEVENT__drop.sql

BEfore migrating the soa code to the higher environment you must first execute the XX_BPEL_WFEVENT_.sql in the target environment

then only the soa code should be deployed to the higher envrionment.

Now after executing the sql and deploying the sql still your process is not wokring.

The reason is that the subscription is not created for the advanced queue.

You need to validate few things

select * from wf_bpel_qtab

This will contain the event data which was raised by ORacle EBS which further gets inserted in to the wf_bpel_q which is an advanced queue.

Now once you validated that the data is present in the wf_bpel_qtab you need to validate if the subscription is present or not.

for that you can execute the following query

select * From AQ$_WF_BPEL_QTAB_S

there you should be able to see an entry



the name in the table should match with the consumer name in your jca file



property name="Consumer" value="ORA_asdasdmalsjdiklajsd"

If you are not able to see it in the table then this is an issue with your datasource.

Make sure your datasource is up and running and redeploy your process again to the server.