Oracle HCM Cloud Placements and Training
Interview Questions

Oracle Integration Cloud (OIC) Interview Questions

Pinterest LinkedIn Tumblr

If you are one of those keen to make your professional career in Oracle Integration Cloud and preparing to appear for an interview, you must be aware of popular Oracle Integration Cloud Interview Questions.

Take a look at some of the questions that you will come across while appearing to interview an integration specialist prepared by IQ Stream Technologies Bangalore. Students can request Oracle Integration Cloud online training course material here.

What is Oracle Integration Cloud (OIC)?

It is a tool for cloud-based integrations. Oracle Cloud (SaaS) Apps can be effortlessly integrated with on-premises applications or other cloud Apps like Workday, Salesforce, etc., OIC relies on adapters to connect to the other applications/technologies like any other integration tool.

An adapter attaches to OIC, which functions as a pipe capable of altering and mapping data between two distinct entities — Using OIC, the data is read, mapped, converted, orchestrated from the source using Connection Adapters, and then transmitted to the destination via the same Connection Adapters.

What are the types of Integration Patterns?

It is possible to develop simple integrations to complicated ones with the help of six patterns provided by OIC. Those are: Basic Routing, App Based Orchestration. Scheduled Orchestration, File Transfer, Publish to OIC, Subscribe to OIC. Most commonly used are App Driven Orchestration and Scheduled Orchestration. Basic Routing is deprecated in the recent versions.

App Drive Orchestration

Simple to complicated integration is possible with Orchestration patterns. Use an event or a business object to trigger an integration. This pattern enables the integration developers to build complex business logic with the help of various actions available like Assign, Switch, For Each, Map, Data Stich, Global Variables and fault related actions.

Scheduled Orchestration

The pattern is similar to App Driven Orchestration except that it also enables you to build an integration that can be scheduled to run at a predetermined frequency as well as on an ad hoc basis.

File Transfer

We can move files between FTP locations using this approach.

Basic Routing

This makes it possible to construct an integration with a single source and a single target system that does not include any logic or data processing. This is deprecated in the recent versions.

Publish/Subscribe to OIC

You can use the built-in messaging queues provided by Oracle Integration Cloud to publish and subscribe to messages.

What is an adapter in Oracle Integration Cloud?

OIC Adapters make it possible to third-party applications, Oracle Cloud apps, and Oracle on-premise applications like Oracle E-Business Suite to interface effortlessly. There are many adapters available in OIC that are categorized into application adapters like EBS, SAP etc., cloud application adapters like Oracle ERP Cloud, Oracle HCM Cloud, Salesforce, Workday etc., Technology adapters like FTP, File, Database, REST, SOAP etc.,

Track and Trace REST APIs

Tracking documents, including purchase orders, sales orders, and work orders, can be submitted to Oracle Intelligent Track and Trace from many trading partners. Trading partners use The Oracle Intelligent Track and Trace OIC adaptor to post these transaction documents from multiple business apps into Oracle Intelligent Track and Trace.

What is the difference between Trigger and Invoke?

Two adapter connections one can use in an integration: a trigger (source) and an invoke (target). The configuration wizard for creating a trigger connection or invoke connection depends on the corresponding Adapter. During connection creation, it only needs the end point details to connect with the underlying application/technology resource. However, when you drop the connection in an integration, it’s going to open another configuration wizard where you will need to set request/response related information etc.

Trigger Connections

Trigger connection is the entry point for an integration. Trigger connection can’t be dropped in any other point in the integration flow other than the first point. Some of the adapters that support trigger connections are: REST, SOAP, File, Oracle Database, Oracle Cloud ERP. However, there are more such adapters that support Trigger connections.

Invoke Connections

Invoke Connection is used for invoking any underlying technology/application. This connection can be used any point in the integration flow. Based on the type of connection there will be a need to configure the Request and Response samples when used in an integration. If the connection is one-way, it will not contain response. Some of the examples are: REST, SOAP, File, FTP, Oracle Database, Oracle Cloud ERP, Salesforce, Workday.

Related Interview Questions:

Oracle Fusion HCM Absence Management Interview Questions

Azure Logic Apps Interview Questions

Oracle HRMS Payroll Management Questions

Oracle SOA Interview Questions

What is the Difference between Rest and SOAP API?

In a service interface, one can use SOAP to expose an application’s business logic to a server, whereas REST uses URIs. REST APIs are designed around data, whereas SOAP APIs are designed around functions. You can include a function like “CreateUser” in a SOAP API that allows creating a user. This function would be a part of the SOAP body.

