23 Jul, 2026
0 Comments
17 Mins Read

Oracle Integration Cloud (OIC) Interview Questions

Oracle Integration Cloud (OIC) Interview Questions and Answers

What is Oracle Integration Cloud (OIC)?

Answer:
Oracle Integration Cloud (OIC) is a cloud-based integration platform (iPaaS) that enables organizations to connect cloud applications, on-premises systems, SaaS applications, and APIs with minimal coding.
What are the components of OIC?

Answer
- Application Integration
- Process Automation
- Visual Builder
- File Server
- B2B
- Connectivity Agents
- Monitoring Dashboard
What is Integration in Oracle Integration Cloud?

Answer:
An Integration in Oracle Integration Cloud (OIC) is a workflow that connects two or more applications, systems, or services to exchange and transform data. It allows communication between cloud and on-premises applications using prebuilt adapters, mappings, orchestration, and error handling.
What is a File Transfer Pattern?

Answer:
The File Transfer pattern automates the movement of files between systems without requiring orchestration.

Use Cases:
- Move files from FTP/SFTP to Oracle ERP
- Archive files
- Transfer CSV/XML/JSON files
What are the different integration patterns in OIC?

Answer
- App Driven Orchestration
- Scheduled Orchestration
- File Transfer
- Publish to OIC
- Subscribe to OIC
- Basic Routing
What is App Driven Orchestration?

Answer

It is an event/request-based integration where one application triggers another immediately.

Example:
Salesforce creates a customer → OIC → ERP creates customer.
What is Scheduled Orchestration?

Answer

Runs automatically based on a predefined schedule.

Example:
- Every hour
- Daily
- Weekly
- Monthly
What is Connectivity Agent?

Answer

Connectivity Agent securely connects OIC with on-premises applications without exposing internal systems to the internet.

Uses:
- Oracle Database
- SAP
- On-prem ERP
- FTP Servers
What are Adapters in OIC?

Answer

Adapters are prebuilt connectors used to connect applications.

Examples:
- REST Adapter
- SOAP Adapter
- FTP Adapter
- Database Adapter
- ERP Cloud Adapter
- HCM Adapter
- Salesforce Adapter
- SAP Adapter
Difference between REST and SOAP Adapter?

REST SOAP

Lightweight XML Based

JSON XML

Faster Slower

Uses HTTP Methods Uses SOAP Envelope
What is a Lookup in OIC?

Answer

Lookup is used to map one value to another without hardcoding.
What is Mapping in OIC?

Answer

Mapping transforms source data into target format using drag-and-drop mapper.
What are Assign Activities?

Answer
Assign activity is used to create variables and assign values.
Example
EmployeeID = 1001Status = Active
What is Switch Activity?

Answer

Groups multiple actions together.

Used for:
- Error Handling
- Transactions
- Local Variables
What is Scope Activity?

Answer

Groups multiple actions together.

Used for:
- Error Handling
- Transactions
- Local Variables
What is Fault Handling?

Answer

Fault Handling captures runtime errors.

Types
- Global Fault
- Scope Fault
Used for
- Retry
- Logging
- Notifications
What is a Basic Routing Pattern?

Answer:
Basic Routing is a simple request-response integration where an incoming request is routed directly to one target service with little or no business logic.
Difference between Global Fault and Scope Fault?

Global Fault Scope Fault

Entire Integration Specific Scope

Handles all errors Handles local errors
What is Publish to OIC and Subscribe to OIC Pattern?

Publish to OIC

Publishes a business event or message to OIC for asynchronous processing.

Subscribe to OIC

Consumes events published by another integration and processes them.
What is Stage File Action?

Answer

Used to read, write, zip, unzip, and process files before sending them to another system.

Supports:
- CSV
- XML
- JSON
- ZIP
What is File Server in OIC?

Answer

Secure cloud storage where applications exchange files without external FTP servers.
What is Tracking Variable?

Answer

Tracking variables help identify and monitor integration instances.

Example:

Order Number

Customer ID

Invoice Number
What is Business Identifier?

Answer

A field selected to search integration instances quickly.

Example

OrderID

EmployeeID

InvoiceID
What are Connections in OIC?

Answer

Connections define connectivity between OIC and external applications.

Contains:
- Credentials
- Adapter
- Endpoint URL
- Security
What are the authentication methods supported in OIC?

Answer
- Basic Authentication
- OAuth 2.0
- JWT
- API Key
- Username/Password
- Client Credentials
- Certificates
What is an Integration Package?

Answer

A package containing integrations, lookups, connections, libraries, and other artifacts for deployment between environments.
What is the difference between Activate and Save?

Save Activate

Stores Draft Makes Live

Cannot Run Ready for Execution
How do you deploy integrations between environments?

Answer
1. Export Package
2. Import into target environment
3. Reconfigure connections
4. Activate integrations
How do you monitor integrations?

Answer

Using Monitoring Dashboard.

Shows:
- Success
- Failed
- Running
- Stopped
- Payload
- Logs
How do you call one integration from another?

Answer: Use the OIC Integration Adapter (or REST endpoint if the integration is exposed as a REST service) to invoke the target integration.
How do you process a large CSV file?

Answer:
- Use the Stage File action to read the file.
- Process records in batches where possible.
- Use loops and streaming techniques to avoid loading the entire file into memory.
What happens if an ERP service is unavailable?

Answer:
- Capture the exception using fault handlers.
- Retry if appropriate.
- Log the error details.
- Send a notification.
- Resume or reprocess once the service is available.
How do you secure REST APIs in OIC?

Answer:
- OAuth 2.0
- Basic Authentication (where appropriate)
- API Keys
- JWT
- SSL/TLS
- Role-based access control
What are the deployment environments in OIC?

Answer:
- Development (DEV)
- Test (TEST/UAT)
- Production (PROD)
What is Payload Tracing?

Answer

Captures request and response payloads for debugging integration failures.
What is the CSF Key?

Answer:
A Credential Store Framework (CSF) Key securely stores credentials such as usernames and passwords so integrations can access external systems without hardcoding sensitive information.
How do you improve OIC performance?

Answer
- Reduce unnecessary mappings
- Use parallel processing
- Optimize database queries
- Reuse connections
- Avoid large payloads
- Enable pagination
- Archive old instances
What do you understand by Utility Computing?

Answer:
Utility Computing is a cloud computing model where IT resources are provided on demand and customers pay only for what they use, similar to utilities like electricity or water.

Benefits:
- Scalability
- Cost efficiency
- Elastic resource allocation
What is an Orchestrated Integration?

Answer

An integration that controls multiple service calls, decisions, mappings, loops, and exception handling within a single workflow.
What is the timeout limit of the Connectivity Agent?

Answer:
The default timeout is 240 seconds (4 minutes) for many synchronous operations. This can vary depending on the adapter and endpoint configuration.
What is the payload limit of the Connectivity Agent?

Answer:
The Connectivity Agent supports payloads up to 1 GB for supported file-based operations. For synchronous REST/SOAP integrations, practical limits are much lower, so large payloads should be processed using files or chunking.

What is the difference between the FTP Adapter and the File Adapter?

FTP Adapter	File Adapter
Works with FTP/SFTP servers	Works with local/on-premises file systems (via Connectivity Agent)
Network-based	Local file system access
Requires FTP credentials	Uses local file access
Remote file transfer	Local file processing

What are the retention period and default retention period of a database in OIC?

Answer:
Integration instance retention is configurable by administrators. The default retention period is typically 32 days, though it depends on the OIC edition and service configuration. Historical data can be purged based on retention policies.
What is a Feature Flag in OIC, and what is its lifecycle?

Answer:
A Feature Flag enables Oracle to control access to new or preview functionality.

Lifecycle:
1. Preview/Early Access
2. Optional Enablement
3. General Availability (GA)
4. Enabled by default
5. Retirement (if applicable)
Can we store data in OIC?

Answer:
OIC is not designed as a database.

However, data can be stored using:
- Variables
- Stage File
- ATP Database
- Oracle Database
- External databases
- File Server
How do you handle exceptions in Oracle Integration Cloud?

