Sunday 10 January 2021

TOP 21 Oracle P2P Interview Questions

TOP 21 Oracle P2P Interview Questions

Hi friends, we are going to discuss about the Oracle P2P Interview Questions. We will share most important p2p interview questions , which helps to prepare the oracle apps interviews. These interview question & answers have picked from the p2p cycle in oracle apps. You should refer this post, for the Preparation of your Oracle p2p Interviews. Please find below the complete detail about Oracle P2P Interview Questions.

TOP 21 Oracle P2P Interview Questions
TOP 21 Oracle P2P Interview Questions


Question 1:
How Many Types of Purchase Requisition in Oracle Fusion?

Answer:
Purchase Requisition is a kind of material request to purchase/buy or some time from internal stores. In purchase Requisition , we do specify which items we need to procure , what’s the quantity we need and which org or department need this material.

There are types of Purchase Requisition in Oracle Fusion
1.Internal 
2.External

Internal Requisition: Internal Requisition, is a kind of request of material within the organization. In Internal Requisition we don’t procure or buy material from outside org but in this we have material inside our org in inventory store in different location and we request to transfer this material or item from store to that location.

External Requisition: In External Requisition, We do procure or buy material from outside organization. In this we mentioned our material request to procure and based on that purchase team purchase this material from external vendors.


Question 2:
What is ERS(Pay on receipt Program) in Procurement?


Answer:
ERS is the Payment on receipt program. This program helps to create the Payables Invoices automatically from Purchase order receipts. ERS or Pay on Receipt program is also one of the standard methods which helps to create the Payables invoices automatically from the Purchase Order Receipts. So, it means whenever we will do the Receiving against the Purchase Order then after that Pay on Receipt program will automatically create the Payable Invoices for that Purchase Receipt. Pay on receipt program will create the Invoices amount on the basis of Quantity received and price of the Item mentioned in the Purchase Order.
The lines of the Ap Invoice will depend upon the number of Items received in the Purchase Receipt.

 
The amount on the invoice is determined by multiplying the Quantity received by the Purchase Order Item Unit Price. The Payment Terms on the invoice default from the purchase order payment terms. The Payment Currency defaults from the supplier site. Sales Tax is calculated based on the Tax Codes on each Purchase Order Line.

If the Alternate Pay Site is populated for the Supplier Site used on the Purchase Order, the invoice created is for the Alternate Pay Site, otherwise the Supplier Site on the Purchase Order is used. The Supplier Site used for the invoice must be defined as a Pay Site.


Question 3
What is Mixed Type Invoice in Oracle Apps ?


Answers :
Mixed Invoice is one of the invoice type in the Oracle Payables. You can enter both the Negative and the Positive Amount for this Mixed Type Invoice. This Payment type is not rigid like Standard, Prepayment, Credit & Debit Memo Invoices to enter the amount in the specific signs (Positive or Negative) .

TOP 21 Oracle P2P Interview Questions
TOP 21 Oracle P2P Interview Questions


Question 4:
What is Pay Alone in AP Invoice. What is the use of Pay Alone in p2p cycle?


Answers :

Pay alone is something related to Invoice Payment. This is the Flag we set for AP Invoice, It Means this invoice will be paid alone. For example, Supplier A has 3 Invoices, but for 1 Invoice we have enabled the Pay Alone Flag Then When we will run the Payment Batch then System will create one Check for two invoices and Separate one Check for Pay Alone Invoice. This Is the Working of Pay Alone.


Question 5:
How many types of approval hierarchy we have in Oracle Procurement?

Answer:
We can create three types of approval hierarchy for Purchase Order and Purchase Requisitions.
1.Employee supervisor Hierarchy.
2.Employe Position Hierarchy.
3.AME


Question 6:
What is the action step to stop receiving the specific purchase order line?


Answer:
If we want that, the specific po line should not be approve, we can cancel that PO line. Cancelled line never shows for receiving.


Question 7
What is Primary and Secondary Ledger in Oracle Payables ?


Answers :
Primary Ledger is the Main Ledger and Secondary Ledger is the Replica of the Primary Ledger. We Do transactions in the Primary Ledger. 

The main reason of using Primary and Secondary Ledger is the difference in the Organization Requirment and the Statuary Requirment. For example, One US based company office is in India and as per US Company, their Calendar works from Oct to Sep but the in India their calendar works from Apr to Mar SO in this Kind of Requirment, Primary and Secondary Ledger concept comes. Where we can design the Primary calendar as per the US based but can design the Secondary calendar as per India Statuary Requirment. 

TOP 21 Oracle P2P Interview Questions
TOP 21 Oracle P2P Interview Questions


Question 8
Is it possible to receive and invoice items supplied by a supplier on Hold?

Answer:
Yes. A supplier Hold doesn’t prevent from receiving and invoicing placed earlier to the Hold.