REST is a data-driven architecture, whereas SOAP is a standard protocol for transmitting structured data that is more function-driven. Unlike SOAP, which only allows the use of XML, REST allows the use of a wide variety of data types, including plain text, HTML, XML, and JSON. The only options for SOAP APIs are XML and the format of the SOAP is called envelope which contains header and body. REST APIs, on the other hand, is format independent. Although JSON is the most popular option, XML, plain text, and XML are all suitable formats for REST APIs.

What is Opaque Schema?

No need to worry about the file’s schema while performing Read File or Write File operations with an opaque schema. This is the only requirement: Base64-encoded data should be available to the opaque element. The Opaque schema is needed in OIC especially when you need to write a Bse64-encoded data using stage file to extract it into a structured variable. For example, when BIP report is run using Report Service in OIC the response will be always in Base64-encoded data. In order to extract that report response into a structured variable, which will enable to refer the individual elements there is a need to write it using stage file and read back using sample data as per the requirement. The stage file write operation does not have an option to write without structure, in that case Opaque schema can be used.

What do you understand about Enterprise Architecture?

EA is a conceptual blueprint that outlines the organization’s structure and operations. One can better serve an organization’s present and long-term goals by utilizing an enterprise architectural approach. When it comes to enterprise architecture, it’s all about looking at the big picture, planning, developing, and then implementing.

As a result of EA’s focus on bringing together legacy applications and processes to create an integrated environment, digital transformation can be easier for enterprises. EA frameworks rose in popularity throughout the 1980s, when businesses needed a mechanism to respond to rapid technological advancements as part of their overall strategy. Later, this procedure gets extended to include not only IT but the entire organization (IT). As a result, the rest of the company would be able to keep up with the pace of digital change.

What is Namespace in XML file?

It is possible to use an XML Namespace to organize the names of various elements and attributes in an XML document. The Namespace ensures that no two elements with the same name exist on the Internet, thereby preventing any confusion. Whatever the URI or URN points to, the Namespace’s identifier is the same across all platforms and browsers. Because URIs are globally unique across the Internet.

It is possible to declare Namespaces in two ways: explicitly or by default. You can use a prefix, or shorthand, instead of the complete name of a Namespace by making an explicit declaration. Elements in that Namespace get prefixed with this prefix. A node containing items from several Namespaces can benefit from explicit declarations. There is no need for prefixes in a default declaration, which specifies a Namespace for all elements inside its scope.

What is iCal Expression?

To schedule an integration using iCal expressions (more flexible in specifying various frequencies) from the provided start date to the supplied end date, use this frequency.

The iCalendar (RFC 2445) protocol gets supported by OIC, but not COUNT, UNTIL, BYSETPOS, or WKST.

Please note that the end date or until date can be left out. It will continue to repeat itself if you don’t provide any value.


– Create events, tasks, and reminders.

– Define the start and end time for an event.

– Specify the duration of an event.

– Specify whether an event repeats over time (for example, every Wednesday).

How do you create a CSF key?

Credential Store Framework (CSF) provides a way to store, retrieve and delete credentials for a Web service and other applications. For example, the oracle/wss_username_token_client_policy policy includes the csf-key property, with a default value of basic.credentials. This credential is stored in the CSF.

Usernames and passwords one can store in a password credential. Any credential object one can store in a generic credential. You can store the alias and the key pair for each credential in the store. One credential gets associated with a group of various keys, which is popular as an alias or the map name. The store’s primary key is a combination of the map name and the key name.

  • EM console⇾SOA OSB domain then Security⇾Credentials
  • Create map⇾map name: oracle. WSM. security
  • One can use the Create Key command if the map is already available or the map creation is completed.

We are ready to use the CSF key now!

What are Accelerators and Recipes?

There are two basic types of accelerators. An end-to-end business process or use case that a business accelerator provides.

Technical Accelerators—They offer a standard solution, such as sending an email, pager, or Jira notification when integration fails. Jira is a tool for managing issues and projects. Organizations of all sizes use it to track everything from bug fixes and feature requests to business processes and workflows. You can purchase an accelerator from the market at certain times.

Recipes serve as illustrative starting points for your creations. If you want to link Oracle ERP-Cloud with Amazon S3, you can use the existing recipe and tweak it to meet your needs.

What is Base 64 Encoding?

To encode binary data into an ASCII string, Base64 uses the radix-64 encoding method, which converts the binary data to an ASCII string representation. The MIME content transfer encoding is where the word “Base64” comes from.

If you need to encode binary data that must be saved and transferred via ASCII-based media, Base64 encoding algorithms are a typical choice. It is protected from being corrupted or altered in transit. XML and MIME are only two examples of applications that bring extensive utilization of Base64.

Write A Comment

Enquiry Now
close slider



    Call Now