Answer:
Exception handling is implemented using:
- Global Fault Handler
- Scope Fault Handler
- Throw Fault Activity
- Logging
- Notifications
- Retry mechanisms
Common steps:
1. Catch exception
2. Log details
3. Notify stakeholders
4. Retry or terminate gracefully
How many types of certificates can be imported from the Settings menu?

Answer:
Common certificate types include:
- Trust Certificates
- Identity Certificates
- Message Protection Certificates
- PGP Keys (for encryption/signing)
These are used for SSL/TLS, authentication, and secure message exchange.
Explain a real-time OIC integration example.

Answer

Scenario: Employee onboarding
1. Employee created in Oracle HCM
2. Event triggers OIC
3. OIC validates data
4. Creates employee in Active Directory
5. Sends data to ERP
6. Creates email account
7. Sends welcome email
8. Updates status in HCM

What is the difference between ICS and OIC?

ICS	OIC
Oracle Integration Cloud Service	Oracle Integration Cloud
Integration only	Integration + Process + Visual Builder + File Server + B2B
Older platform	Current unified platform
Limited capabilities	More comprehensive iPaaS offering

Explain an end-to-end OIC project you have worked on.

Sample Answer:

I worked on integrating Oracle ERP Cloud with Salesforce using Oracle Integration Cloud. I created REST and ERP adapters, designed mappings, configured lookups, implemented error handling using Scope and Global Fault Handlers, monitored integrations, and deployed packages across DEV, TEST, and PROD environments. I also optimized performance by reducing payload size and using tracking variables for easier monitoring.

What is the distinction between SOAP and REST API?

Answer:

SOAP (Simple Object Access Protocol) and REST (Representational State Transfer) are two different approaches used for web services communication.

SOAP

SOAP is a protocol with strict standards. It exchanges data only in XML format and uses a WSDL (Web Services Description Language) file to define the service.

Features:

XML-based messaging
Supports WS-Security
Platform and language independent
Highly secure
Suitable for enterprise applications
Supports ACID transactions

Advantages:

High security using WS-Security
Reliable messaging
Standardized protocol
Better for financial and banking applications

Disadvantages:

Heavy payload
Slower due to XML processing
More complex to develop

REST

REST is an architectural style that uses HTTP methods for communication. It supports multiple data formats, with JSON being the most commonly used.

HTTP Methods

GET – Retrieve data
POST – Create data
PUT – Update data
DELETE – Delete data
PATCH – Partial update

Features

Lightweight
Fast
Easy to develop
Stateless communication
Uses JSON/XML

Advantages

Better performance
Easy integration
Lower bandwidth usage
Mobile-friendly

Disadvantages

Less standardized than SOAP
Security depends on HTTPS, OAuth, JWT, etc.

SOAP vs REST

SOAP	REST
Protocol	Architectural Style
XML only	JSON, XML, Text
Uses WSDL	Uses OpenAPI/Swagger (optional)
Slower	Faster
More Secure (WS-Security)	OAuth, JWT, HTTPS
Stateful & Stateless	Stateless
Heavy Payload	Lightweight

Example

SOAP Request

<soap:Envelope>
   <soap:Body>
      <GetEmployee>
         <EmpId>101</EmpId>
      </GetEmployee>
   </soap:Body>
</soap:Envelope>

REST Request

GET /employees/101

Response

{
 "empId":101,
 "name":"John"
}

What are the limitations of the FTP Adapter?

Answer

The FTP Adapter enables file transfer between OIC and FTP/SFTP servers. Although widely used, it has several limitations.

Limitations

1. Depends on FTP Server Availability

If the FTP server is unavailable, integrations fail.

2. Limited Real-Time Processing

FTP is file-based and not event-driven.

Example:
Customer uploads a file → OIC polls every 10 minutes.

3. Network Dependency

Performance depends on network bandwidth.

Large files may take several minutes.

4. No Built-in Business Logic

FTP Adapter only transfers files.

Business validation must be implemented separately.

5. File Locking Issues

If another process is using the file, OIC cannot read it.

6. Security Configuration Required

Need to configure
- SSH Keys
- Passwords
- Certificates
7. Polling Delay

FTP Adapter periodically polls the directory instead of receiving instant notifications.

8. Large File Processing

