Login
Register

Home

Trainings

Fusion Blog

EBS Blog

Authors

Contact Us

Oracle Apps Interview Questions
  • Register

Oracle Gold Partners, our very popular training packages, training schedule is listed here
Designed by Five Star Rated Oracle Press Authors & Oracle ACE's.

webinar new Click here to raise Support Ticket. Get reply within 48 hours.

Search Courses

User Rating: 5 / 5

Star ActiveStar ActiveStar ActiveStar ActiveStar Active
 
Please find some of interview questions in Oracle iProcurement.


Question : Is POR_CUSTOM_PKG redundant in 11.5.10 ?
Answer : Not really, it is still used. However rebuild of account functionality was moved to OAF from por_custom_pkg in 11.5.10

Questions : Which version of iProcurement saw the demise of AK Developer in Oracle iProcurement ?
Answer : 11.5.10

Question : What is a punchout?
Answer : This is a mechanism by which buyers can navigate to Suppliers website straight from iProcurement. Once the shopping is finished, they then checkout the basket on suppliers website itself following which the shopping basket is brought back to iProcurement. Shopping basket is nothing but a returned XML file that contains the list/quantity/price of items checked out from suppliers website.

Questions : Do we create purchase orders in iProcurement ?
Answer : No, you create requisitions in iProcurement.

Question : We need to submit PO Creation as soon as the Requisition gets submitted & auto-approved in iProc. How can we do it?
Answer : In Workflow "PO Requisition Approval", The item attribute “SEND_CREATEPO_TO_BACKGROUND” needs to be assigned value of N.
This will enable Real-Time processing of requisition mainly because the user can get a PO Number within the same browser session if auto-approval is enabled.


Questions : What are the key advantages of punchout over local catalog management?
Answer :
A. You do not need to maintain the pricing information of items. Supplier will publish thir latest pricing details in their iStore.
B. You do not need to upload the items of your supplier into your system.
C. The up-to-date stock level information is made available on Suppliers Website.

Question : When shopping basket is brought back from suppliers website after punchout, how does the item category code of supplier item get mapped to the category code in Oracle?
Answer : Suppliers punchout basket will always contained universally recognized category codes i.e. UNSPSC codes. You will need to define the mapping for each such expected code in eCommerce gateway. These will be mapped to your inventory category codes ( the good old mtl_categories ).

Question : Have you done any customization in Oracle iProcuremnt?
Answer : Note: All the implementations of iProcurement will involve customization of workflows to some extent.
Customization to Account Generator workflow is a must for any iProc implementation.
You may visit the article Oracle Account Generator Workflow Example to learn steps for customizations of Account Generation workflow in Oracle Apps.

Question : Give me an example of extension for Oracle iProcurement using OA Framework .
Answer : Use this article link to help you explain the answer.

Question : What is the advantage of punching out via exchange, rather than punching out directly to suppliers website?
Answer : If you enable punchout via Oracle Exchange Server, you will then have to open up your company firewall just for the exchange server. However if you decide to enable a direct punchout, you must open firewall for Suppliers server.

Question : If a requisition has been approved in iProc, we want such requisitions to be Auto-Approved once they get converted to PO. How do we facilitate this?
Answer: In Workflow "PO Create Documents", assign a default value Y to attribute "Is Automati Approval Allowed?".


Question : Give me some example of personalizations done to Oracle iProcurement.
Answer :
a. Change the Branding Logo.
b. Add Purchasing News and Purchasing Policies
c. Removed field “New Supplier” from iProc Supplier Region

Question: If you are not yet on 11.5.10, how to enable debug in iProcurement ?
Answer :
cd $ORACLE_HOME/../iAS/Apache

vi $ORACLE_HOME/../iAS/Apache/Jserv/etc/ssp_init.txt
DebugOutput=/home/Aitupuat/ITUPUAT/ora9/iAS/Apache/Apache/logs/debug.log
DebugLevel=5
DebugSwitch=ON

vi $ORACLE_HOME/../iAS/Apache/Jserv/etc/jserv.conf
ApJServLogLevel debug

vi $ORACLE_HOME/../iAS/Apache/Jserv/etc/jserv.properties
log=true

Question : 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 that is used for electronically sending XML Purchase Order to supplier.

Question : You wish to customize the Purchase Order header in the XML file that gets sent to supplier. How will you do it ?
Answer: Two options:-
a. Modify the XML Message Map for PO-007 using XML Gateway Developer.
b. Customize view PO_ECX_HEADER_ARCH_V(prior to 11.5.10) or customise view ITG_PO_HEADER_ARCH_V(11.5.10 onwards)

