Sunday, August 9, 2015

Oracle SCM Functional Interview Questions & Answers - Purchasing Module - Part III

Oracle SCM Functional Interview Questions & Answers - Purchasing Module - Part III

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

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.

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 &
Contracts

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.

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.

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.

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.

What does create internal order concurrent request perform?
Create internal order request will transfer the IR info to OM interface tables.

Explain the Receipt Routing
Receipt Routing is of three types: Direct, Standard & 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.

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.

Which tables are updated a received Data is saved in a form?
rcv_shipment_headers: It contains supplier shipment header data like Shipment date, supplier Name
rcv_transactions_interface It contains received data like Item name, quantity, and receiving location
rcv_shipment_lines
mtl_material_transactions_temp
po_line_locations_all
po_distributions_all

What are the major transactions in Receiving? 
Purchase Order Receipts
Internal Requisition Receipts
Inventory Inter-Org Transfer Receipts
Customer Return Receipts

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.

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.


Reference: Collected from various web sources

Please do refer:


1 comment: