Fusion technical with OIC Interview Questions

 Fusion technical with OIC Interview Questions 

Namratha's Interview on 11/08/2026 for the company :LTIMINDTREE -L1 (20 MIN)

--------------------------------------------------------------

OIC INTERVIEW QUESTIONS

1. Tell me about an integration you built.

2. How many integrations did you build and support?

3. Rate yourself in OIC from 1–5.

4. What is a real-time integration?

5. Synchronous vs asynchronous integration?

6. What is the timeout/duration of synchronous & asynchronous integration?

7. What is Connectivity Agent?

8. What are Connectivity Agent/agent group concepts?

9. What is Data Stitch and what actions can we perform?

10.What is ACTIVITY STREAM?

11.An encrypted file is placed on an SFTP server. The file is generated from an HCM Extract. How will you build the integration?

12.difference between authorisations and authentication.

Sadana's Interview on 10/08/2026 for the company : Infosys L1  

-------------------------------------------------------------

1.What are the different connections used for outbound integrations extract data from Fusion?

2.When do you use BIP and when do you use BICC?

3.What are the advantages of using BICC over BIP?

4.Have you used event-based integration? What scenario?

5.How do you set up a business event?

6.How do you design retry for a business-event integration?

7.How have you used OIC functions?

8.What is the difference between a package and a project in OIC?

9.Have you worked with CI/CD?

10.During requirement gathering, what all questions do you ask?

11.what are the clients and project recent company you worked

Devi's Interview on 10/08/2026 for the company :KPMG 4pm L1

------------------------------------------------------------

1. NVL AND NVL2 WHICH SCENARIO WE USE THESE?

2. WHAT IS DIFF B/W VIEW AND INLINE VIEW?

3. 500- 700 LINES WE HAVE A SQL QUERY HOW DO YOU IDENTIFY AND DEBUG THE QUERY AND HOW DO YOU RECTIFY PERFORMANCE ISSUE WHAT IS THE APPORACH YOU USE?

4. FOR EX: TABLE EMP THERE ARE CLOUMNS EMPID, DESIGNATION, DOB DISPLAY THE AGE OF THE EMPLOYEE WHAT IS THE QUERY FOR IT?

5. WHAT IS TRIGGERS WHEN DO WE USE IN PL/SQL

6. HOW MANY TYPES OF TRIGGERS IN PL/SQL

7. IN PL/SQL WE HAVE REF CURSOR WHEN DO WE USE THAT

8. WHAT IS STRONG AND WEAK REF CURSOR

9. WHAT IS IMPLICIT AND EXPLICIT CURSOR

10. CAN WE CALL A PROCEDURE IN A FUNCTION AND HOW DO YOU CALL ANY SYNTAX?

11. WHAT TYPE OF DATA MIGRATION DOMNE IN OIC INTEGRATIONS

12. AP INVOICE OBJECT AND WHAT IS THE PROCESS FOR DATA MIGRATION IN OIC TO FUSION?

13. FILE FROM CLIENT WIH 2,000 RECORDS THE DATA IS IN INTERFACE TABLE YOU RUN ESS JOB THEN THE DATA GOT STUCK AND WHAT IS THE PPROACH YOU USE FOR REPROCESS THE JOB TO GET SUCCESS

14. ARE YOU RUNNING ONLY FOR 200 RECORDS OR FOR AN ENTIRE FILE

15. HOW DO YOU HANDLE THIS PROCESS IN OIC

16. YOU SAID YOU CREATE A PROPERTY FILE HOW DO YOU RUN 3 BU IN PROPERTY FILE

17. CAN'T WE PASS ALL 3 PARAMETERS AT INCE

18. IN THE PROCESS OF CREATING AN OIC SOME ISSUE CAME HOW DO YOU HANDLE THAT LIKE FOR SCHEDULE INTEGRATION

19. I HAVE AP INVOICE YOU FETCH THE DATA DURING THE PROCESS THE VALIDATION FAILED AND HOW DO YU CAPTURE THE FAILED VALIDATIONS?

20. WHY YOU USE FTP AND FILE ADAPTER?

21. REQ:

I RECEIVED A FILE JOURNAL THAT CONTAINS 1 GB DATA DEVELOP AN INTEGRATION AND HOW DO YOU HANDLE TO PROCESS TO FUSION

22. IN GEN3 WHAT IS THE MAX FILE SIZE FOR .CSV? IF IT IS MORE THAN 1GB ONE AP INVOICE RECEIVING FROM CLIENT THEY KEPT THAT IN FTP WHAT IS THE PROCESS TO ADD THIS FILE IN FTP

23. HAVE YOU WORKED IN BIP REPORTS WHAT KIN OF TEMPLATES YOU WORKED

24. WHY WE USE E-TEXT TEMPLATES

25. WHAT IS MEAN BY BURSTING WHEN WE USE THAT

26. WE HAVE SCHEDULE THEN WHY WE USE BURSTING

27. IN BURSTING TO SEND FILE TO USERS AND FTP WHAT IS THE APPORACH

Samba's Interview on 11/08/2026 for the company :KPMG 4pm L1  --Cleared planned L2 on 12/08/2026 2:30 PM 

--------------------------------------------------------------------------------------------------------

select * from emp where rownum>10

select * from emp where 1=2

1.Introduction

2.oic,conversions,BIP  -- which are your expertise areas ?

3.if yu are calling plsql procedure in OIC and it is running more than 4 min .?what is the integration status ? how will you overcome with this ?

 

4.ppm  -- Have got chance to work on Costing and inv ? PPM ? 

5.diff package and project in OIC ? 

  if Modified any one integration in either package or project  . 

    with respect to deployment -- how will you deploy to higher instance ?

6.diff between audit,prod,DEBUG --what is the significance of Integrations activattion modes? Time limit of all these modes ?

7.what is diff between analytics server and Xmlp server in oracle fusion BIP?

8.Outbound Integration using BIP : Large volume of data :data size limit error ? How will you overcome this situvation ?

9.oic lookup has 100 columns we have 5 columns to use in comparison , but we can access lookup  only one time in oic 

but how can you compare ?

10.automate the integration deployment in oic  --- any automation tools used in Code migration ?

11.complex iNtegration worked on? --  

12.AI agent studio  ?  

attend