NB: I will add more questions, in due course.

 


Anil Passi

Comments   

0 #1 Abhishek Mishra 2007-01-09 00:00
Just Great Article.

Wil l appreciate if more stuff on Receipts and customization of approval workflow will be provided.

Re gards
Abhishek Mishra
Quote
0 #2 Abhishek Mishra 2007-01-09 00:00
Just Great Article.

Wil l appreciate if more stuff on Receipts and customization of approval workflow will be provided.

Re gards
Abhishek Mishra
Quote
0 #3 Nivant sheth 2007-05-26 00:00
Hello Anil,
Thanks for all your tremendous efforts. Your each and every article is worh reading. I would like to know more on the interview questions of iprocurement and Purchasing.

Thanks , Nivant
Quote
0 #4 Anil Passi 2007-05-27 00:00
Hi Nivant

You may decide to read iProc Setup document, as in that document I have covered all the setup steps normally done for iProc.

Thank s,
Anil
Quote
0 #5 Karuna 2007-06-28 00:00
Hi Anil,
Thanks for all the tremondous efforts.
Your each & every article is really worth reading.I would like to know teh setup steps for purchasing & iprocurement.

Thanks,
Karu na
Quote
0 #6 Fanish 2007-07-04 10:18
Would really appreciate if you can update your interview question list.

Regards,
Fanish
Quote
0 #7 Anil Passi 2007-07-04 10:21
Hi Fanish

I haven't given any interview for 4years now.
I guess readers should leave their questions in the comments

Thank s,
Anil Passi
Quote
0 #8 Gautham 2007-07-30 11:33
DEar Anil,

Would be grateful if you post me Inteview FAQ's for Oracle Inventory,Purch asing, WIP, BOM etc ( Totaly Mfg) , OM
Thanks
Gauth am
Quote
0 #9 Kanjana Lim 2007-09-16 15:06
I would like Purchase Order header in the XML file repeated every page, right now it is created only on the first page and footer on the last page.
Quote
0 #10 Y.siva Reddy 2008-01-03 04:26
Dear Mr.Anil,

Thanks for your effort, i want to have more interview question about i procurement, Inventory, Purchasing & Fixed Assets & Account Paybles
My Eamil Id - , Cell no. 9949169466
plea se send me a mail if possible, and i want to know job sources also as functional consultant only

regards

ysreddy
Quote
0 #11 Meenakshi Verma 2008-03-17 05:20
Dear Anil,

Thanks for your effort.. this is very help full.
Would be grateful if you post me Inteview FAQ's for Oracle Inventory,Purch asing, WIP, BOM etc ( Totaly Mfg) , OM, iProcurement.
p lz send me on my email id if possible.
Thank s
Meenakshi Verma
Quote
0 #12 Hasitha 2008-10-31 13:26
Hi Anil,

Your work and efforts are really appreciated. Could you please send me some Technical Interview FAQ's for Oracle Inv, OM, Purchasing, WIP,BOM and iProcurement if there are any. Could you please send to my gmail id .

Thanks ,

Hasitha
Quote
0 #13 Ramya Kalaparthi 2009-02-17 11:15
Hi Anil,

Your work and efforts are really appreciated and very helpfull .Could you please send me some Technical Interview FAQ's for AP,GL,PO,iExpen ses and iProcurement if there are any. Could you please send to my email id.

Thanks ,
Ramya.
Quote
0 #14 LASH 2009-10-17 06:04
Hi Anil,

I am new to Oracle and we are thing of iprocurement - i know i must have the purchasing module but do i need to implement iSupplier also for the application to work? From my readings iProcurement can complete reqs and then purchasing module converts to PO's, do i need to create the reqs through iSupplier from the vendors site?

Please give some insight to what modules must be purchased for the implementation and use of iProcurement.

Thanks
Quote
0 #15 Suri 2015-03-03 11:48
Hi Anil,

Your work and efforts are really appreciated and very helpfull .Could you please send me some Technical Interview FAQ's for AP,GL,PO,iExpen ses and iProcurement if there are any. Could you please send to my email id.

Thanks ,
Ranga.
Quote

Add comment


Security code
Refresh

Search Trainings

Fully verifiable testimonials

Apps2Fusion - Event List

<<  Aug 2021  >>
 Mon  Tue  Wed  Thu  Fri  Sat  Sun 
        1
  2  3  4  5  6  7  8
  9101112131415
16171819202122
23242526272829
3031     

Enquire For Training

Related Items

Fusion Training Packages

Get Email Updates


Powered by Google FeedBurner