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