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?

18. How to do monitoring in OIC?

19. How will you implement multiple operation based calculator service in OIC? How will you implement calculator service in OIC?

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. Have you used enrichment service in OIC?

21. What are the OIC integrations you have implemented in your project?

22. How to embed barcode or image in import to erp? How to embed image or barcode in email?

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.

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?

32. Suppose you are invoking a BIP report and received null or empty file how to handle this so that it should not flow to Downstream applications?

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?

35. Can we call BIP report from database?

36. What is your current role in the project?

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

38. Apex reports, Can we use plsql in apex?

39. We have a requitement to digitally sign the email while sending the email notification from OIC. Is there any way we can embed an image in the email notification in OIC?

40. 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));

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

42. How to fetch incremental or delta or daily data using BI report?

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

44. how you will write BIP extension report?

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

Answer: Unlimited.

46. Max number of instances of an integration can be run in parallel?

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

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

48. While we call HCM extract flow, whih fields we are passing ?

Answer:

Extract name or flow name
Integration name
Parameters like effective date
Legislative data group

49. What are the different xslt functions you have worked on OIC?

50. How to generate Sequence number and insert to a database table without using Db sequnce?

51. What are the different fault handling actions avaiable in OIC? And their functions?

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

53. Suppose you have a requirement to approve or disapprove some budget from a VBCS page how you will achieve this?

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

55. Suppose we have 2 duplicate in web portal, from OIC, you need to call the service and check duplicacy. How do you do it?

56. How you will connect hybrid model from OIC?

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

Answer: 2 MB

58. How to recover a failed intances in oic?

59. How you handle complex mapping in oic?

soalicious

Tuesday, August 23, 2022

OIC Interview question and Answers | Oracle Integration Cloud

No comments:

Post a Comment

Featured Post

11g to 12c OSB projects migration points

Search This Blog