Make in difficult problem easier on Oracle Cloud, OIC, VBCS, PCS, AIC, ICS, API CS, SOA, OSB, Java and much more...

Archive for November, 2017

Database polling in Oracle Integration Cloud Service

In this article, we will show how to use Oracle database polling in Oracle ICS. Oracle ICS allows very straight forward solution to poll the Oracle database in comparison to…

Read more

Expose custom PL SQL APIs as a SOA Gateway Webservice

Integrated SOA Gateway(ISG) is an integrated component of E-Business Suite R12. ISG allows to expose EBS functionality(which includes XML gateway, Business Service Objects, Concurrent Programs, PL/SQL API’s, Business Events, E…

Read more

Create an Integration in ICS to expose SOAP API

We’ll demonstrate how we can use Integration Cloud Service(ICS) to expose SOAP API. In one of my blog I have showcased how to expose REST API.In this article, we will…

Read more

Create Connection using external WSDL in Oracle Integration Cloud Service

Let’s assume we have some custom WSDL and want to use this WSDL in Oracle Integration Cloud Service. ICS provides a SOAP adapter that allows us to create a SOAP…

Read more

Switch activity in Oracle Integration Cloud Service

In this article, we will take a look at how to use Switch activity in Oracle ICS. Switch actions allow us to check for a condition and if true, execute a…

Read more

Scheduled Integration in Oracle Integration Cloud Service

In this article, we will take a look at the ability of Oracle Integration Cloud Service to Schedule an orchestrated integration. This is the very cool feature of Oracle ICS…

Read more

Logs in Oracle Integration Cloud Services(ICS)

The Integration Cloud Service dashboard provides a view into the activity stream for running integrations, such as details about successful responses received from the target application, successful responses sent to…

Read more

javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed

Sometimes users deal with “sun.security.validator.ValidatorException: PKIX path building failed” with the exception and don’t know how to solve the issue. Problem: This error occurred usually when we try to consume…

Read more

Bind query parameter in database adapter in Oracle Integration Cloud Service

In this blog, we will show you how to use bind parameter in SQL query when use Oracle Database adapter. Bind parameters are required to get the result based on the…

Read more

Convert UTC Date & time to another timezone in Oracle Integration Cloud Service(ICS)

Oracle Integration Cloud provides date and time in UTC (Coordinated Universal Time) format. So some time is required to change the UTC to another timezone as per the requirement. Oracle …

Read more