Very large files consume memory and increase execution time.

Best Practices
- Archive processed files.
- Enable PGP encryption for sensitive data.
- Use file naming conventions.
- Schedule transfers during off-peak hours.
- Configure retries for transient failures.
Can we install the OIC Connectivity Agent in High Availability (HA) mode?

Answer

Yes.

Oracle supports High Availability through Agent Groups.

Instead of installing a single agent, multiple Connectivity Agents are installed on different servers and registered under one Agent Group.

How HA Works
Oracle Integration Cloud | Agent Group ---------------------- | | Agent 1 Agent 2 | | Database Database
If Agent 1 fails,

↓

Agent 2 automatically handles the request.

Benefits
- Load Balancing
- Failover
- High Availability
- Better Performance
- No Single Point of Failure
Interview Tip

One Agent Group can contain multiple agents.
What are the prerequisites to install a Connectivity Agent?

Answer

Before installing the Connectivity Agent, ensure the following requirements are met.

Software Requirements
- Java JDK (Oracle-supported version)
- Supported Operating System
- OIC Instance
- Internet connectivity
Hardware Requirements
- Minimum 4 GB RAM
- Multi-core CPU recommended
- Sufficient disk space
Network Requirements

Allow outbound HTTPS (typically port 443) from the agent host to the OIC instance.

Security Requirements
- OIC credentials
- Agent registration key
- Firewall rules
- Proxy configuration (if applicable)
Installation Steps
1. Download Agent Installer
2. Install Java
3. Extract installer
4. Configure connectivity
5. Register Agent
6. Start Agent
7. Verify in OIC Console

What is the difference between OIC and SOACS?

Answer

OIC and SOACS are Oracle middleware solutions but differ in architecture and use cases.

OIC

Oracle Integration Cloud is Oracle’s modern Integration Platform as a Service (iPaaS).

Best suited for

SaaS Integration
Cloud Applications
Low-code Development
APIs
Event-driven Integrations

SOACS

SOA Cloud Service is based on Oracle SOA Suite.

Best suited for

Large Enterprise Applications
Complex BPEL Processes
Legacy System Integration
Long-running Transactions

Comparison

OIC	SOACS
Cloud Native	SOA Suite on Cloud
Low Code	Java/BPEL Development
Easy Deployment	Complex Deployment
Automatic Patching	Manual Administration
Visual Designer	Oracle JDeveloper
Minimal Infrastructure	Requires More Administration
Faster Development	More Flexible for Complex Workflows

Which should you choose?

OIC for cloud-first integrations and rapid development.
SOACS for highly customized enterprise workflows and advanced orchestration requirements.

Can OIC integrate with on-premise applications to Oracle Cloud?

Answer

Yes.

OIC can integrate securely with on-premises systems using the Connectivity Agent.

Supported Systems
- Oracle Database
- SQL Server
- SAP
- PeopleSoft
- JD Edwards
- FTP Servers
- Legacy Applications
- REST APIs
- SOAP Services
Architecture
Cloud Application | Oracle Integration Cloud | Connectivity Agent | On-Premise Database
Benefits
- Secure Communication
- No VPN Required (outbound connection initiated by the agent)
- Firewall Friendly
- SSL Encryption
- Easy Deployment
How do Compartment and Policies differ from each other?

Answer

These are Oracle Cloud Infrastructure (OCI) concepts.

Compartment

A Compartment is a logical container used to organize cloud resources.

Example
Company | HR Compartment Finance Compartment Development Compartment
Each compartment contains
- Compute
- Databases
- OIC Instances
- Storage
Policy

A Policy defines who can access what resources inside a compartment.

Example
Allow group Developers to manage integration-family in compartment Development
Differences

Compartment Policy

Resource Container Access Control

Organizes Resources Grants Permissions

Similar to Folder Similar to Security Rules

Created First Applied After

Real Example

Compartment
Finance
Policy
Allow group FinanceAdmins to manage integration-family in compartment Finance
What are the two types of integration licenses?

Answer

Oracle commonly provides two primary OIC licensing options.

1. Standard Edition

Suitable for small and medium businesses.

