Oracle P2P FAQs?

5.   What are the reports associated with requisition import process?

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: In this report we can see all the rows that fail validation.

6.   When will you use a Requisition Template?

Requisition templates can be used to help you quickly create requisitions. A requisition template contains much of the information needed to create a requisition, thus reducing the amount of data entry required to create a new requisition. If you find yourself repeatedly creating similar requisitions for your group or department, you should consider creating and saving requisition templates as a time-saver.

If the data of requisition remain the same for repeated purchase of an item, the information can be copied to a template and the same can be copied to the Requisition as many number of times as required.

7.   What is the purpose of choosing a Category when creating a requisition?

The Category box is a required field and is used to define goods and services at a summary or detailed level.

8.   What does the status pre-approved mean?

Pre-Approved is the status of a requisition when an authorized approver has approved the requisition and has forwarded the requisition to another individual to review.

9.   What is the difference between a rejected and a returned requisition?

Only an approver or a reviewer can reject requisition. Only a buyer can return a requisition. A buyer will return a requisition to the preparer for incomplete or inaccurate information.

10.   What is RFQ and differentiate the types of RFQ’s

A Request for Quotation (RFQ) 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.

In general, RFQ’s are created before purchasing any item to actually know the price quotes from one or more suppliers.

In Oracle EBS, RFQ’s can be auto created from an existing Purchase Requisition or can be a fresh RFQ.

There are three types of quotations and RFQs that come with Purchasing by default:

·         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’ll need only once or not very often, but not necessarily for a specific, fixed quantity, location, and date. For example, you could use a Catalog quotation or RFQ for office supplies, but use a Standard quotation or RFQ for a special type of pen you don’t order very often. A Standard quotation or RFQ also includes price breaks at different quantity levels.

·         Bid: Used for a specific, fixed quantity, location, and date. For example, a Bid would be used for a large or expensive piece of equipment that you’ve 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.

11.   What is a Quotation, what are the different types of Quotations available and describe the Quote Analysis?

A quotation is a supplier’s response to RFQ.

Quote analysis is the process of reviewing the quotations given by the suppliers. The best quotation will be selected by analyzing certain factors like price, quality, delivery time etc.

12.   What is a Purchase Order and explain the different types of PO’s available

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.

Basically, there are four types of Purchase Orders, viz

Standard Purchase Order	Used for One-time purchases for goods and services. Here you know the item, price, payment terms an delivery schedule
Planned Purchase Order	Created when you have long-term agreement with the supplier. You must specify the details of goods and services, payment terms and the tentative delivery schedule
Blanket Purchase Agreement	Created when the details of items 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.

14.   What is 2-way, 3-way, 4-way matching?

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.

Two–Way: Purchase order and invoice quantities must match within tolerance before the corresponding invoice can be paid.

Three–Way: Purchase order, receipt, and invoice quantities must match within tolerance before the corresponding invoice can be paid.

Four–Way: Purchase order, receipt, accepted, and invoice quantities must match within tolerance before the corresponding invoice can be paid.

15.   Explain the P2P process flow

Procure to pay (p2p) is a process of requesting, purchasing, receiving, paying for and accounting for goods and services.  Procure to Pay Lifecycle is one of the important business Process in Oracle Applications. It’s the flow that gets the goods required to do business.  It involves the transactional flow of data that is sent to a supplier as well as the data that surrounds the fulfillment of the actual order and payment for the product or service.

Create a requisition>> create RFQ>> create a quotation from quote analysis>> generate a PO>>receipt of material>> create Invoice in payables>> transfer to GL

16.   What is an approval hierarchy?

Approval hierarchies let you automatically route documents for approval. There are two kinds of approval hierarchies in Purchasing: position hierarchy and employee/supervisor relationships.

17.   What are the documents that use PO_HEADERS_ALL?

The following are the documents that use PO_HEADERS_ALL

RFQ’s, Quotations, Standard Purchase Order, Planned Purchase Order, Blanket Purchase Order and Contracts

18.   Can the original Purchase Order be viewed in any way without resorting to SQL, for a revised Purchase Order?

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 and PO_LINES_ARCHIVE tables using the PO_HEADER_ID column as a common reference using SQL only.

19.   Can we automatically ‘Close’ the Purchase order without receiving the full quantity?

The Receipt Close Tolerance lets you specify a quantity percentage within which Purchasing closes a partially received shipment. For example, if your Receipt Close Tolerance is 5% and you receive 96% of an expected shipment, Purchasing automatically closes this shipment for receiving.

20.   When does a Purchase Order line get the Status ‘Closed for Receiving’?

Goods have been received on the system against this line but an invoice has not been
matched to the order.

21.   Can we match an Invoice against a line even when it is ‘Closed for Invoicing’?

The Close for invoicing status does not prevent you from matching an invoice to a purchase order or to a receipt.

22.   What does create internal order conc request do?

Create internal order request will transfer the IR info to OM interface tables.

23.   Explain the Receipt Routing

Receipt Routing is of three types: Direct, Standard and Inspection

In Direct once the goods arrive at the destination, we directly move them to a specific Sub-Inv

In Standard once the goods are at the destination, we receive it at the receiving point first and then move them to the Sub-Inv.

In 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.

24.  What are the different Purchasing modes in Receiving? 

There are three 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 REC_TRANSACTION_INTERFACE table.

Batch: Receipts are processed in batch, but no errors are shown. Errors are recorded in REC_TRANSACTION_INTERFACE table.

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

26.  What are the major transactions in RECEIVING? 

Purchase Order Receipts

Internal Requisition Receipts

Inventory Inter-Org Transfer Receipts

Customer Return Receipts

27.   What is Pay on Receipt AutoInvoice Program?

By running this program, we can automatically create an invoice for a PO when we enter a receipt for the respective PO.

28.  What is Invoice Validation Process?

Before you can 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 the purchase order, or changing the invoice tolerances.