You will also see the deployment step in this presentation.
What are the steps required in SOA Server so that connection to Apps Database can be made by Apps Adapter?
1. Create the Connection Pool
2. Create a DataSource [ is attached to connection pool of previous step ]
3. Create the Connection Factory [ is attached to datasource of previous step ]
Before we proceed, lets recollect that when creating the Apps Adaptor in jDeveloper, we specified a JNDI Location for the database.
Please see the image below that displays the JNDI Name.
For Apps Adapter to work within SOA Server[Runtime], we will have to use exactly the same JNDI Name in "Connection Factory" as well.
This is visible from the presentation.
At the end of this presentation, you will be able to deploy your BPEL process into SOA Server.
There are two methods by which you can create connection factory for Apps Adapter within SOA Runtime [ SOA Server]
If you aren't able to view presentations in this article, then do the following
a. Download PowerPoint 2003 viewer from this link
b. Install PowerPoint 2003 viewer
c. Save the PowerPoint slide from this website on your PC
d. Open the PowerPoint side using the PowerPoint 2003 viewer that you have installed.
Method 1
Start the SOA Server, and then follow the steps given in the presentation below.
Click here to view the presentation detailing steps to create Connection Factory
Method 2
Change the XML File oc4j-ra.xml in SOA Server for the Apps Adapter, so that Apps database can be registered within SOA Server.
If your SOA Server is installed on linux/unix you might do
cd /oracle/SOA/APP2/oc4j_soa/application-deployments/default/AppsAdapter
In C Drive[PC], in my case, this is in C:\soa\10.1.3.1\OracleAS_1\j2ee\home\application-deployments\default\AppsAdapter
You may add text similar to below in bold
<connector-factory location="eis/Apps/r124DBConn" connector-name="AppsAdapter">
<config-property name="xADataSourceName" value="jdbc/r124DBDataSource"/>
<config-property name="dataSourceName" value=""/>
<connection-pooling use="none">
</connection-pooling>
<security-config use="none">
</security-config>
<connectionfactory-interface>javax.resource.cci.ConnectionFactory</connectionfactory-interface>
</connector-factory>
Apps2Fusion Articles 
Comments
I have gone thru all of the 4 articles related to SOA/BPEL integration with EBS and i really felt happy which makes things easier to understand.
I really appreciate your hardwork. Here is my analogy of understanding on the configuration.
1. Connection Pool is the JDBC thin client connectivity information to the database from SOA. ( Alias to Tns Entry )
2. Data Source - Wrapper to the connection pool which becomes specific to our Bpel Process.
3. Connection Factory is the instance of this datasource used for an instance of the process.
Pleas e correct me if i am wrong.
Thanks
Shiva
Thanks - Very good explanation.
C heers,
Anil Passi
I am getting the below error message when I am trying to deploy my BPEL process after doing all the configuration you have explained
Any ideas what can be going wrong
Exceptio n message is: ORABPEL-09903
C ould not initialize activation agent.
An error occured while initializing an activation agent for process "SFDCAccountCre ate", revision "1.0".
Please ensure that the activation agents are configured correctly in the bpel deployment descriptor (bpel.xml).
ora cle.tip.adapter .fw.agent.jca.J CAActivationAge nt: java.lang.refle ct.InvocationTa rgetException
Sajid
Thanks
Sajid
While going through the process of adapter configuration wizard doesn't go to the 4th step, where it asks for the XSD type that can be assigned to the payload. It end after selecting the business event. Can anybody tell me why is this happening. Has it got anything to do with JDeveloper version/apps version?
Thank s.
Could not initialize activation agent.
An error occured while initializing an activation agent for process "xxTestBusiness EventApp", revision "1.0".
Please ensure that the activation agents are configured correctly in the bpel deployment descriptor (bpel.xml).
ora cle.tip.adapter .fw.agent.jca.J CAActivationAge nt: java.lang.refle ct.InvocationTa rgetException
a t com.collaxa.cub e.engine.core.B aseCubeProcess. startAllActivat ionAgents(BaseC ubeProcess.java :354)
at com.collaxa.cub e.engine.deploy ment.Deployment Manager.activat eDefaultRevisio n(DeploymentMan ager.java:1446)
at com.collaxa.cub e.engine.deploy ment.Deployment Manager.setDefa ultRevision(Dep loymentManager. java:1405)
at com.collaxa.cub e.engine.deploy ment.Deployment Manager.deployP rocess(Deployme ntManager.java: 821)
at com.collaxa.cub e.engine.deploy ment.Deployment Manager.deployS uitcase(Deploym entManager.java :670)
at com.collaxa.cub e.ejb.impl.BPEL DomainManagerBe an.deploySuitca se(BPELDomainMa nagerBean.java: 445)
at sun.reflect.Nat iveMethodAccess orImpl.invoke0( Native Method)
at sun.reflect.Nat iveMethodAccess orImpl.invoke(N ativeMethodAcce ssorImpl.java:3 9)
at sun.reflect.Del egatingMethodAc cessorImpl.invo ke(DelegatingMe thodAccessorImp l.java:25)
at java.lang.refle ct.Method.invok e(Method.java:5 85)
at com.evermind.se rver.ejb.interc eptor.joinpoint .EJBJoinPointIm pl.invoke(EJBJo inPointImpl.jav a:35)
at com.evermind.se rver.ejb.interc eptor.Invocatio nContextImpl.pr oceed(Invocatio nContextImpl.ja va:119)
at com.evermind.se rver.ejb.interc eptor.system.DM SInterceptor.in voke(DMSInterce ptor.java:52)
a t com.evermind.se rver.ejb.interc eptor.Invocatio nContextImpl.pr oceed(Invocatio nContextImpl.ja va:119)
at com.evermind.se rver.ejb.interc eptor.system.JA ASInterceptor$1 .run(JAASInterc eptor.java:31)
at com.evermind.se rver.ThreadStat e.runAs(ThreadS tate.java:620)
at com.evermind.se rver.ejb.interc eptor.system.JA ASInterceptor.i nvoke(JAASInter ceptor.java:34)
at com.evermind.se rver.ejb.interc eptor.Invocatio nContextImpl.pr oceed(Invocatio nContextImpl.ja va:119)
at com.evermind.se rver.ejb.interc eptor.system.Tx RequiredInterce ptor.invoke(TxR equiredIntercep tor.java:50)
As always excellent.
Now to my questions. I have installed Jdeveloper and the SOA suite on my PC and completed the steps mentioned in your other article to make sure it was installed fine and i can connect to the various servers.
Now my question is that do we need to do anything on server side of my development apps instance(11.5.1 0.2) to complete these 4 BPEL articles.
I wish to learn this but am not sure if i can because we do not have SOA deployed in our environment.
T hansk
ramp
Great Site !!
Is there a way to raise a seeded Business Event in 11i based on some condition. For Example I need to raise the event only if a certain type of record is update .
Secondly what are the parameters for each of these events used for. Is it to restrict the event to that. For example Service request update event has a parameter For Sr number. When that is passed is it raised only for that SR. ALso what re the old value parameters and how to retrieve them.
Thanks in Advance
Ram
I have create a BPEL Process,which Receive via Apps Adapter,when a event oracle.apps.po. event.xmlpo is raised.
Everyth ing is fine and Data Enqueues into WF_BPEL_Q,check ed from WF_BPEL_QTAB table.
I have my BPEL process waiting to receive from this event via apps adapter.But it never receives.
I have completed all tasks like DS and Connection Pool and using the correct JNDI and checking oc4j-ra.xml for apps-appliction .
Please suggest..Thanks in advance.
You Rock...
RSS feed for comments to this post