Tuesday, August 23, 2022

OIC Interview question and Answers | Oracle Integration Cloud

OIC interview Q & A:

We have divided the interview questions into 3 sections: Non- Technical, Technical shorts and Scenario based questions.

A. Non - Technical:

Here’s a concise list of the non-technical questions for OIC interviews:

  1. Can you briefly introduce yourself, including your overall experience and your relevant experience in OIC?
  2. What is your current role and what are your key responsibilities in the current project, especially related to OIC? Answer: In my current role as a Technical Lead and OIC Developer, I lead a team of five members, managing end-to-end integration projects. My responsibilities include client-facing communication, gathering and analyzing requirements, designing scalable solutions, and overseeing development and delivery using Oracle Integration Cloud (OIC). I ensure smooth coordination between the team and stakeholders, mentor team members, and resolve technical challenges to deliver high-quality results.
  3. Can you explain how you collaborate with other teams or stakeholders in your current project?
  4. How do you handle challenges or issues in integrations that arise during your work?
  5. How do you ensure your integrations meet business requirements and are user-friendly?
  6. How do you prioritize tasks and manage deadlines when working with multiple integrations?
  7. How do you keep yourself updated with the latest features or changes in OIC?
  8. How do you handle client communications or presentations, especially when explaining complex technical topics in simple terms?
  9. What has been your biggest challenge in working with OIC so far, and how did you overcome it?
  10. How do you ensure quality and performance in your integration solutions?
