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

BI Publisher : Print Bar Code in BI Report

 BI Publisher : Print Bar Code in BI Report 

1)Create Data Model using below query and Save it in appropriate custom folder 

SELECT 

    poh.segment1 AS po_number,

    poh.authorization_status AS po_status,

    pov.vendor_name AS supplier_name,

    pol.line_num AS line_number,

    pol.item_description,

    pol.unit_price,

    pol.quantity

FROM 

    po_headers_all poh,

    po_lines_all pol,

    poz_suppliers_v pov

WHERE 

    poh.po_header_id = pol.po_header_id

    AND poh.vendor_id = pov.vendor_id

    AND poh.segment1 = NVL(:p_po_number, poh.segment1)

2) Create report on top of above data model and generate template by wizard

3) Edit report .rtf template

5) Download TFT file ( Template)

6) Change  the font format to Bc309 in my rtf template.

7) Upload template and preview output .

8) Font mapping in BIP Administration 

   BIP>>Administration >>Manage BI Publisher >>Runtime Configuration>>Font Mapping >>

 Step1) Upload .tft file  

Step2) Add font Mapping 

Style=Normal

Weight=Normal

target font type=TRUE

Target Font =Pick uploaded .tft file in step8

Apply>>Return 

Test the Report 

Configuring font mapping can take few minutes .Refresh report output.

Interview Questions - MPC /Devi

 

 22-07-2026  Interview Questions - MPC /Devi

 1.what is the use of with clause

 2 How to remove special charecter in oracle DB column ?

To remove special characters from a column in an Oracle Database, use the REGEXP_REPLACE function. This function relies on regular expressions to identify and strip out everything except alphanumeric text. 

1. View Cleaned Data (SELECT)

To display data without special characters without modifying the table, execute a SELECT query: 

sql

SELECT REGEXP_REPLACE(your_column, '[^a-zA-Z0-9]', '') AS cleaned_column 
FROM your_table;

Use code with caution.

[^a-zA-Z0-9]: This negates (^) the set, targeting any character that is not a lowercase letter, uppercase letter, or number.
'': Replaces those targeted characters with an empty string, removing them entirely

 3.  RTF Template with multiple sheets  --Saiteja 

Summary:

RTF Template must push out results in Excel with mutiple sheets

Content (please ensure you mask any confidential information):

I have put in place a rtf template that must give me the results in excel and for each business unit it must generate a separate tab in excel. At the moment it pushes out the results as below.

My expectation is that for each BUSINESS_UNIT that sits in G_1 it should create a tab and name it to the value of that BUSINESS_UNIT

 5.fbdi which object do u loded recentlyn--- supplier  wht is the sequence to load supplier

 6.oic property file use

 7..scope fault deault and global fact in oic

Have you developed Matrix/Crosstab Report Report ? --Samba has realtime scinarios 

Have you loaded objects using FBDI ?  What are they ?

Seupplier FBDI Sequence ? What are they ?

If you submit load interface file for Import . What are underlying processes will get triggered ?

what is propertyfile in OIC ?

Structure of a Property File

The job property file must be written in a single-line comma-separated format using a .properties file extension: 

text

<job_package_name>,<job_definition_name>,<zip_file_prefix>,<Param1>,<Param2>,..

Job Package Name: The path of the Oracle Enterprise Scheduler (ESS) job.
Job Definition Name: The formal system name of the import process.
ZIP File Prefix: The base name of your zipped package. For example, if your file is AP_Invoices_12345.zip, the prefix parameter is AP_Invoices_12345.
Parameters (Param1 to ParamN): Consecutive variables expected by the specific ESS import job. 

What are the underlying tables in Requisition to PO  with join Condition ?

What are Supplier FBDI heirarchy ?

what are they and what is the sequence ?

1. Import Suppliers
2. Import Supplier Addresses
3. Import Supplier Sites
4. Import Supplier Site Assignments
5. Import Supplier Contracts
6. Import Supplier Attachments
7. Import Supplier Business Classifications
8. Import Supplier Products and Services Categories

Create Suppliers with the Import Suppliers Process

Supplier Import processes are programs that you can use to import new supplier records from external systems and to update and delete existing supplier records.

These programs are used to import supplier information:

• Import Suppliers

• Import Supplier Addresses

• Import Supplier Sites (includes third-party payment relationships)

• Import Supplier Site Assignments

• Import Supplier Contacts (includes user accounts and contact addresses import)

• Import Supplier Business Classifications

• Import Supplier Products and Services Categories

• Import Supplier Attachments

• Purge Supplier Interface Records

How the Import Process Works

The Supplier Import process is run by either the Supplier Administrator or the Supplier Manager.

You can load data to interface tables using predefined templates and the Load Interface File for Import scheduled process. Both are part of the External Data Integration Services for the Oracle Cloud feature.

Obtain FBDI templates from the File-Based Data Import for Oracle Fusion Cloud Procurement guide from the links found in the File-Based Data Imports section.

The process for supplier import is as follows:

