Oracle Integration cloud is middleware platform offered by Oracle. This enables communication between multiple applications. All type of applications like Saas, on-premise can be integrated using OIC, Oracle ICS stands for Integration Cloud Service.
Oracle Integration Cloud OIC Interview Questions
Q1. What is Oracle Integration cloud?
Ans: Oracle Integration cloud is a middleware platform offered by Oracle. This enables communication between multiple applications. All type of applications like Saas, on-premise can be integrated using OIC Read more
Q2. What are the Application in OIC?
Ans: OIC Offer three applications:
(a) Integration cloud service(ICS)
(b) Process Cloud service (PCS)
(c) Visual Builder Cloud Service(VBCS)
Q3. Oracle Integration cloud comes under which category of cloud?
Ans: Oracle Integration cloud is a platform as a service(Paas)
Q4. What is Integration in Oracle Integration Cloud?
Ans: Integration are the main ingredient of Oracle Integration, An Integration includes trigger (source) connection and invoke (target) connection and the field mapping between those two connections.
Q5. What is adaptor in Oracle Integration Cloud?
Ans: Oracle Integration Cloud (OIC) Adaptor is a abstract way to connect to any application with the help of box adapter. There are 50+ adapters available in OIC, below are the categories
- Oracle Adapter(Oracle Sales Cloud, Oracle EBS, Oracle ERP adapter etc..)
- Non Oracle Adapter(Salesforce, Ariba, Concur etc..)
- Technology Adapter(REST, SOAP, FTP etc..)
Q6. How many design patterns are available in OIC and what are those?
Ans: There are total Six Patterns in Oracle Integration Cloud
- App Driven Orchestration
- Scheduled Orchestration
- File Transfer
- Basic Routing
- Publish To OIC
- Subscribe To OIC
Q7. What is App Driven Orchestration pattern?
Ans: App Driven Orchestration pattern is multi step pattern, allows invoking multiple applications in single flow, doing for-each loop, if-else logic, apply complex logic etc.
Q8. What is Scheduled Orchestration Pattern?
Ans: Scheduled Orchestration pattern allows you to develop an integration which can run on pre-defined frequency and can be executed on adhoc basis.
Q9. What is File Transfer Pattern?
Ans: File Transfer pattern allows to move files across network seamlessly and securely. This is again a scheduled type of pattern.
Q10. What is Basic Routing Pattern?
Ans: Basic Routing pattern can connect only two applications with no logic
Q11. What is publish to OIC and Subscribe to OIC pattern?
Ans: Publish to OIC pattern allows to publish messages to OIC internal messaging queues. For example an event is subscribed from Oracle Sales Cloud and Publish the same into Oracle Integration Cloud messaging queue.
Subscribe To OIC pattern subscribe messages from Oracle Integration Cloud messaging queue and sends the same to different applications
These queue are managed by OIC itself and you don’t have access of them
Q12. What is file Transfer pattern?
Ans: File Transfer pattern allows to move files across network seamlessly and securely. This is again a scheduled type of pattern.
Q13. What is basic Routing Pattern?
Ans: Basic Routing pattern can connect only two applications with no logic
Q14. What is lookup in Oracle Integration Cloud?
Ans: Lookups are associate values used by one application for a specific field to the values used by other applications for the same field. This provides the capability to map values across vocabularies or system.
For example, source application uses country code to represent country however target application uses country name to represent country. These mapping can be maintained using Lookup and will be referred by Integration during runtime.
Q15. What is mapper?
Ans: A visual mapper is provided that enables you to map fields between applications with different data structures by dragging source fields
Q16. what is package in Oracle Integration Cloud?
Ans: Package is used to group one or more integration into single structure. The package can be exported from source instance and imported into target instance. All integration which are part of the package will be imported automatically.
Q17. Difference between ICS and OIC?
Ans: Integration Cloud Service (ICS)
Simplify how you build integration in the cloud. This product lets you connect securely to applications and services both in the cloud and on premises. The infrastructure(cloud management, patching, backup, and restore) is managed by Oracle.
Oracle Integration Cloud (OIC)-
Process Cloud Service(PCS)- A process automation tool used to design, automate and manage business processes in the cloud.
Visual Builder Cloud Service(VBCS)- Allows you to rapidly create and deploy web and mobile applications directly from the browser with minimal coding required.
Q18. How to handle exception in Oracle Integration Cloud?
Ans: Exception can be handle using Scope activity and Global Fault handler in Oracle Integration Cloud.
Fault Handler are provided at the scope level to handle errors that arise during invoke actions within those scopes.
Global Fault Handler that is available at the overall integration flow level which acts as a super catch block.
Q19. What is business identifier in Oracle Integration Cloud?
Ans: Business identifier enable you to track payload fields in messages during runtime. You can specify up to three business identifiers fields for tracking during design time. One of these fields must be selected as the primary business identifier field.
Q20. What mapper function can you use to get the lookup value in Mapping Builder?
Ans: LookupValue
Q21. How many types of certificates can be imported from settings menu and what are those?
Ans: Three type of certificates can be imported into OIC. Certificates are used to validate outbound SSl connections and those are
- Identity Certificate
- Trust Certificate
- Message Protection Certificate
Q22. Which expression can you use to schedule integration runs?
Ans: iCal expression is used to defined scheduled runs into OIC.
For Example:
FREQ=DAILY;BYHOUR=17;BYMINUTE=30,40,50;BYSECOND=0;&
FREQ=DAILY;BYHOUR=18;BYMINUTE=0,10,20,30,40,50;BYSECOND=0;&
FREQ=DAILY;BYHOUR=19;BYMINUTE=0,10,20,30;BYSECOND=0;&
Q23. Can we store data into OIC?
Ans: OIC doesn’t allow you store data for future use. However OIC is having Stage activity which can be used to store data for temporary use. The data stored into OIC is flushed automatically as soon as instance is completed.
Q24. what is trigger and invoke role?
Ans: Trigger: Inbound for OIC. If something triggers an OIC that will be considered as inbound.
Invoke: Outbound to OIC. If any application is invoked by OIC, That will be considered as Outbound to OIC.
Q25. What is connectivity agent?
Ans: Connectivity agent is the agent that help you create integrations between on-premises applications and SaaS application.
Connectivity Agent acts as a Gateway from On-Premise to OIC.
This Agent is installed and run on an on-premise environment on the same network as internal systems such as Oracle E-Business Suite, Oracle Siebel, Oracle Database, and others
Q26. What are the pre-requisites to install connectivity agent?
Ans: Satisfy the system requirements before installing the connectivity agent.
1. the Agent is certified with Oracle JDK Version 8.
2. The agent is certified on the following operating systems
– Oracle Enterprise Linus 6.x, 7.2 and 7.5
– RedHat Enterprise Linux 6.6, 7.2 and 7.5
– Suse Linux Enterprise Edition 12 SP2
– Windows Standard Edition 2016
3. 8GB Memory with 4GB of heap size dedicated for the agent JVM
Q27. What is timeout limit of the connectivity agent?
Ans: This is 240 seconds. If request and response doesn’t completed with 240 seconds then transaction will get timeout and integration will get fail and throw error :
oracle.cloud.cpi.agent.trasport.aq.CpiAQException: Message not received within 240 seconds of wait interval.
Q28. What is payload limit of connectivity agent?
Ans: 10 MB is the message payload limit on Agent side. Which means if the message payload is more than 10mb of a single request the transaction will get fail.
Q29. Can we install OIC connectivity agent in High Availability(HA) mode?
Ans: Yes, OIC connectivity agent can be installed in HA mode. Agent HA provides an option to run multiple OIC Agents in Active-Active mode.
Q30. What is difference between FTP and File adapter?
Ans: FTP adapter can read/write file from FTP/SFTP which are accessible over the internet however File adapter allow read/write file form FTP/SFTP which is behind the firewall.
FTP adapter can’t poll files from FTP server however File adapter has polling capability
Q31. What are limitations of FTP adapter?
Ans: ‘Read a File’ operation of FTP adapter allows to read file which is less than 10MB only. To read file greater than 10MB use ‘Download File’ operation of FTP adapter.
FTP adapter doesn’t allow to poll new files from FTP server.
Q32. What exactly is an iCal expression?
Ans: The integration processes are scheduled using an iCal expression, which is a calendar script.
Q33. What is the distinction between SOAP and REST API ?
Ans: SOAP vs REST API
SOAP is a protocol that was developed prior to the implementation of REST. The main aim of SOAP was to make it simple for writing programs in a variety of platforms and programming languages to share data. The term SOAP refers to the Simple Object Access Protocol.
REST was created with the purpose of interacting with media elements, files, and even artefacts on a specific hardware unit. A Restful web service is one that is described using the REST principles. For working with the necessary components, a Restful service will use the standard HTTP verbs GET, POST, PUT, and DELETE. Representational State Transfer (REST) is an acronym for Representational State Transfer.