Includes
- Basic Integrations
- REST Adapter
- SOAP Adapter
- FTP Adapter
- Database Adapter
- Monitoring
- Connectivity Agent
2. Enterprise Edition

Suitable for enterprise organizations.

Includes everything in Standard plus:
- Process Automation
- B2B Integration
- File Server
- Advanced Adapters
- Visual Builder
- Enhanced Scalability
- Advanced Monitoring
Comparison

Standard Enterprise

Basic Integrations Advanced Integrations

Limited Features Full OIC Suite

Lower Cost Higher Cost

Note: Oracle’s licensing models can change over time. Always verify the latest licensing details with Oracle’s official documentation or sales team.
What is OAuth?

Answer

OAuth (Open Authorization) is an industry-standard authorization framework that allows applications to access resources on behalf of a user or another application without sharing passwords.

Example

Suppose an OIC integration needs to call a Salesforce REST API.

Instead of storing the user’s password, OIC requests an access token from Salesforce. OIC then includes that token in the API request. If the token expires, it can obtain a new one (depending on the grant type).

OAuth 2.0 Flow
User/Application | Authorization Server | Access Token | OIC | REST API
OAuth Grant Types
1. Authorization Code
2. Client Credentials
3. Refresh Token
4. Resource Owner Password Credentials (legacy; generally discouraged)
Why OAuth?
- More secure than sharing passwords.
- Tokens can expire and be revoked.
- Supports delegated access.
- Widely adopted by cloud applications and APIs.
What is ATP Database?

Answer

ATP (Autonomous Transaction Processing) is Oracle’s fully managed, cloud-based autonomous database service designed for high-performance transactional (OLTP) workloads.

Key Features
- Self-driving (automatic tuning)
- Self-securing (automatic security updates)
- Self-repairing (automatic failure recovery)
- Automatic backups
- Auto-scaling
- High Availability
- Built-in encryption
- Automatic patching
Use Cases
- Banking applications
- ERP systems
- E-commerce platforms
- Order management
- HR and payroll systems
- Financial transactions
ATP vs Autonomous Data Warehouse (ADW)

ATP ADW

Optimized for OLTP Optimized for Analytics

High-volume transactions Reporting and BI

Fast inserts/updates Fast analytical queries

ATP Benefits in OIC
- Easy integration using the Oracle ATP Database Adapter.
- Secure connectivity with SSL.
- Reduced database administration effort.
- High performance and automatic scalability for cloud-native integrations.
These expanded answers provide enough depth for interviews while remaining concise enough to explain confidently in a technical discussion.
How do you design error handling in OIC?

Answer

Error handling is one of the most important aspects of Oracle Integration Cloud (OIC). A well-designed error-handling strategy ensures integrations are reliable, maintainable, and capable of recovering from failures without losing data.

Types of Errors in OIC
1. Business Errors
  - Caused by invalid business data.
  - Example:
    - Customer ID does not exist.
    - Required field is missing.
    - Invalid purchase order.
2. System Errors
  - Caused by infrastructure or connectivity issues.
  - Example:
    - Network timeout.
    - FTP server unavailable.
    - ERP Cloud service unavailable.
    - Database connection failure.
Best Practices for Error Handling

1. Use Scope Activities

Wrap critical business logic inside a Scope activity.

Example:
Scope Read File Validate Data Call ERP API Update Database
Each scope can have its own fault handler.

2. Implement Scope Fault Handler

If any activity inside the scope fails,
- Catch the exception
- Log the error
- Send notification
- Retry if applicable
This prevents the entire integration from failing immediately.

3. Global Fault Handler

A Global Fault Handler catches any exception that is not handled by a Scope Fault Handler.

Example
Integration | Scope | Global Fault Handler
Used for
- Unexpected exceptions
- Runtime errors
- Connection failures
4. Log Complete Error Details

Always capture
- Integration Name
- Instance ID
- Error Code
- Error Message
- Request Payload
- Response Payload
- Timestamp
This helps support teams troubleshoot quickly.

5. Send Notifications

Notify administrators using
- Email
- REST API
- Oracle Integration notifications
Example
Subject ERP Integration Failed Body Order ID : 10541 Error : HTTP 500 Time : 10:45 AM
6. Retry Strategy

