Oracle Integration Cloud Gen 3 Interview Questions (Intermediate)

The Oracle cloud interview Questions needed to prepare for Intermediate level Oracle cloud ERP and OIC interviews are listed below:

 

1. Which expression can you use to schedule integration runs? 

Oracle provides the functionality of Ical expressions to enable users to schedule runs of Scheduled Type integrations.

The Parameters for the iCal expressions are as follows:

a.) Freq: Defines whether the schedule runs Daily, Monthly or Yearly.

Possible Values: DAILY,MONTHLY and YEARLY

b.) BYMONTHDAY: Defines on which day of the month shall the schedule instance runs.You can list multiple values separated by commas.

c.) BYHOUR: Defines at what Hour in the Day shall the schedule Instance runs. You can list multiple values separated by commas.

d.) BYMINUTE  : Defines at what Minute in the hour shall the schedule Instance runs. You can list multiple values separated by commas.

e.) BYSECOND: Defines at what second in the minute shall the schedule Instance runs. You can list multiple values separated by commas.

 For Example:  

1. FREQ=DAILY; BYHOUR=12; BYMINUTE=20,40; BYSECOND=0;  

2. FREQ=MONTHLY; BYMONTHDAY=2,15,25; BYHOUR=17; BYMINUTE=0,10,20; BYSECOND=0;

You can define multiple schedules separated by & operator.

 2. What is the difference between an FTP and a File adapter?  What are the limitations of the FTP adapter?  

Both File adapters and FTP adapters serve similar functionality of handling files from a remote location to be accessed in OIC for processing. The similarities and differences between them are listed below:

Similarities

1. They both can be used to access files behind a FTP firewall through a connectivity agent.

2. They both allow Read, write, list, delete, move and download operations on a file server.

Differences 

1. FTP adapter allows PGP encryption/decryption while file adapter does not.

2. File adapter allows file polling while FTP adapter does not.

3. FTP adapter allows file polling while File adapter does not. 

3. Describe how you can implement version control for integrations in OIC.

Versioning is very important to make sure the right version is live and is picked for update while making a change. OIC supports semantic versioning which means any OIC integrations version number has the form XX.YY.ZZZZ

XX defines major Version

YY defines minor Version

ZZZZ defines patch version

Based on the scope and depth of changes, these versioning levels can be used.

It is also important to maintain the version details and history in the Integration description.

4. What features and steps are need to be taken care in Oracle Integration Cloud to ensure data security ?

     Security of data and integration artifacts while integration systems through Oracle Integration Cloud is a major step to be taken care while implementing ERP system integrations. The major capabilities and steps to be taken in Oracle integration cloud to safeguard data integrity and integration safety are as follows:

1. Use of SSH key pair instead of user name password while accessing SFTP servers from OIC.

2. Asking source systems to use encryption when sending Data files to SFTP servers for OIC consumption.

3. Use of OAuth Authentication when accessing Oracle ERP cloud Adapters.

4. Use of encryption while generating data files to output systems.

5. Defining access control roles like OICDeveloper, OICAdministrator to ensure rightful access to Integration Artifacts. 

5. What differentiates OIC from other integration platforms like MuleSoft or Dell Boomi ?

Oracle integration cloud is a low code platform provided by Oracle for connecting ERP different systems. It differs with other Integration platforms in the following ways:-

1. Synergy with Oracle Products: OIC has seamless integration with Oracle cloud ERP and VBCS through Cloud adapters and API Suite. This gives it a very high advantage over other platforms among Oracle cloud ERP users.

2. Ease of development: OIC provides drag and drop development with lower complexity and learning curve compared to other platforms.

3. Updated set of Adapters and features: OIC provides the latest gallery of AI and process automation features to enable effective and simpler integration design.

6. What is the usage of Opaque Schema in oracle cloud integration?

Opaque schema is used to convert Base 64 encoded unstructured data to decoded Structured data in OIC using stage file operation while reading a file. 

7. How do you call REST APIs in Oracle Integration Cloud?

The first step to call REST APIs in oracle cloud integration is to create a REST connection for which you need to provide a REST API url with Username and password.

Then go to the integration where you need to invoke this REST API, Choose the Rest connection and configure it by providing the Relative URL, the request Payload and Response Payload.

Provide the relevant mappings and test the integration.

 

8. What is the Use of projects in Oracle Integration cloud Gen 3?

Projects is a new feature used in OIC Gen3 where you can club integrations, connections, lookups and libraries in a single view to set context and security at a project level.

This help in management of resources and quick access.

9. What is the distinction between SOAP and REST API?

SOAP (Simple Object Access Protocol) is a Older protocol which uses xml based Payloads Defined by WSDLs. It Contains operations/functions to perform certain tasks like readfile or download files.

REST (Representational State Transfer) was Advanced protocol which can use JSON or XML based payloads. It has intended operations like GET, POST, PUT, and DELETE. Its faster and lightweight.

10. What are the various file size limitations when reading or writing a data file in Oracle integration Cloud?

Both file adapter and FTP adapter supports reading or writing files upto 1 GB without schema whereas 50 MB when reading or writing files with Schema. Though Download file operation supports file upto 1 GB.