Oracle Applications E-Learning Lab

  This article will focus on building SOAP integration in OSB to access data from a database. In this integration, we will utilize the database adapter as a business service, which needs to be configured with select operations. The business service will be called through a proxy service to retrieve data from the database. For this tutorial we will use the existing business service , if you are unaware kindly visit this link Database as Business Service Assuming that we have followed the above link and created Business Service  Create Proxy Service  Select the WSDL of Business Service in Proxy Services  Create PipeLine Drop Routing Node on the Pipe Line Pair  and select Business Service  Run the Proxy Services  Provide the parameter in the payload  

This article will focus on building SOAP integration in OSB to access data from a database. In this integration, we will utilize the database adapter as a business service, which needs to be configured with select operations.  To begin building the integration, the first step is to create a table. Please use the script below to create the table structure: CREATE TABLE XXOSB_PRACTICE_TEST ( CUST_ID NUMBER, CUSTOMER_NAME VARCHAR2(1000), CUSTOMER_CITY VARCHAR2(1000), CUSTOMER_DESIGNATION VARCHAR2(1000), CREATION_DATE DATE, CREATED_BY NUMBER, LAST_UPDATE_DATE DATE, LAST_UPDATE_LOGIN NUMBER, LAST_UPDATED_BY NUMBER ) Insert one dummy record into the table  INSERT INTO XXOSB_PRACTICE_TEST (CUST_ID,                                  CUSTOMER_NAME,                                  CUSTOMER_CITY,                                  CUSTOMER_DESIGNATION,                                  CREATION_dATE,                                  CREATED_BY,                                  LAST_UPDATE_DATE,    

 If you every come across below type of error  ; nested exception is:   BINDING.JCA-11622 Could not create/access the TopLink Session. This session is used to connect to the datastore. Restart the Weblogic server and test again

A business service in OSB is a configuration object that represents an external system or service that you want to integrate with. It defines the endpoint URL of the target system, which is the specific address where the external service can be accessed. In addition to the endpoint URL, a business service also defines the transport protocol used to communicate with the target system, such as HTTP or JMS, and any associated security requirements such as SSL or username/password authentication. By defining a business service in OSB, you can abstract the details of the target system and create a standardized interface that can be used by other services or systems within your organization. This makes it easier to manage and maintain integrations over time, as changes to the target system can be made without affecting the other systems that rely on the business service. In this article, we will cover how to configure business services in Oracle Service Bus (OSB) 12c. To configure business s

In OSB, while using the JAVA Callout function, we often face a limitation where if a Java program returns a single value, we can assign it to a result set in OSB and display it in the payload. However, if the Java program returns multiple values, it becomes challenging to assign them to a result set in OSB. In such cases, we need to create an XML format for the payload within the Java program itself to handle the multiple return values. To achieve the above objective, we first need to create a Java file and then generate a JAR file based on it. Generate the JAR based on below JAVA program.  Generate JAR File package javamultixmlprj; import org.apache.xmlbeans.XmlObject; public class CustJavaMultiXML { public CustJavaMultiXML() { super(); } static XmlObject newObject; public static XmlObject CustomerAddress(int CustId) { String Name=""; String City=""; String Designation="";