Retry only temporary failures.

Example
- HTTP 503
- Timeout
- Network issue
Do NOT retry
- Invalid Customer ID
- Invalid Payload
- Missing Mandatory Fields
7. Use Business Identifiers

Configure
- Order Number
- Customer ID
- Invoice Number
This makes searching failed instances much easier.
How do you improve the performance of an OIC integration?

Answer

Performance optimization focuses on reducing execution time, minimizing resource usage, and improving scalability.

1. Use Asynchronous Integrations

Instead of making users wait,

Trigger background processing.

Example
REST Request ↓ Queue ↓ Process Integration ↓ Return Response Later
2. Reduce Payload Size

Avoid sending unnecessary fields.

Instead of
Customer 200 fields
Send
CustomerID Name Email
Smaller payloads improve performance.

3. Avoid Multiple Database Calls

Bad
Loop ↓ SELECT ↓ SELECT ↓ SELECT
Good
Single Query ↓ Process Result
4. Cache Lookup Values

Instead of calling ERP repeatedly,

Store frequently used values in Lookup tables.

5. Use Parallel Processing

Independent tasks can run simultaneously.

Example
Create Customer Send Email Generate Report
instead of sequential execution.

6. Disable Payload Tracing in Production

Payload tracing consumes storage and impacts performance.

Enable only during troubleshooting.

7. Optimize Mapper

Avoid unnecessary
- Complex XPath
- Nested loops
- Repeated functions
8. Monitor Integrations

Use OIC Monitoring Dashboard to identify
- Slow integrations
- Failed instances
- High execution time
What is Scope and Global Fault Handling?

Answer

Oracle Integration Cloud provides two levels of fault handling.

Scope Fault Handler

Handles exceptions occurring within a specific Scope.

Example
Scope ↓ Read File ↓ Call ERP ↓ Fault Handler
If “Call ERP” fails,

Only this Scope handles the error.

Remaining integration may continue.

Global Fault Handler

Handles exceptions not captured anywhere else.

Example
Integration ↓ Global Fault Handler
It executes when
- No Scope catches the exception
- Unexpected runtime error occurs
Difference

Scope Fault Global Fault

Local error handling Entire integration

Scope specific Whole integration

Multiple scopes possible One per integration

Better control Final safety net
How do you secure REST APIs in OIC?

Answer

REST APIs must be protected to prevent unauthorized access.

Authentication Methods

Basic Authentication

Uses
Username Password
Encoded in Base64.

Suitable only over HTTPS.

OAuth 2.0

Most commonly used.

Flow
Client ↓ Authorization Server ↓ Access Token ↓ REST API
More secure than Basic Authentication.

JWT Authentication

Uses digitally signed JSON Web Tokens.

Benefits
- Stateless
- Secure
- Faster validation
API Keys

Client sends
X-API-Key
with every request.

SSL/TLS Certificates

Encrypts all communication.

Prevents
- Packet sniffing
- Data theft
- Man-in-the-middle attacks
Role-Based Access Control

Only authorized users can invoke integrations.

Additional Security Practices
- Enable HTTPS only.
- Validate all request payloads.
- Limit API rate if applicable.
- Store credentials securely using OIC Connections or CSF.
- Rotate certificates and tokens regularly.
Explain Synchronous vs Asynchronous Integration.

Answer

Synchronous Integration

The caller waits until processing is complete.

Example
Client ↓ OIC ↓ ERP ↓ Response ↓ Client
Characteristics
- Immediate response
- Suitable for real-time operations
- User waits for completion
Examples
- Customer Search
- Order Status
- Balance Inquiry
Asynchronous Integration

Caller submits the request and continues working.

Processing happens in the background.

Example
Client ↓ OIC ↓ Queue ↓ ERP ↓ Email Notification
Characteristics
- Better scalability
- Faster user experience
- Suitable for long-running processes
Examples
- Employee onboarding
- Invoice processing
- File imports
- Batch jobs
Comparison

Synchronous Asynchronous

Caller waits Caller doesn’t wait

Immediate response Background processing

Short-running tasks Long-running tasks

