Oracle Purchasing Interview Questions

A: It is a formal request intended to procure /buy something that is needed by the organization.  These are two types:
Internal Requisition: Created if the items are to be obtained from one inventory location to another location within the same organization.  Here the source of the requisition would be INVENTORY.  There is no approval process for internal requisition.
External Requistion / Purchase Requistion: Created if the items are to be obtained from the external suppliers.  Here the source of the requisition would be SUPPLIERS.  The purchase requisitions are sent for approvals.  

2: What are the tables for Purchase Requistion:
A: PO_REQUISITION_HEADERS_ALL, 
     PO_REQUISITION_LINES_ALL, 
     PO_REQ_DISTRIBUTIONS_ALL.

3: What is Requisition Import Program? and requisition interface tables
A: It is a concurrent program which is used to import requisition from Oracle / Non-Oracle Systems. Interface tables are:
PO_REQUISITION_INTERFACE_ALL
PO_REQ_DIST_INTERFACE_ALL
PO_INTERFACE_ERRORS

4: What are the reports associated with Requisition Import Process?
A: Requisition Import Run Report: We can view the number of requisitions created and the number of records that showed an error.
Requisition Import Exceptions Report: We can view all the rows that fail validation.

5: What is the purpose of choosing a Category when creating a requisition?
A: Category box is a required field and is used to define goods and services at a summary or detailed level.

6: What is the difference between rejected and a returned requisition?
A: Only an approver or reviewer can reject requisition.  Only buyer can return a requisition.  A buyer will return a requisition to the preparer for incomplete or inaccurate information.

7: What is RFQ and different types of RFQ's?
A: A RFQ(Request For Quotation) is a formal request sent to the suppliers to find the pricing and other information for an item or items.  Based on the information supplied, the supplier quotes a quotation against the RFQ form. Below are the types of RFQ's:
Catalog: Used for high volume items or items for which your supplier sends you information regularly.  A Catalog quotation or RFQ also includes price breaks at different quantity levels.
Standard: Used for items you will need only once or not very often, but not necessarily for a specific, fixed quantity, location and date.
Bid: Used for a specific, fixed quantity, location and date.  For example, a Bid would be used for a large expensive piece of equipment that you have never ordered before, or for an item that incurs transportation or other special costs.  You cannot specify price breaks for a Bid quotation or RFQ.

8: What is a Purchase Order and explain different types of PO's available
A: A Purchase Order is a commercial document and first official order issued by the buyer to the supplier, indicating types, quantities and agreed prices for products or services the supplier will provide to the buyer.
Four different types of PO's are available:
Standard Purchase Order: Created for One-time purchases for goods and services. Here we know the item, price, payment terms and delivery schedule.
Planned Purchase Order: Created when you have long-term agreement with the supplier. We must specify the details of goods and services, payment terms and the tentative delivery schedule.
Blanket Purchase Agreement: Created when the details of goods and services, payment terms are known but not specific about the delivery schedule.
Contract Purchase Agreement: Created when the terms and conditions of a purchase are known but specific goods and services are not.

9: What is 2-Way, 3-Way & 4-Way matching?
A: Oracle Payables shares purchase order information from your purchasing system to enable online matching with invoices. Invoiced or Billed items are matched to the original purchase orders to ensure that you pay only for the goods or services you ordered and / or received.
2-Way: Purchase order and Invoice quantities must match within tolerance before the corresponding invoice can be paid.
3-Way: Purchase Order, Receipt and Invoice quantity must match within tolerance before the corresponding invoice can be paid.
4-Way: Purchase Order, Receipt, Accepted & Invoice quantity must match within tolerance before the corresponding invoice can be paid.

10: Can the original PO be viewed in anyway without resorting to SQL, for a revised PO?
A: The original version of a revised PO cannot be viewed from the PO form or PO Summary form. Information on the original PO can be obtained from the PO_HEADERS_ARCHIVE & PO_LINES_ARCHIVE tables using the PO_HEADER_ID column as a common reference using SQL only.

11: Can we automatically Close the PO without receiving the full quantity?
A: The Receipt Close Tolerance lets you specify a quantity percentage within which Purchasing closes a partially received shipment.  For Ex: if the Receipt Close Tolerance is 5% and we receive 96% of an expected shipment, Purchasing automatically closes this shipment for receiving.

12: When does the PO line get the status Closed for Receiving?
A: Goods have been received against the PO line but an invoice has not been matched to the order.

