Oracle Integration Cloud Interview Questions

35+ Oracle Integration Cloud OIC Interview Questions

15489 Views 0

SaveSavedRemoved 2

Looking for OIC Interview Questions? Be here. Oracle integration cloud is a hot product from Oracle and is picking up steam in the IT integration market. I have seen a dearth of skilled workforce in many companies and there is a big demand for OIC resources. Oracle OIC previously known as Oracle ICS ( Integration Cloud Service) was also known as oracle autonomous integration cloud at some point.

Though doing a Certification is one way to get the required knowledge, job interviews are not limited to certification questions.

If you are from an EBS background the questions would be more varied and it gives scope for the interviewer. Do go through and brush up on oracle app technical interview questions.

The expectations would also be around understanding enterprise architecture, which may consist of PaaS, SaaS, and OnPremise applications. The scenario can be of having cloud products from different vendors. I can recommend a small Course around Enterprise architecture to build that understanding.

Here I am going to share 35+ Oracle Integration Cloud OIC Interview Questions, Some typical and not so simple which Candidates can prepare and Interviewers can frame around during interviews. So let’s get started !!

mala min OIC Interview Questions 1 — You Can Become Digital Entrepreneur!

Frequently Asked OIC Interview Questions

What are the products within OIC?

Integration Cloud , VBCS (Visual Builder Cloud Service) , PCS ( Process Cloud Service)

Is OIC PaaS , SaaS or IaaS ?

The interviewer wants to test your understanding here. OIC’s old name was ICS and it was started as a PaaS Service. Later most of the Platform Services are now part of IaaS. Definitely not SaaS
refer https://www.oracle.com/index.html Click on products to check the latest hierarchy

What are the types of Integration Patterns?

App Driven, Scheduled Orchestration, File Transfer, Basic Routing, Pubish to OIC , Subscribe to OIC

What is the difference between Trigger and Invoke Connection?

Trigger – It can only trigger . Trigger and Invoke Can invoke from inside the process as well

What is the Difference between Rest and SOAP API?

At High level Rest is light weight and reduces the load on network , more user friendly, supports different formats. SOAP is heavy , Full object has to be send for communication . Refer to the article Rest Vs Soap API for more details.

What are the prerequisites for OIC to read a Business Event from Oracle SaaS?

Business Event should be enabled from SaaS
CSF Key of OIC needs to be registered in SaaS Soa Composer
OIC process should have subscribed the specific Event in SaaS
In some cases Fusion SaaS Certificates should be imported in OIC

What is Service Catalog URL of Oracle Fusion SaaS?

This is a WSDL URL used in OIC connections to fetch the list of services available. The newer versions of OIC do not need this URL now. The domain name can be directly used.

What is the difference between a template parameter and query parameter?

The template parameter is the part of the Rest API path and denoted by {variable} whereas Query parameter is query string appended after the question mark “?” in the rest API url.

Have you Used Adapters? Why and when do you use Adapter instead of direct Rest or SOAP Call?

Adapters make calling specific business services easy as they expose the required services with all the security measures. The connection can only call the services to which it is authorized to.

What is a feature Flag in OIC?

To enable disable certain features which are still not part of mainstream GA application.

What is Opaque Schema?

When you just want to write/read the file as binary. Opaque schema can be used.

Is editing XSL mappings allowed? Have you ever modified XSL mappings in OIC?

XSL mappings can be modified externally and can be uploaded as new maps. The integration process gets locked if an XSL modified outside is uploaded.
The newer release provides the capability to edit xsl in OIC mappings design view directly.

You are given an old integration IAR to be imported and when you do you get a function error, How do you fix it?

Some old functions may be deprecated or there can be namespace issues. Generally, xsl file needs to be corrected with the correct function and namespaces which the OIC can understand.

What is NameSpace in XML file?

Namespace defines and identifies uniquely the elements in the Payload.

When do you need an Agent to be installed?

Generally when connecting to on-premise Databases. Agent provides a secure tunnel to connect to target.

When should we choose a scheduled orchestration over app driven?

When source payload is not available immediately Scheduled orchestration is used. This will not be realtime or near real-time. AppDriven integrations are better for realtime flows.

What are Synchronous and Asynchronous Processes?

Synchronous- Fire and Wait for response
Asynchronous- Fire and Forget.

What is Callback functionality in OIC?

To call the OIC process back after the control has moved to a partner service.

Types of Certificates in OIC ?

Identity Certificate
Trust Certificate
Message Protection Certificate

What is Lookup in OIC?

