Category: SOA
-
Mater Detail Relationship In DB Adapter BPEL. 1 to M Relationship
In this post i will show how to create a Parent child relationship in Database Adapter. Create a new SOA Application in your JDeveloper with Empty Composite. Now follow these steps to configure a DB Adapter by using Parent child relationship 1) Drag and Drop a DB Adapter in External References and give its name.…
-
Oracle SOA Suite 11g Installation, Maintenance, Purging, Performance tuning, troubleshooting and Administration
I found very useful guide from Oracle which covers Oracle Fusion Middleware, Specially About Oracle SOA Server. It covers everything that we should know about Oracle SOA suite. Following are some main points of this document. 1) Installation of Oracle SOA Suite and Schema’s 2) Upgrade of Oracle SOA Suite 3) Administration of Oracle…
-
Integration of Oracle EBS with Siebel CRM, Mediator in Oracle BPEL, Integration of Two DBs
In this post i will show how to use Mediator in BPEL Process and Transformation of attributes. This post is part of my previous posts series. You should also go through previous posts to fully understand the scenario. Here is the link of previous post …
-
Inserting data using DB Adapter in BPEL SOA Suite
In this Post i am going to show how to insert data using DB Adapter in SOA Suite. This is a integration of Oracle Apps with Siebel CRM. First i will show you how to configure DB Adapter to insert data in it. I have two tables master and detail. I will show you only…
-
Store Procedure invocation using BPEL Process in SOA Suite
In this post i will show you how to call and get Data using DB Adapter that we have developed previous post. You can check it out here Store Procedure with Out Parameter. In this Post we will develop a BPEL Process to Invoke this stored Procedure. 1) Drag and Drop a BPEL Process in component…
-
Calling Stored Procedure in BPEL Process, Stored Procedure with Out Parameters
In this post i will show how to call a stored procedure with out parameters using DB Adapter. I have a package which consist of a procedure, this procedure has two output parameters one output parameter returns master data while the other return detail data. Actually i have created a table type structure which that…
-
Program to test Siebel CRM connectivity, Integration
package project1; import com.siebel.data.SiebelBusComp; import com.siebel.data.SiebelDataBean; import com.siebel.data.SiebelException; import com.siebel.data.*; import com.siebel.data.SiebelException; public class Class1 { public static void main (String args[]) { System.out.println(“This is a test”); SiebelDataBean m_dataBean=null; SiebelBusComp m_busObject=null; try { …
-
Enterprise Manager is not working http://localhost:7001/em
Case1 After installing and Creating domain for SOA server I was getting some problem while running my enterprise manager. the error was “Error 404–Not Found From RFC 2068 Hypertext Transfer Protocol — HTTP/1.1: 10.4.5 404 Not Found The server has not found anything matching the Request-URI. No indication is given of whether the condition is…
-
Could not initialize JCA Container
While connecting to JCA in Application Explorer I was getting the following error “Could not initialize JCA Container “ First i was starting Application Explorer i.e ae.cmd file from the following directory. C:OracleMiddlewareOracle_SOA1soathirdpartyApplicationAdapterstoolsiwaebin but this was creating above error. After this I started the setDomainEnv from the following directory C:OracleMiddlewareuser_projectsdomainsbase_domainbin by using Command prompt After running the…
-
Oracle Application Adapter for Weblogic Problem and solution
I was workign on Oracle Applicaton Adapter for Weblogic and I was getting the following error while connecting it. Basically I was using this Adpater for Integration with Siebel CRM. oracle/tip/adapter/api/exception/pcresourceexception The mistake that i was doing that I was not giving the correct home path in JCA config home this was default C:Oracle\MiddlewareOracle_SOA1soathirdpartyApplicationAdapterstoolsiwaebin………