B. Technical shorts

  1. Can you explain the different types of integrations patterns or styles available in OIC (App Driven, Scheduled, REST, SOAP, File-based, etc.)? - https://soalicious.blogspot.com/2019/11/oracle-cloud-integrationoic-introduction.html
  2. Which OIC adapters you have worked on? - Answer: FTP, file, DB, ATP, Rest, SOAP, ERP, HCM etc.
  3. What is the difference between synchronous and asynchronous integrations in OIC? https://soalicious.blogspot.com/2025/06/oic-what-is-difference-between.html
  4. How do you monitor and troubleshoot integrations in OIC? - https://soalicious.blogspot.com/2025/06/oic-monitoring-and-troubleshooting.html
  5. What is the connectivity agent in OIC and why is it important? How to cofigure connectivity agent and its usage limitations - 
    1. https://soalicious.blogspot.com/2020/10/oic-connectivity-agent.html
    2.  https://soalicious.blogspot.com/2020/11/oic-connectivity-agent-part-2.html 
    3.  https://soalicious.blogspot.com/2022/05/oic-install-connectivity-agent-in.html 
  6. How do you deploy or migrate integrations between environments (Dev, Test, Prod) in OIC? - https://soalicious.blogspot.com/2022/02/oic-migration-of-integration-from-one.html
  7. How do you manage versions of integrations in OIC? - https://soalicious.blogspot.com/2024/12/oic-versioning-in-oracle-integration.html
  8. What is lookups in OIC and how do you use them? - Use of Lookup | Create a Lookup and use in an Oracle Cloud Integrations
  9. What is the difference between gen2 & gen3 OIC? https://soalicious.blogspot.com/2022/03/oic-gen-1-vs-gen-2-benefits-of-oic.html
  10. What are the new features available in gen 3 25.04 version. -https://soalicious.blogspot.com/2025/06/oic-gen3-new-features-2504-version.html
  11. How will you schedule an integration ,what is ICAL expression .
  12. OIC FTP vs OIC File adapter - https://soalicious.blogspot.com/2021/05/oic-file-adapter-vs-ftp-adapter.html
  13. How do you handle bulk data integrations (e.g., with FBDI or HDL)?
  14. What are the different xslt functions you have worked? Have you created any custom javascript functions in OIC? - https://soalicious.blogspot.com/2024/12/oic-commonly-used-xslt-functions-in.html
  15. How do you handle fault handling and error management in OIC integrations? - https://soalicious.blogspot.com/2021/12/oic-ootb-error-handling-in-easy-steps.html

  16.  suppose we have 4 fbdi integrations for different business objects can we have one call back integration for all these fbdi if yes how ? can you explain - https://soalicious.blogspot.com/2025/06/oic-designing-reusable-callback.html?m=1 

  17. Can you describe how you implemented OIC integrations with Oracle ERP Cloud / HCM Cloud?
  18. How do you handle pagination when working with REST APIs in OIC?
  19. Can you explain how you use REST and SOAP connections in OIC? - https://soalicious.blogspot.com/2025/06/oic-can-you-explain-how-you-use-rest.html
  20. what are the differences between SOAP vs REST? - https://soalicious.blogspot.com/2025/01/oic-difference-between-soap-and-rest.html
  21. Can we send soap xml using REST adapter? https://soalicious.blogspot.com/2025/01/oic-can-we-send-xml-input-in-rest.html
  22. How do you secure integrations in OIC (authentication, certificates, etc.)?
  23. What is the different type of authentication ,how will you configure OAuth 
  24. FBDI related question:
    1. FBDI approach with an example - https://soalicious.blogspot.com/2022/02/oic-erp-supplier-bulk-import-and.html
    2. ERP events callback or subscription. - https://soalicious.blogspot.com/2023/03/erp-register-csf-key.html?m=1
    3. How will you generate properties file in FBDI based integration.
    4. How will you design the callback integration.
    5. Rest api vs Erp cloud adapter in terms of FBDI import. https://soalicious.blogspot.com/2024/12/oic-using-rest-api-vs-erp-cloud-adapter.html
    6. FAH vs GL when to use for import?https://soalicious.blogspot.com/2023/12/oic-when-to-use-fah-vs-gl-import.html
    7. BIP report huge size, How to handle this situation?Answer: Using BI bursting
    8. Handling Null or Empty BIP Report Files in Oracle Integration Cloud to Prevent Flow to Downstream Applications - https://soalicious.blogspot.com/2024/12/oic-handling-null-or-empty-bip-report.html
    9. Can we call BIP report from database?
    10. How to handle in Integration when report has huge amount of data or How to handle when BIP report going into error due to huge data?
    11. how to submit ESS Job in Integration
    12. Bursting the BIP Report (FTP and Email)
  25. How to configure ATP db connection in oic 
  26. How will you call external rest API from OIC.
  27. How to configure Schedule parameter parameters? What is the use of these parameter.
  28. What is the use of integration properties?
  29. BI report related questions:
    1. How to call BI report from OIC.
    2. BIP vs OTBI report https://soalicious.blogspot.com/2024/05/erp-hcm-bip-vs-otbi.html
  30. How will you enable business event .
  31. How will you design real time integration in oic ,ex event base integration .
  32. How to handle large file in OIC - https://soalicious.blogspot.com/2021/05/oic-how-to-handle-more-than-10-mb-file.html
  33. What issues you observed in OIC ERP.- https://soalicious.blogspot.com/2021/03/oic-synchronous-integrations.html
  34. Can file adapter and ftp adapter support high availability mode using connectivity agent - https://soalicious.blogspot.com/2023/07/oic-can-file-server-and-ftp-server.html
  35. Maximum duration for integration flows | time out time for OIC services | Service limit for Scheduled orchestration or Async or Sync service - https://soalicious.blogspot.com/2023/06/oic-maximum-duration-for-integration.html
  36. Why to avoid creating too many scheduled integrations - https://soalicious.blogspot.com/2021/07/oic-why-to-avoid-creating-too-many.html
  37. How many different scheduled integrations can run in parallel in Oracle Integration | Decoupled scheduler and Business Logic pattern. - https://soalicious.blogspot.com/2023/09/oic.html
  38. Does OIC Support Asynchronous request response service? - It is permissible to call asynchronous fire and forget(one way). Oracle integrations presently does not support modelling an asynchronous request response service. However, all scheduled orchestration patterns implement an asynchronous request response internally, As a result, asyn integration through scheduled orchestration is an anti pattern
  39. Why we should use OIC instead SOACS?- https://soalicious.blogspot.com/2024/05/oic-why-should-we-choose-oic-over-soacs.html
  40. How to resubmit failed instances in OIC https://soalicious.blogspot.com/2024/12/oic-resubmit-failed-messages.html
  41. How will you implement multiple operation based calculator service in OIC? How will you implement calculator service in OIC?Answer:For Soap:https://soalicious.blogspot.com/2022/03/oic-managing-multiple-operations-in-oic.html For rest with multiple verbs:https://soalicious.blogspot.com/2022/11/oic-use-rest-adapter-with-multiple.html
  42. About enrichment service in OIC? Have you used any of the enrichment services - https://soalicious.blogspot.com/2024/12/oic-enrichment-service-in-oracle.html
  43. What are the OIC integrations you have implemented in your project?Concise gist:"In my project, I have implemented several integrations using Oracle Integration Cloud (OIC). These include FBDI (File-Based Data Import) integrations for loading data into Oracle ERP Cloud, HCM Extract and HDL (HCM Data Loader) integrations for handling employee data between Oracle HCM Cloud and external systems, and real-time REST API loads for seamless data exchange between applications. Additionally, I have worked on integrating Utility Cloud Services to manage energy consumption data and automate reporting between our cloud and third-party systems."
  44. How to embed image or barcode in email?https://soalicious.blogspot.com/2024/07/oic-how-to-embed-image-in-email-body.html?m=1#google_vignette

  45. Can we read excel file in OIC? If no, how we can achieve it?Answer:  OIC does not support excel read. If we really need to read it then follow the below steps: Create a serverless OCI function with python/Java logic to convert excel to csv >> create a bucket in oci object storage >> create a rest connection to put excel file from oic to Object storage >> do another call to function to convert and save to OS >> do another OS call to get the converted CSV file and use.
  46. How to change the email notification from part - https://soalicious.blogspot.com/2023/06/oic-how-to-change-from-address-for.html
  47. What are the diffrent stage action functions?Answers:  we can do the following:Read entire file, Read file in segments, write file, zip files, Unzip file, Encrypt file, decrypt file, List files
  48. There are large number of schedule orchestrated integrations run at the same time. What to do to avoid backlogging?https://soalicious.blogspot.com/2024/06/oic-there-are-huge-number-of-scheduled.html
  49. Have you used PLSQL in xslt or in complex logic processing?https://soalicious.blogspot.com/2024/12/oic-can-we-usecall-plsql-in-oic-xslt.html
  50. Suppose we are getting data from ERP and then storing them in a database table. How to avoid the duplicate data to be stored in the database?https://soalicious.blogspot.com/2024/12/oic-how-to-avoid-storing-duplicate-data.html
  51. How to get the 2nd or 3rd max salary from an employee table using sql query?Answer:https://soalicious.blogspot.com/2025/06/sql-how-to-get-2nd-or-3rd-max-salary.html
  52. Can we convert App driven orchestration to Scheduled orchestration integration?Answer: directly there is no provision to convert from App driven to Scheduled integrations. But we can convert from scheduled to app driven integrations. As a workaround , we can create a separate scheduled orchestration integration and can call then the app driven the integration from the scheduled one.
  53. We need to execute a schedule job in oic that will run only on weekdays excluding public holidays?Answerhttps://soalicious.blogspot.com/2024/09/oic-we-need-to-execute-schedule-job-in.html
  54. Max number of scopes can be created in an integration? Answer: Unlimited.
  55. What is the maximum number of instances of an integration that can run in parallel in OIC for application and scheduled integrations?Answer: In OIC, application integrations support up to 100 synchronous and 50 asynchronous concurrent executions by default. For scheduled integrations, only one instance runs at a time, but a decoupled approach (using a parent scheduled integration to invoke multiple child integrations) enables concurrent execution effectively.
  56. Can we use data from one scope to another scope ? If yes, how?Answer: yes, using global variable and data stitch action
  57. While we call HCM extract flow, which fields we are passing ?Answer: Extract name or flow name, Integration name, Parameters like effective date, Legislative data group
  58. What are the different fault handling actions avaiable in OIC? And their functions?Throw new fault, rethrow fault & fault return https://soalicious.blogspot.com/2021/08/oic-ways-of-throwing-faults.html?m=1
  59. Suppose you are calling an API for invoice bulk import, how you will track any failure for each invoices?
  60. What are different OCI storage types available and their fucntions?Object storage , Block volume, File storage
  61. What is max size notification action - attachment support?Answer: 2 MB
  62. Explain one end to end integration you have developed and what issues you have faced during the development and how did you tackle the issues.
  63. In OiC, is it possibe to trigger parallel flow?Yes, in Oracle Integration Cloud (OIC), you can trigger parallel flows using the "Parallel" action available in orchestrations.
  64. How to debug the integration issues in OIC?
  65. Explain one complex integration which you have worked on
  66. Benefits of using stage read file in segment and max size it supports?
  67. Can we configure two callbacks in single trigger? If yes, how? What is the impact?
  68. Security mechanism used in rest adapter?
  69. How to embed barcode or image in import to erp? 
  70. how will you achieve message level encryprion and file level encryption in OIC?