lookup are used to store the corresponding values from two system talking to each other. For example supplier number on source application is equivalent to vendor number in target application . We can have this mapping stored as lookup in OIC.

In the OIC mapper, you do not see your expected fields. What do you do?

Try expanding the nodes using right-click show extended types attributes link.

What is iCal Expression?

iCal Expression is a calendar script to schedule the integration processes.

Is there any message payload limit during processing in OIC? If yes how much and how do you handle larger files?

10MB is the limit . For payloads greater than that chunking has to be used.

How do you read a file of size 500 MB in OIC ?

Till 10MB You can read and process in one go. For file > 10 MB it has to be downloaded using ftp adapter to stage and choose “Read File In Segments” in stage file operation.

How do you Poll for files in OIC?

File adapter doesn’t support polling for now.

What is the structure of JSON payloads?

JSON payload is in form of Key : Value Pair.

Please explain the structure of Rest API metadata.

A high level It has the information of operations and payload structure.

Describe the structure of the WSDL?

The basic structure is
Definition ( Name of service)
TargetNamespace ( Namespaces for identification of elements)
DataTypes ( schema Datatypes)
Messages (Data Elements)
Porttype (Operations)
Bindings (Protocol and data format)
service (Port address(es) of the binding)

How do you create CSF key ?

There is a format where you need to use the identity domain.

What do you do when you need to change your source and target connection of a deployed process.

There are services to alter the connections URL.

Which products you have used to integrate and explain your business scenario.

Explain what you did in your integrations.

Which activity in OIC can be used to trigger Parallel Flow?

Parallel Flow like Flow N from BPEL is not yet available in OIC.

I need a process in OIC which returns a payload. Please explain the Design.

Explain the Request and response method and the rest adapter capabilities.

Did you use BIP web service for integrations with fusion SaaS?

Explain How BIP data is used . Report Bytes Form.

What is Base 64 Encoding?

And encoding format which has to be decoded using decode functionality.

What is Publish to OIC and Subscribe to OIC?

Pushing payload messaging to OIC message queue and Reading payload messages from OIC message queue.

What are Error handling Features?

Exception handling is available as fault handlers.

You need a custom repeatable logic in OIC to be used in multiple processes. How to achieve?

Create a custom function in javascript in add to Library.

What is Asserter?

Asserter recording can be used for understanding the execution.

How to rerun a failed OIC process?

From the Tracking, menu processes can be rerun.

Which other integration platform you have worked? What are the key differences compared to OIC?

Explain differences with any if you have worked. Like SOA Suite, MuleSoft etc.

What do you understand by Enterprise Architecture?

You should be able to explain the homogenous cloud, hybrid cloud, community cloud. how it can co-exist with existing applications of an enterprise. What are the options for Lift and Shift? How OIC fits in where. Check out some suggested courses at the end of the article.

Which Blogs do you follow to keep yourself updated on Oracle OIC?

Example: Oracle’s blog at https://blogs.oracle.com/integration/

Which books on Oracle OIC you have read or planning to read?

Check below

What are the new features in OIC in 2022?

Asserting Recording is decommissioned.
In May 2022 release the activity stream supports native payload. Two new nodes “wire” and “metadata” is added. Native payload is only logged when the request is made directly to the endpoint i.e. without a connectivity agent. It is supported for both SOAP and REST.

These were some of the oracle integration cloud interview questions, hope you got an idea. Thanks for reading!

Books

Knock 'em Dead Job Interview: How to Turn Job Interviews into Paychecks

Last update was on: May 21, 2022 3:23 pm

in stock

$8.69

Check Details

Implementing Oracle Integration Cloud Service

By Robert van Molken & Phil Wilkins

See on Amazon

Recommended Book

Online Oracle Integration Cloud Trainings

If you are new to OIC and looking for online training courses, here are a few OIC-focused trainings listed below that can give you a head start!

1. OIC course with Oracle Fusion Technical Training on Udemy

Check Details

This training covers Fusion Technical and OIC bundle (OIC /PCS/VBCS) and covers Dell Boomi as well, which is good to work on hybrid integrations. Also provides some use cases with Python and gives an understanding of Business process flow in the ERP and Financials.

A Good Training Overall!

2. OIC Training on Eduonix

Check it out !

A Way To Learn Oracle Integration Cloud

The course will help you to prepare for the 1Z0 1042: oracle cloud platform application integration specialist exam.

Also, Check out

Oracle PCS Interview Questions

Oracle Fusion Technical Questions

BI publisher interview questions

Do read the different Cloud deployment models.

Good Luck!