Login
Register

Home

Trainings

Fusion Blog

EBS Blog

Authors

Contact Us

SOA
  • Register

Oracle Gold Partners, our very popular training packages, training schedule is listed here
Designed by Five Star Rated Oracle Press Authors & Oracle ACE's.

webinar new Click here to raise Support Ticket. Get reply within 48 hours.

Search Courses

User Rating: 5 / 5

Star ActiveStar ActiveStar ActiveStar ActiveStar Active
 
In the previous articles, we saw how jDeveloper connects to the R12 or 11.5.10 instance, so as to display the list of Business Events from the database. After our BPEL process gets deployed to BPEL server, then the SOA Runtime Server should also be able to connect to R12 or 11.5.10 database, so as to monitor the messages in Advanced Queue i.e. in WF_BPEL_Q. In this article, you will see the steps to make Apps Adapter running within SOA Server[Runtime ] to talk to Apps Database, so as to dequeue WF Event messages from BPEL Queue.
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>


Anil Passi

Comments   

0 #1 Shiv@ 2008-06-01 15:22
Hello Anil,

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
Quote
0 #2 Anil Passi 2008-06-01 15:56
Hi Shiva

Thanks - Very good explanation.

C heers,
Anil Passi
Quote
0 #3 Sajid 2008-06-03 13:31
Anil,
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
Quote
0 #4 Sajid 2008-06-04 17:01
JNDI is matching 100%. What is interesting is if I remove the generated APPS_WF_EVENT_t .xsd and choose either no schema or any schema then I receive the event in my soasuite but it sends it to the reject folder. Any ideas what could be wrong?

Thanks
Sajid
Quote
0 #5 Tapash 2008-08-05 14:19
Could not initialize activation agent. : You will get this error while deployment, if you don't map the correct datasource while creating the connection factory.
Quote
0 #6 Antariksh 2008-08-06 15:27
Hi,

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.
Quote
0 #7 Sunil1979 2008-08-29 14:40
Followed every step but got this error??? Did I miss Anything???? Anil your input is appreciated :-)

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)
Quote
0 #8 Ram B 2008-11-05 11:58
Hi Anil,

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
Quote
0 #9 rampaag 2009-04-15 13:17
Anil,

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
Quote
0 #10 VivekOracleapps 2009-10-27 07:11
HI Anil,Excellant Article.
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...
Quote

Add comment


Security code
Refresh

Search Trainings

Fully verifiable testimonials

Apps2Fusion - Event List

<<  Aug 2021  >>
 Mon  Tue  Wed  Thu  Fri  Sat  Sun 
        1
  2  3  4  5  6  7  8
  9101112131415
16171819202122
23242526272829
3031     

Enquire For Training

Related Items

Fusion Training Packages

Get Email Updates


Powered by Google FeedBurner