13: Can we match an Invoice against a line even when it is Closed for Invoicing?
A: The Close for Invoicing status does not prevent you from matching an invoice to a purchase order or to a receipt.

14: What does Create Internal Order concurrent request do?
A: Create Internal Order concurrent request will transfer the Internal Requisition information to OM Interface tables.

15: Explain the Receipt Routing?
A: Receipt Routing is of 3 types:
Direct: Once the goods are at the destination, we directly move them to a specific sub-inventory.
Standard: Once the goods are at the destination, we receive it at the receiving point and then we move them to a specific sub-inventory.
Inspection: Once the goods are at the destination, we receive it at the receiving point and then we perform inspection and accordingly we either accept it or reject them.  

16: What are different purchasing modes in Receiving?
A: There are 3 Modes,
Online: Receipts are processed online. If there are any errors, they are shown on the Form itself, and don't let you ignore and proceed.
Immediate: Receipts are processed immediately, but no errors are shown. Errors are recorded in RCV_TRANSACTIONS_INTERFACE & PO_INTERFACE_ERRORS
Batch: Receipts are processed in batch, but no errors are shown. Errors are recorded in RCV_TRANSACTIONS_INTERFACE & PO_INTERFACE_ERRORS

Note: In all the above two cases, it requires Receiving Transaction Processor to be run periodically.

17: What the major transactions in Receiving?
A: PO Receipts, Internal Requisition Receipts, Inventory Inter-Org Transfer Receipts and Customer Return Receipts.

18: What is Pay on Receipt AutoInvoice Program?
A: By running this program, we can automatically create an invoice for a PO when we enter a receipt for the respective PO.

19: What is invoice Validation Process?
A: Before you pay or create accounting entries for any invoice, the invoice validation process must validate the invoice.
Invoice Validation checks the matching, tax, period status, exchange rate, and distribution information for invoices you enter and automatically applies holds to exception invoices. if an invoice has a hold, you can release the hold by correcting the exception that caused Invoice Validation to apply the hold by updating the invoice or to the purchase order, or changing the invoice tolerances.

20: Requisition autocreated in the system to be grouped by Buyer.  How to achieve this functionality?
A: In Purchasing Option, Set requisition group by parameter to "Buyer"

21: How do we ensure if Purchase Order is cancelled then corresponding requisition is also cancelled?
A: In Purchasing Option, Set Cancel requisition to "Optionally" or "Always"

22: If the preparer of Purchase Requisition is not authorized to Approve that requisition then what setup should be performed in the system?
A: In document type, Set Owner can approve flag to No.

23: What is the difference between the control actions "On Hold" and "Freeze" for a Purchase Order?
A: Freeze or Un-Freeze, documents to control whether modifications are allowed or not
On Hold, prevent document from printing, receiving, invoicing and approval until the hold is removed.

24: What is the different document statuses used in Oracle Purchasing?
A: Frozen, Cancelled, Finally Closed, Incomplete, In-Process, Pre-Approved & Approved

25: Can we re-open "Closed" & "Finally Closed" PO
A: We can re-open "Closed" and we can make changes too, but we cannot re-open "Finally Closed" PO

26: How do I change the supplier on an approved PO?
A: No, we cannot change supplier name for an approved PO, you have to create new PO or use copy document if you want to change supplier name but you will get different PO number on this.

Indeed, but if you want to have option that enable you to change "Supplier Site", you can set a profile "PO: Change Supplier Site" to "Yes". Yes indicates whether user can change the supplier site on approved PO's. Only sites with the same currency as the previous site can be used. If you change the supplier site, the revision will be incremented and will require re-approval.

27: When an user enters a new PO, the preparer (User) is always defaulted as the buyer. User is not able to change it too. How do we allow user to change this?
A: This is because an option on "Purchasing Options", Purchasing Options > Document Control > Enforce Buyer Name - If you enable it, PO Preparer cannot change default Buyer name, - by disabling it, you can change buyer seeded data.

28: Payment due days if 30 days mean will it be from invoice date or material receiving date?
A: Due days calculation is based on what we setup in the Payment tab window of supplier master form. It has four options, 1. Goods Received, 2. Invoice, 3. Invoice Received & 4. System

29: Where do we define matching option for purchasing?
A: This is defined in supplier master form under Control tab window. Two options are given as Purchase Order or Receipts. 

No comments:

Post a Comment