soalicious: OIC Interview question and Answers

- 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

16. Why we should use OIC instead SOACS?

https://soalicious.blogspot.com/2024/05/oic-why-should-we-choose-oic-over-soacs.html

17. Version controlling in OIC?

https://soalicious.blogspot.com/2024/12/oic-versioning-in-oracle-integration.html

18. How to resubmit failed instances in OIC?

https://soalicious.blogspot.com/2024/12/oic-resubmit-failed-messages.html

19. 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

20. 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

21. 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."

22. 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

23. 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.

24. 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

25. Which OIC adaptets you have worked on?

Answer: Ftp, file, DB, ATP, Rest, SOAP, ERP, HCM

26. BIP vs OTBI report

https://soalicious.blogspot.com/2024/05/erp-hcm-bip-vs-otbi.html

27. FAH vs GL when to use for import?

https://soalicious.blogspot.com/2023/12/oic-when-to-use-fah-vs-gl-import.html

28. 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.

29. How to change the email notification from part?

https://soalicious.blogspot.com/2023/06/oic-how-to-change-from-address-for.html

30. 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

31. BIP report huge size, How to handle this situation?

Answer: Using BI bursting

32. 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

33. 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

34. 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

35. What is your role and responsibilities in your current project?

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.

36. 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

37. How to get the 2nd or 3rd max salary from an employee table using sql query?

Answer:

Using limit and offset

2nd Maximum Salary

SELECT salary

FROM employee

ORDER BY salary DESC

LIMIT 1 OFFSET 1;

3rd Maximum Salary

SELECT salary

FROM employee

ORDER BY salary DESC

LIMIT 1 OFFSET 2;

Method 1: Using Subqueries

2nd Maximum Salary

SELECT MAX(salary) AS SecondHighestSalary

FROM employee

WHERE salary < (SELECT MAX(salary) FROM employee);

3rd Maximum Salary

SELECT MAX(salary) AS ThirdHighestSalary

FROM employee

WHERE salary < (SELECT MAX(salary)

FROM employee

WHERE salary < (SELECT MAX(salary) FROM employee));

38. 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.

39. We need to execute a schedule job in oic that will run only on weekdays excluding public holidays?

Answer

https://soalicious.blogspot.com/2024/09/oic-we-need-to-execute-schedule-job-in.html

40. Max number of scopes can be created in an integration?

Answer: Unlimited.

41. 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.

42. Can we use data from one scope to another scope ? If yes, how?

Answer: yes, using global variable and data stitch action.

43. 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

44. Commonly Used XSLT Functions in Oracle Integration Cloud (OIC)

https://soalicious.blogspot.com/2024/12/oic-commonly-used-xslt-functions-in.html

45. 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

46. Suppose you are calling an API for invoice bulk import, how you will track any failure for each invoices?

47. What are different OCI storage types available and their fucntions?

- Object storage

- Block volume

- File storage

48. What is max size notification action - attachment support?

Answer: 2 MB

49. 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.

50. What is the difference between sync and async integrations?

Answer:

Synchronous (Sync) integrations wait for an immediate response and are blocking, while Asynchronous (Async) integrations don't wait for a response and are non-blocking, allowing background processing. Sync is used for real-time tasks, and async is used for tasks where immediate response isn't required.

51. Can we send xml input in Rest adapter?

https://soalicious.blogspot.com/2025/01/oic-can-we-send-xml-input-in-rest.html

52. 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.

53. 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?

54. Callback usage

55. Difference between GEN2 and GEN3

56. how to submit ESS Job in Integration

57. Bursting the BIP Report (FTP and Email)

58. Difference between SOAP and REST

https://soalicious.blogspot.com/2025/01/oic-difference-between-soap-and-rest.html

59. How to debug the integration issues in OIC?

60. Explain one complex integration which you have worked on

61. Benefits of using stage read file in segment and max size it supports?

62.when do we need agent installation

63. Can we configure two callbacks in single trigger? If yes, how? What is the impact?

64. Security mechanism used in rest adapter?

65. How to configure or setup Oauth?

66. How to embed barcode or image in import to erp?

67. Can we call BIP report from database?

Scenario based questions:

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
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
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
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
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?
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
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.
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
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
How can data be extracted from HCM and sent to a target application?
If FTP does not support polling as a trigger, what alternative solutions can be used to achieve FTP polling?
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
How can we send a custom fault response to the caller of an OIC API service in case of a failure?
If a BIP report generates a large file, what design strategies can be used to overcome OIC's size limitations?
For FBDI processing, is it better to use the ERP adapter or REST service API?
Is it possible to expose multiple operations within a single SOAP integration in OIC
How to fetch incremental or delta or daily data using BI report?
How can we process large files (greater than 100 MB) in OIC?
Why should we avoid creating too many scheduled integrations in OIC?
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
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
How can we call a database procedure asynchronously in OIC? https://soalicious.blogspot.com/2022/12/oic-how-to-call-db-procedure.html
How can we read data from an Excel file in OIC?
How can we implement retry logic to handle timeouts when uploading files to an AWS S3 bucket?
How can XML data be converted to JSON in OIC?
How you handle complex mapping in oic?
How to recover a failed intances in oic?

soalicious

Tuesday, August 23, 2022

OIC Interview question and Answers | Oracle Integration Cloud

No comments:

Post a Comment

Featured Post

OIC - how can I use XSLT functions to remove leading zeros from numeric and alphanumeric fields?

Search This Blog