Internet Procurement interview question and answer

Que:-What is iProcurement?

Ans:-   iProcurement is a self-service web Purchasing application. Consider it as an alternate application for creating purchase requisitions and simple receiving.

Que:-  : What is a punchout?
Ans :-    : Punchout enables buyers to click a link that goes to a supplier’s catalog, search for

items on the supplier’s site, and return those items directly to the buyer’s shopping

cart.

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

Que:-  : Do we create purchase orders in iProcurement ?
Ans :-    : No, you can create requisitions in iProcurement.

Que:-  : 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?
Ans :-   : In Workflow "PO Create Documents", assign a default value Y to attribute "Is Automati Approval Allowed?".

Que:-  : We need to submit PO Creation as soon as the Requisition gets submitted & auto-approved in iProc. How can we do it?
Ans :-    : 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.

Que:-  : What are the key advantages of punchout over local catalog management?
Ans :-    : 
A. You do not need to maintain the pricing information of items. Supplier will publish their 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.

Que:-  : 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?
Ans :-    : 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 ).

Que:-  : After the purchase order gets approved, you wish to send Purchase Order electronically to the supplier. Which XML document format is used?
Ans :-    : "PO 007" is the OAG format that is used for electronically sending XML Purchase Order to supplier.

Que:-  : Have you done any customization in Oracle iProcuremnt?
Ans :-    : 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. 

Que:-  : What is the advantage of punching out via exchange, rather than punching out directly to suppliers website?
Ans :-    : 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.

Que:-  : Give me some example of personalization’s done to Oracle iProcurement.
Ans :-    : 
a. Change the Branding Logo.
b. Add Purchasing News and Purchasing Policies
c. Removed field “New Supplier” from iProc Supplier Region

Que:-  : You wish to customize the Purchase Order header in the XML file that gets sent to supplier. How will you do it ?
Ans :-   : 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 customize view ITG_PO_HEADER_ARCH_V(11.5.10 onwards)

Oracle Apps - To know the responsibility of user

Hi Folks,

 Below is the query to know the responsibility of user

   SELECT fu.user_name, fu.start_date user_startdate, fu.end_date user_enddate,

       fr.responsibility_name, furgd.start_date, furgd.end_date,

       fu.email_address,trunc(sysdate)

  FROM fnd_user fu,

       fnd_user_resp_groups_direct furgd,

       fnd_responsibility_tl fr

 WHERE fr.responsibility_id = furgd.responsibility_id

   AND fu.user_id = furgd.user_id

 and fu.user_name = :User_name

   AND fr.LANGUAGE = 'US'

Oracle Apps - How do get PO details based on Requisition Number

Hi Folks,

Below is the query to get PO details based on Requisition Number

SELECT poh.segment1, prha.segment1 RequisitionNumber,poh.*

FROM   apps.po_headers_all poh

,      apps.po_lines_all pol

,      apps.po_distributions_all pod

,      apps.po_req_distributions_all prda

,      apps.po_requisition_lines_all prla

,      apps.po_requisition_headers_all prha

WHERE  poh.po_header_id = pol.po_header_id

AND    pol.po_line_id = pod.po_line_id

AND    pod.req_distribution_id = prda.distribution_id

AND    prda.requisition_line_id = prla.requisition_line_id

AND    prla.requisition_header_id = prha.requisition_header_id

AND    prha.segment1= :Requisition_Number

order by prha.LAST_UPDATE_DATE desc

Oracle Apps - How do get Requisition details based on PO Number

HI Folks

Below is the query to get Requisition details based on PO Number

select prha.segment1 Requisition_Number,poh.*

from po_requisition_headers_all prha,

     po_requisition_lines_all prla,

     po_req_distributions_all prda,

     po_distributions_all pda,

     PO_HEADERS_ALL poh

where poh.po_header_id =pda.po_header_id

and pda.req_distribution_id = prda.distribution_id

and prda.requisition_line_id = prla.requisition_line_id

and prla.requisition_header_id = prha.requisition_header_id

and poh.segment1 = :PO_Number

Check User's Profile Value

HI Folks,

To check user profile value's through query.

 SELECT   p.user_profile_option_name, '3 - User', u.user_name, v.level_value,

         v.profile_option_value

    FROM fnd_profile_option_values v, fnd_profile_options_vl p, fnd_user u

   WHERE v.profile_option_id = p.profile_option_id

     AND (v.level_id = 10004 AND u.user_id = v.level_value)

     AND u.user_name = :'User_ Name'

--AND P.USER_PROFILE_OPTION_NAME LIKE '%FND: View Object Max Fetch Size%'

ORDER BY 1, 2, 3