Saturday, March 8, 2025

OIC interview questions

🚀 Oracle Integration Cloud (OIC) Gen3 – Interview Q&A & Real-Time Insights

📅 Updated: July 26, 2025
✍️ By: Aks]

Oracle Integration Cloud (OIC) Gen3 is the latest evolution in Oracle’s cloud integration suite, bringing faster runtimes, enhanced observability, and a simplified development experience.

This blog addresses some frequently asked interview questions and real-time use case clarifications for professionals working with OIC Gen3.

🔁 1. What is the Difference Between FTP Adapter and File Adapter?

Feature	FTP Adapter	File Adapter
Use Case	Connects to FTP/SFTP servers	Accesses on-premise file systems
Deployment	Cloud-native	Requires OIC Connectivity Agent
Polling Support	✅ Yes	✅ Yes (via agent)
Transfer Type	Remote files over network	Local or network-shared files
Common Scenario	Download/upload files from a bank FTP	Reading data files from an on-premise legacy system

📦 2. What is FBDI Integration?

FBDI (File-Based Data Import) is Oracle Fusion’s standard method to load bulk data via interface tables using CSV/XML templates.

🔧 Typical FBDI Integration Steps:

Generate CSV file based on FBDI template (e.g., Suppliers, Journals).
Upload file to UCM (via ERP Cloud Adapter).
Invoke ERP Import job (e.g., Import Payables Invoices).
Monitor status and fetch results using callback or polling.

🧠 Tip: Always validate CSV structure and lookup codes before upload.

🔗 3. What Connections Are Required for FBDI Integration?

Connection	Purpose
ERP Cloud Adapter	Upload to UCM and run import jobs
FTP Adapter (Optional)	Retrieve CSV file from a remote location
SOAP Adapter	Callback/monitor import job status (if needed)
Email Adapter	Send notifications post import

📂 4. Does FTP Adapter Support Polling?

✅ Yes!

The FTP Adapter in OIC Gen3 supports file polling. You can configure:

Directory path
Polling frequency
File patterns (e.g., *.csv)
Archival/move after processing

👉 Use Cases: Fetching daily reports, invoices, or orders dropped by external systems.

🧮 5. How to Calculate the Top 2nd Salary (SQL)?

SELECT MAX(salary) AS second_highest_salary
FROM employees
WHERE salary < (
  SELECT MAX(salary) FROM employees
);

🔎 This query works by excluding the highest salary and fetching the next max value.

🔄 6. What is the Difference Between Synchronous and Asynchronous Integration?

Feature	Synchronous	Asynchronous
Client Waits?	✅ Yes	❌ No
Response Time	Immediate	Background / Delayed
Use Case	Real-time APIs	Bulk processing, FBDI, callbacks
Example	Get Employee Info by ID	Upload journal file, run job, send callback

🔃 7. Can We Convert Scheduled Integration to App-Driven?

🚫 No, this is not supported directly.

Scheduled integrations are time-triggered and don’t accept external requests.
You can recreate the flow logic in a new App-Driven integration.

🔧 Workaround: Copy artifacts and logic manually between integrations.

🔁 8. Can We Convert App-Driven to Scheduled Integration?

🚫 No, direct conversion is not supported.

App-driven integrations are designed to be invoked by APIs or events.
Scheduled integrations work on time-based triggers.

🛠 You must build a new scheduled integration with similar flow logic.

✨ Bonus Tip: Best Practices for OIC Gen3

Use global fault handlers for robust error management.
Group related integrations using lookup tables and packages.
Schedule data purging for long-running integrations to keep performance optimal.

📌 Conclusion

OIC Gen3 offers robust capabilities for hybrid integrations, event-driven orchestration, and bulk data handling via FBDI. Understanding how adapters differ, how to design for sync/async patterns, and when to use scheduled vs app-driven flows is key for both developers and architects.

🔎 Whether you're preparing for an interview or implementing real-time use cases, mastering these patterns will give you a solid edge in working with Oracle Cloud integrations.

Know Oracle Fusion Apps