1. Data must first be inserted into the existing Open Interface Tables:

   • POZ_SUPPLIERS_INT

   • POZ_SUP_ADDRESSES_INT

   • POZ_SUPPLIER_SITES_INT

   • POZ_SITE_ASSIGNMENTS_INT

   • POZ_SUP_CONTACTS_INT

   • POZ_SUP_CONTACT_ADDRESSES_INT

   • POZ_SUP_BUS_CLASS_INT

   • POZ_SUP_PROD_SERV_INT

   • POZ_SUP_ATTACHMENTS_INT

   • POZ_SUP_THIRDPARTY_INT

if we submit Load interface file for Import 

what are underlying programs get submitted ?

Submitting the Load Interface File for Import job in Oracle Fusion triggers two sequential background programs: 

1. Transfer File: Moves the uploaded .zip file from the Universal Content Management (UCM / Oracle WebCenter Content) server to the designated import directory.
Load File to Interface: Extracts the CSV payload from the .zip file and populates the module-specific interface/staging tables. 

Once these finish successfully, you must manually submit the actual product-specific Import Process (e.g., Import Payables Invoices, Import Journals) to move the data from the interface tables into the base application tables

IN BIP Report if AP invoice has attachment how can you show it as hyperlink ?

SELECT 
    aia.invoice_id,
    aia.invoice_num,
    fdt.file_name,
    'https://' || ask.EXTERNAL_VIRTUAL_HOST || 
    '/cs/idcplg?IdcService=GET_FILE&dID=' || fdt.dm_version_number || 
    '&dDocName=' || fdt.dm_document_id || '&allowInterrupt=1' AS attachment_url
FROM 
    ap_invoices_all aia
JOIN 
    fnd_attached_documents fad 
    ON fad.pk1_value = TO_CHAR(aia.invoice_id)
    AND fad.entity_name = 'AP_INVOICES_ALL'
JOIN 
    fnd_documents_tl fdt 
    ON fdt.document_id = fad.document_id
    AND fdt.language = USERENV('LANG')
CROSS JOIN 
    ask_deployed_domains ask

Step 2: Configure the RTF Template

To make the URL clickable in the final PDF or Excel output:

Open your RTF template in Microsoft Word with the BI Publisher Desktop plugin installed.
Add a text field in your repeating group for the URL.
Right-click the field and select BI Publisher Properties.
Go to the Advanced tab.
In the properties box, add the HTML link syntax so it renders as a hyperlink:
<?concat('<a href="', ATTACHMENT_URL, '">View Attachment</a>')?>
Check the "Escape for XML" box to ensure characters like & don't break the XML code. 

Alternatively, if you are generating an Excel output, simply place the raw ATTACHMENT_URL column directly into your layout. Excel will automatically recognize the string as a clickable link.

Sandbox --Added Report link in ap invoice page ?   --Raghava do a POC 

You can dynamically add a custom Business Intelligence Publisher (BIP) report link to the Oracle Fusion Payables (AP) Invoice page using the Page Composer tool within an active Sandbox

loaded 100 records using FBDI supplier and 1 record got error in loading into interface table . What will happen to 99 records ?

is it possible to Bulk Data load using webservice in oracle fusion  with out OIC ?  --Guru TPT /Abhilash 

Complex BIP Report which you recently Developed ?

I had developed Matrix reports 

    to display account wise * Costcenter Debits in GL 

Inventory 

   Category wise Item Consumption report 

OM 

     Customer wise sales 

Inv Planning Spares Report -- 

Report Run Date: <?CF_REPORT_RUN_DATE?>

Organization Name: <?CF_ORGANIZATION_NAME?>

Part Number	Root Part Code	Root Part Description	ABC Class	FMS Class	Consumption  Value	Consumption Quantity	0-30 DAY Demand	31-60 DAY Demand	61-90 DAY Demand	Back Order	Daily Demand	Lead Time	Lead Demand	Onhand	Lot Size	Reorder Quantity	Transaction Type
F SEGMENT1	ROOT_ITEM	ROOT_ITEM_DESCRIPTION	ABC_CLASS	FMS_CLASS	0.00	CF_CONSUMP	THIRTY_DAY_BUCKET	SIXTY_DAY_BUCKET	NINTY_DAY_BUCKET	PO_QTY	DAY_REQ	NEW_LEAD_TIME	CF_NLD	ONHAND	LOT	CF_RO_QTY	TTYPE E

 

In BIP  -- How can you print Header level attribute at line level -- xpath notation ./  //

Master Detail Report 

  

BIP Report  fetching 2 lakh records 

Multi sheet template in BIP using RTF or Excel template 

In below scinario data is morethan 2lakh rows  what will the result   Try it in RTF as well Excel 

Sandbox 

 Page Composer 

Application Composer 

Appearance 

Structure

Page Integration 

Manage Service Mappings 

Configure Business Objects 

HCM Experience Design Studio 

User Interface Text 

Data Security 

Lookups 

Messages 

Flexfields 

Page Template Composer

OIC Versioning 

Version Structure

Major (xx): Changes the first digits; allows multiple major versions (e.g., 1.00.0000 and 2.00.0000) to remain active simultaneously with distinct runtime endpoint URLs. 
Minor (yy): Changes the middle digits for backward-compatible updates; activating a new minor version automatically deactivates the previous minor version. 
Patch (zzzz): Changes the final digits for small bug fixes or minor map adjustments without changing active status behavior.

Int1  1.0 -active 

int1   2.0 -activated 

int7  1.0.1 -- deactivated 

int7   1.1  -- activate it