C. Scenario based questions:

  1. How can we manage sequence numbers without having direct access to the database? https://soalicious.blogspot.com/2024/12/oic-managing-sequence-numbers-in-oic.html
  2. In an SCM-to-SAP integration scenario, how can we design a process to call a BIP report, retrieve the inventory file, and send it to SAP?https://soalicious.blogspot.com/2024/12/oic-seamless-integration-scm-to-sap.html
  3. If a file contains two types of records (stub and payment), how can we efficiently process it by fetching payment details for each stub record and creating detailed records for the target system?https://soalicious.blogspot.com/2024/12/oic-xslt-dynamic-xpath-mapping-in.html
  4. What is the difference between creating integrations in projects versus packages in OIC?https://soalicious.blogspot.com/2024/09/oic-gen3-working-with-projects-packages.html
  5. How can we design a robust error-handling mechanism in an integration flow, considering a SaaS application is available to store failure details and create tickets?
  6. What is the best approach to validate input fields, whether they are received from a REST API or a file?https://soalicious.blogspot.com/2024/11/oic-input-validation-ensuring-mandatory.html
  7. What are the different ways to access object storage from OIC? Answer: 2 ways. 1. Creating a object storage rest connection and use object sorage api to put the file. 2. Use gen 3 provided Object storage action.
  8. What is the purpose of the fault data type variable in OIC?https://soalicious.blogspot.com/2024/10/oic-use-of-fault-datatype-variable.html
  9. When performing an HDL import, how can we retrieve the import status and error details if the process fails, and share them with support or the business team https://soalicious.blogspot.com/2024/09/oic-hcm-how-to-check-or-export-report.html
  10. How can data be extracted from HCM and sent to a target application?
  11. If FTP does not support polling as a trigger, what alternative solutions can be used to achieve FTP polling?
  12. How can we share a database adapter's response from one scope to another scope within an integration? Answer: using global variable and data stitch
  13. How can we send a custom fault response to the caller of an OIC API service in case of a failure?
  14. If a BIP report generates a large file, what design strategies can be used to overcome OIC's size limitations?
  15. For FBDI processing, is it better to use the ERP adapter or REST service API?
  16. Is it possible to expose multiple operations within a single SOAP integration in OIC
  17. How to fetch incremental or delta or daily data using BI report?
  18. How can we process large files (greater than 100 MB) in OIC? 
  19. Why should we avoid creating too many scheduled integrations in OIC?
  20. How can we execute a scheduled job in OIC that runs only on weekdays, excluding public holidays? https://soalicious.blogspot.com/2024/09/oic-we-need-to-execute-schedule-job-in.html
  21. What are the solutions to overcome the 10 MB limit of the DB adapter when calling a database procedure in OIC? https://soalicious.blogspot.com/2022/04/oic-db-procedure-call-db-adapter-10-mb.html
  22. How can we call a database procedure asynchronously in OIC? https://soalicious.blogspot.com/2022/12/oic-how-to-call-db-procedure.html
  23. How can we implement retry logic to handle timeouts when uploading files to an AWS S3 bucket?
  24. How can XML data be converted to JSON in OIC?
  25. How you handle complex mapping in oic?
  26. How to recover a failed intances in oic?
  27. Can you describe a complex integration scenario you worked on in OIC?
  28. How do you implement file-based integrations in OIC?
  29. How will you handle error in oic integration .If you are processing multiple records how will you ensure all the record being process even a single record is error out.Answer: https://soalicious.blogspot.com/2025/05/oic-how-will-you-handle-error-in-oic.html
  30. How come you overcome the timeout scenario when you are invoking store procedure from OIC integration .
  31. How will you convert a string to a json array .
  32. We have a Project requirement that we have to schedule a service to load data and also need to do a real time data feed as needed. How you will implement this?Answer: first create an app driven integration and expose as rest / soap so that client can send data in real time. Second, create a schedule integration to call that app driven integration to run in a scheduled time manner.




No comments:

Post a Comment

Featured Post

OIC - Sending JSON Data as Email Body Content via Twilio SendGrid API in OIC

Use Case Description: When integrating Oracle Integration Cloud (OIC) with Twilio SendGrid API to send emails, JSON data intended for the em...