Interview Questions.

Question 1. Is Por_custom_pkg Redundant In eleven.5.10?

Answer :

Not clearly, it's miles nonetheless used. However rebuild of account functionality turned into moved to OAF from por_custom_pkg in eleven.5.10.

Question 2. Which Version Of Iprocurement Saw The Demise Of Ak Developer In Oracle Iprocurement?

Answer :

11.5.10

PL/SQL Interview Questions
Question three. What Is A Punchout?

Answer :

This is a mechanism with the aid of which consumers can navigate to Suppliers internet site immediately from iProcurement. Once the purchasing is finished, they then checkout the basket on suppliers internet site itself following which the purchasing basket is delivered lower back to iProcurement. Shopping basket is not anything however a back XML document that incorporates the listing/amount/price of items checked out from provider’s website.

Question four. Do We Create Purchase Orders In Iprocurement?

Answer :

No, you create requisitions in iProcurement.

Question five. What Are The Key Advantages Of Punch Out Over Local Catalog Management?

Answer :

You do no longer want to keep the pricing statistics of gadgets. Supplier will post their contemporary pricing info of their iStore.
You do no longer need to add the items of your dealer into your machine.
The updated stock degree facts is made to be had on Suppliers Website.
DBMS Interview Questions
Question 6. When Shopping Basket Is Brought Back From Supplier’s Website After Punchout, How Does The Item Category Code Of Supplier Item Get Mapped To The Category Code In Oracle?

Answer :

Supplier’s punchout baskets will always contained universally diagnosed category codes i.E. UNSPSC codes. You will want to define the mapping for every such anticipated code in ecommerce gateway. These can be mapped in your inventory category codes (the coolest antique mtl_categories).

Question 7. Have You Done Any Customization In Oracle Iprocurement?

Answer :

All the implementations of iProcurement will involve customization of workflows to a point.
Customization to Account Generator workflow is a must for any iProc implementation. 
You might also go to the article Oracle Account Generator Workflow Example to learn steps for customizations of Account Generation workflow in Oracle Apps.
SQL Interview Questions
Question eight. What Is The Advantage Of Punching Out Via Exchange, Rather Than Punching Out Directly To Suppliers Website?

Answer :

If you permit punchout via Oracle Exchange Server, you may then should open up your organisation firewall just for the alternate server. However if you make a decision to allow an instantaneous punchout, you need to open firewall for Suppliers server.

Question nine. Give Me Some Example Of Personalization Done To Oracle Iprocurement?

Answer :

Change the Branding Logo.
Add Purchasing News and Purchasing Policies.
Removed discipline “New Supplier” from iProc Supplier Region.
Oracle E-Bussiness Suite Interview Questions
Question 10. After The Purchase Order Gets Approved, You Wish To Send Purchase Order Electronically To The Supplier. Which Xml Document Format Is Used?

Answer :

"PO 007" is the OAG format this is used for electronically sending XML Purchase Order to dealer.

Question 11. You Wish To Customize The Purchase Order Header In The Xml File That Gets Sent To Supplier. How Will You Do It?

Answer :

Two alternatives:-

Modify the XML Message Map for PO-007 using XML Gateway Developer.
Customize view PO_ECX_HEADER_ARCH_V(previous to 11.Five.10) or customize view ITG_PO_HEADER_ARCH_V(eleven.Five.10 onwards).
Data analyst Interview Questions
Question 12. What Is Iprocurement?

Answer :

iProcurement is a self-provider net buying software.  Consider it as an alternate utility for developing buy requisitions and simple receiving.

PL/SQL Interview Questions
Question 13. What Are The Key Advantages Of Punch Out Over Catalog Management?

Answer :

No want to maintain the price records. Supplier will keep it at their give up in the iStore.
No want to upload dealer object in our machine.
Question 14. If A Requisition Has Been Approved In Iprocurement, We Want Such Requisition To Be Auto-permitted Once They Get Converted To Po. How You Achieve It?

Answer :

In Workflow "PO Create Documents", assign a default cost Y to characteristic "Is Automatic Approval Allowed".

Question 15. After The Purchase Order Gets Approved, You Wish To Send Purchase Order Electronically To The Supplier, Which Xml Document Format Is Used?

Answer :

"PO 007" is the OAG layout this is used for electronically sending XML Purchase Order to supplier.

Oracle iPlanet Web Server (OiWS) Interview Questions
Question 16. What Is Zero Buyer Intervention?

Answer :

Once the requisition is absolutely authorised and required computerized approval steps achieved, the PO is created automatically and approved. The equal can then be sent to the supplier through FAX or EDI and material received against it. This one does now not has to go through the buying branch where in the buyer would name for an RFP, then undergo the manner of calling quotations, observed by the quotation evaluation.  Converting quotations into PO, going through the PO approval method and sooner or later sending it to the provider.

Question 17. Where Does The Value Default From In The Account Distribution For Expense Items In Core Purchasing And In Iprocurement?

Answer :

For the rate items the price in account distribution in middle Purchasing defaults from the cost item characteristic set in the object Attribute Level in Purchasing tab area if its no longer there then from the Organizations Parameters Expense Valuation Accounts within the Costing statistics tabbed region.

In case of iProcurement for rate gadgets the cost inside the account distribution defaults from the worker file.

Complex SQL Queries Interview Questions