CHeck and remove WF_BPEL_Q consumers

How to Check your current consumers

select *

from

APPS.AQ$_WF_BPEL_QTAB_S 

How to Delete a WF_BPEL consumer

DECLARE
   subscriber       sys.aq$_agent;
begin subscriber := sys.aq$_agent('<CONSUMER_NAME>', NULL, NULL);
dbms_aqadm.remove_subscriber(queue_name => 'WF_BPEL_Q', subscriber => subscriber);
end;

Import a project from BPEL console

How to build a project from bpel export

IN ENTERPRISE MANAGER

1. Export BPEL code

IN JDEVELOPER

1. Create a new empty SOA project and import the code from Enterprise Manger

2. In case you have WSDLand JCA adapters. Open all your WSDL adapters related to JCA adapters and add a line at the very beginning of the wsdl file, as an example:

<?binding.jca getMyData_db.jca?>

3. In case you have JCA adapters that are reading tables. Open all the properties file and add the DTD reference a top of each properties file

<!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd">

4.      In case you have events or WSDL attaches to MDS. Open the resource palette to relink all missing objects from MDS, do the following steps

a.      Create a new connection

b. Add your MDS connection

c. Open the palette and relink them