Creating a simple Oracle Integration

Open Oracle Integration Cloud Application and follow the below steps

1. Go to Design –> Click Integrations –> Click Create Button –> Click Schedule

Provide Name and Package for the Integration. I have given as XX_EBS_TEST_DEMO for Integration and DEV for Package and click Create

Now add a DB Connection. DB Connection should be created in prior. Enter the Endpoint and select the operation. Here in my case Im just running a sql statement

It will ask for Query and provide the query. I have provided select * from XX_DEBUG_MESSAGE. Once provided validate it. Click Continue and finish.

At the right edge to the below you will be able to see Error Icon. Click on it. It will ask for Primary Business Identifier. Update the Primary Business Identifier.

Drag and drop the startTime to Primary Business Identifiers Variable Undefined. The Errors will get removed and will be getting as below.

Now save the Integration and Activate it. As we have not defined any schedule it will be just activated. This is a very simple Integration. We will see more detailed on the next blog.