Simple APIs Large integrations
How do you migrate integrations between environments?

Answer

OIC supports migration between Development, Test, UAT, and Production.

Migration Process

Step 1

Create an Integration Package containing
- Integrations
- Lookups
- Libraries
- Mappings
Step 2

Export Package
Development ↓ Export Package (.par)
Step 3

Import into Target Environment
Test ↓ Import Package
Step 4

Reconfigure Connections

Update
- URLs
- Credentials
- Certificates
- OAuth details
Connection passwords are not exported for security reasons.

Step 5

Activate Integrations

After successful validation,

Activate all integrations.

Step 6

Perform Testing
- Smoke Test
- Integration Test
- End-to-End Test
- Performance Test
Best Practices
- Maintain separate DEV, TEST, UAT, and PROD environments.
- Use version control for integration artifacts.
- Validate all connections after import.
- Keep environment-specific values in Lookups or configuration tables.
- Perform rollback planning before production deployment.

Global Fault	Scope Fault
Entire Integration	Specific Scope
Handles all errors	Handles local errors

Save	Activate
Stores Draft	Makes Live
Cannot Run	Ready for Execution

Compartment	Policy
Resource Container	Access Control
Organizes Resources	Grants Permissions
Similar to Folder	Similar to Security Rules
Created First	Applied After

Standard	Enterprise
Basic Integrations	Advanced Integrations
Limited Features	Full OIC Suite
Lower Cost	Higher Cost

Oracle Integration Cloud (OIC) Interview Questions

Oracle Integration Cloud (OIC) Interview Questions

Oracle Integration Cloud (OIC) Interview Questions and Answers

What is Oracle Integration Cloud (OIC)?

What are the components of OIC?

What is Integration in Oracle Integration Cloud?

What is a File Transfer Pattern?

What are the different integration patterns in OIC?

What is App Driven Orchestration?

What is Scheduled Orchestration?

What is Connectivity Agent?

What are Adapters in OIC?

Difference between REST and SOAP Adapter?

What is a Lookup in OIC?

What is Mapping in OIC?

What are Assign Activities?

What is Switch Activity?

What is Scope Activity?

What is Fault Handling?

What is a Basic Routing Pattern?

Difference between Global Fault and Scope Fault?

What is Publish to OIC and Subscribe to OIC Pattern?

Publish to OIC

Subscribe to OIC

What is Stage File Action?

What is File Server in OIC?

What is Tracking Variable?

What is Business Identifier?

What are Connections in OIC?

What are the authentication methods supported in OIC?

What is an Integration Package?

What is the difference between Activate and Save?

How do you deploy integrations between environments?

How do you monitor integrations?

How do you call one integration from another?

How do you process a large CSV file?

What happens if an ERP service is unavailable?

How do you secure REST APIs in OIC?

What are the deployment environments in OIC?

What is Payload Tracing?

What is the CSF Key?

How do you improve OIC performance?

What do you understand by Utility Computing?

What is an Orchestrated Integration?

What is the timeout limit of the Connectivity Agent?

What is the payload limit of the Connectivity Agent?

What is the difference between the FTP Adapter and the File Adapter?

What are the retention period and default retention period of a database in OIC?

What is a Feature Flag in OIC, and what is its lifecycle?

Can we store data in OIC?

How do you handle exceptions in Oracle Integration Cloud?

How many types of certificates can be imported from the Settings menu?

Explain a real-time OIC integration example.

What is the difference between ICS and OIC?

Explain an end-to-end OIC project you have worked on.

What is the distinction between SOAP and REST API?

What are the limitations of the FTP Adapter?

1. Depends on FTP Server Availability

2. Limited Real-Time Processing

3. Network Dependency

4. No Built-in Business Logic

5. File Locking Issues

6. Security Configuration Required

7. Polling Delay

8. Large File Processing

Best Practices

Can we install the OIC Connectivity Agent in High Availability (HA) mode?

How HA Works

Benefits

Interview Tip

What are the prerequisites to install a Connectivity Agent?

Software Requirements

Hardware Requirements

Network Requirements

Security Requirements

Installation Steps

What is the difference between OIC and SOACS?

OIC

SOACS

Comparison