Tuesday 19 February 2013

Step by Step Guide to Create Transaction in Oracle BTM

End to End Monitoring is becoming a must have solution for now a days application. As business transaction needs to be monitored in complex scenarios where we're navigating from one systems to another and wants to manage if information is propagated to end systems successfully. 

I will not go into the details here as its very well written on other places on internet.

Here I will explain how to create one simple  BTM Transaction.

Our Test service is simple one.. BTM HelloWorld. it takes one parameter and calls another service BTM Consumer Service on some other location where BTM Observer is not installed.

Now we're going to monitor this using BTM.

First Step is to login to BTM UI and click on Create Transaction link from top left corner of BTM UI as shown in following figure

 Then following screen will come up.


Then we need to select add Operation button as shown highlighted in following  gui


browse the service in our case it is BTM Hello world.


On next tab select the logging options as shown in following screen.


After finishing with the transaction creation control will goes back to main screen which will be showing the transaction detail as following.



Now we will give call to our BTM Hello World Service either from SOAPUI or from em console. And will come back to see if the transaction is logged in BTM.

We can see the transaction details like throughput, completed transactions etc along with the message logs as shown in following screen short.



 Following screen shows the Analysis for our BTM Trans 1


Following screen shows the conditions for our BTM Trans 1


Following screen shows the policies for our BTM Trans 1


Following screen shows the Summary for our BTM Trans 1

 Following screen shows the Instances for our BTM Trans 1


This was the simplest good to start of creating transactions on BTM. But I am still exploring it and will come up with more stuff in future.


Friday 8 February 2013

Oracle Apps Adapter in SOA 11g vs Apps Adapter in SOA 10 g

Once migrating our integrations from oracle Soa 10 g to 11g we faced issue while calling oracle APIs using Oracle apps adapter. Everything looks fine at OEBS side. Because integration from SOA 10g was still working perfect and when we try to execute migrated interface from SOA 11g fails...

We had checked the JCA settings several times. Responsibility and user were correctly assigned as the same values were working fine for 10g.

After investigating a lot we decided to debug the Apps Adapter jar file deployed on SOA 11g as it's version was different on SOA 10g. We got a solution from there as there were few SQL queries this apps adapter calls before executing the Apis and our user don't had access to query those tables.

In my next post I wi try to share the details of it.

But it's quite strange that this information or clue for such problem was not available or I was not able to find it over the Internet nor at oracle support.