Question 9
Explain the functioning of Payables Trial Balance report ?


Answers :
Payables Trial Balance Report shows the Total Liability or the Supplier Outstanding in the System. This Report shows the Liability in the System supplier and Site Level. This Provide the Summary Information’s for all the Unpaid amount for the Supplier Invoices which are validated.
 

Question 10
Types of Supplier Holds in Oracle Fusion?


Answer:
In Oracle Fusion, we have two types of supplier holds in oracle fusion.

1.Purchasing holds
2.payments Holds.


Question 11
What is receipt routing in Oracle p2p? Explain the functioning of receipt routing in p2p cycle.


Answer:
Receipt routing method helps to receive the purchase order items into our organization. Based on the receipt routing, these purchase order items deliver to our inventory in organization.



Question 12
How AP Invoice Payment Due Date Calculates in Oracle p2p cycles?



Answers :
Invoice Payment Due date depends on the Two Factors.
1.Payment Terms attached to the Invoice
2. Invoice Date.
if Payment Terms is 30 Days and the Invoice Date is 12-Dec-2018
Then Payment Due Date Will be : 12-Jan-2019


Question 13
What is ASL in Oracle p2p cycle?


Answer:
ASL means the approved supplier list in oracle fusion. Approved supplier list helps to create the automatic PO creating in oracle apps r12. Oracle system automatically select the supplier list from approved supplier list based on the purchased item for creating purchase orders.

TOP 21 Oracle P2P Interview Questions
TOP 21 Oracle P2P Interview Questions


Question 14
How many types of Calendar In Oracle Payables p2p ?
 

Answers :
Accounting Calendar: - Accounting Calendar is related to the Ledger which we attach the GL Ledger during creation. Accounting calendar is the system calendar, If we need to enter any transaction in the System for Specific period then that period in the Accounting Calendar should be open. If the Period is Closed we cannot do any transaction for that period. This Totally controls the system.

Special Calendar: Special Calendar does not have any link with the Accounting.  We define this Calendar to be used by Recurring Invoices, Payables Tax Setups and in the Payments Terms too.
For Example, With the help of Special Calendar we determine the Tax Authority Invoices Dates.


Question 15
How many types of receipt routing method in oracle fusion p2p cycle?


answer
There are three types of Receipt routing method in oracle fusion.

1.Direct
2.Standard
3.Inspection


Direct: - In direct Routing method, Purchase order material will be directly delivered to Store/SubInventory. There is only one action step ‘Deliver’

Standard: - In Standard Routing method, Purchase order material will be receive first and then delivered to Store/SubInventory so there two action steps Receive & Deliver.

Inspection: - In Inspection Routing method, Purchase order material will be receive first and then inspect and after inspection, it will be delivered to store. There are three action steps, Receive, Inspect & Deliver.


Question 16
Which are the Special Calendar Types in oracle p2p ?


Answers :
1. Recurring Invoice
2. Withholding Tax
3. Payment Terms
4. Key Indicator

TOP 21 Oracle P2P Interview Questions
TOP 21 Oracle P2P Interview Questions


Question 17
Can we Do Cross Currency Payment in Oracle Payables r12 ?


Answers :
Cross currency is If I have received the Supplier Invoice in USD but I will pay this Invoice with my Base Currency INR. So this Is Called Cross currency in Oracle Payables. In Oracle apps r12 we have no option to use Cross currency.

Question 18
What are the Suppliers Procurement Tables in Oracle p2p?


Answer:
1. AP_SUPPLIERS
2. AP_SUPPLIER_SITES_ALL
3.     PO_VENDORS

TOP 21 Oracle P2P Interview Questions
TOP 21 Oracle P2P Interview Questions

Question 18
What are the AP Invoice Tables in Oracle p2p?


Answer:
1. AP_INVOICES_ALL
2. AP_INVOICE_LINES_ALL
3.     AP_INVOICE_DISTRIBUTIONS_ALL
4.    AP_INVOICE_PAYMENTS_ALL
5.    AP_CHECKS_ALL


Can We pay the AP invoice before Due Date?

Answers :

 
Yes, we can Pay the Invoice Before Due date. For Manual Payment, there is no concern but for Payment Batch, When we are running the Payment Process Request then we need to Enter the Pay Through Date this Date is Very Important, If we have set the Pay Through Date “07-Dec” then this Payment Request will pick only those AP invoices which has been due before “07-Dec-2018”.

Payment Priority High: 1
Payment Priority Low: 99

TOP 21 Oracle P2P Interview Questions
TOP 21 Oracle P2P Interview Questions
 


OracleP2P Interview Questions

0 comments:

Post a Comment

Contact us for any Collaboration, Project Support & On Job Support Work

Name

Email *

Message *