Procure-to-Pay (P2P) Cycle in Oracle Apps R12
Introduction
The Procure-to-Pay (P2P) Cycle is one of the most fundamental business processes in Oracle E-Business Suite. It covers the entire lifecycle of procurement—from identifying a need for an item, through purchasing and receiving it, to paying the supplier.
This guide walks you through the complete P2P cycle step by step, using a simple, practical example. Each stage explains the navigation path and the business purpose behind the action.
Note: The screenshots referenced in this guide are from an R12.1.1 instance. The navigation paths may vary slightly depending on your Oracle E-Business Suite version and configuration.
Overview of the P2P Cycle
The Procure-to-Pay cycle consists of ten key stages:
| Stage | Activity | Responsibility |
|---|---|---|
| 1 | Choosing an Item | Purchasing |
| 2 | Creation of Requisition | Purchasing |
| 3 | Checking Requisition Status | Purchasing |
| 4 | Creation of Purchase Order | Purchasing |
| 5 | Creation of Receipts | Purchasing |
| 6 | Checking On-Hand Quantity | Inventory |
| 7 | Checking Material Transactions | Inventory |
| 8 | Creation of Invoice | Purchasing |
| 9 | Checking and Validating Invoice | Payables |
| 10 | Creation of Accounting and Payment | Payables |
Stage 1: Choosing an Item
The first step is to identify the item you want to procure.
Navigate to Purchasing Responsibility:
Log in with the Purchasing responsibility
Verify the Item is Purchasable:
Open the item master form
Ensure the item has the Purchasable flag enabled
View Item Categories:
Click Tools → Categories
Review the categories assigned to the item
Purpose: Confirming that the item is purchasable ensures it can be added to requisitions and purchase orders.
Stage 2: Creation of Requisition
A requisition is an internal request to purchase goods or services.
Navigate to the Requisition Form:
Use the Purchasing responsibility to open the Requisitions form
Create a New Requisition:
Enter the item chosen in Stage 1
Specify quantity, need-by date, and other details
View Charge Account:
Click Distributions to view and verify the charge account
Save and Submit for Approval:
Save the requisition
Click Submit for Approval
Note the Requisition Number:
For this example, the requisition number is 14855
Purpose: The requisition captures the internal demand and routes it through the approval workflow.
Stage 3: Checking the Status of Requisition
After submission, you need to verify that the requisition has been approved.
Open the Requisition Summary Form:
Navigate to the Requisition Summary form
Query the Requisition:
Enter the requisition number (14855)
Click Find
Verify Approval Status:
In this example, the submitted and approved person are the same, so the status shows Approved
View Approval Details:
Use the appropriate navigation to view the approval history and status
Purpose: Confirming approval ensures the requisition is ready for conversion into a purchase order.
Stage 4: Creation of Purchase Order
A purchase order (PO) is the formal document sent to the supplier.
Navigate to Autocreate Documents:
Use the Purchasing responsibility to open the Autocreate Documents form
Query the Requisition:
Enter the requisition number and click Find
Select Automatic:
Click Automatic to create the purchase order from the requisition
Click Create:
Click the Create button to generate the PO
Configure Shipment Details:
View the shipment screen
Change the Match Approval Level to 2-Way
Configure Receiving Controls:
Click Receiving Controls
Ensure the Routing is set to Direct Routing
Save and Submit for Approval:
Save the purchase order
Submit it for approval
Note the PO Number:
Record the purchase order number for later stages
Purpose: The purchase order formalizes the commitment to buy and is the basis for receiving and invoicing.
Stage 5: Creation of Receipts
A receipt records the physical delivery of goods against the purchase order.
Navigate to the Receiving Form:
Use the Purchasing responsibility to open the Receiving form
Query the Purchase Order:
Enter the PO number created in Stage 4
Select the Lines Received:
Check the checkbox next to the lines that have been received
Click Save
View the Receipt Number:
Click the Header button to view the receipt number
Purpose: The receipt confirms that goods have been delivered and creates the basis for inventory and invoicing.
Stage 6: Checking the On-Hand Quantity
After receiving, the inventory on-hand quantity should increase.
Navigate to Inventory Responsibility:
Log in with any Inventory responsibility
Query the Receipt:
Search for the receipt created in Stage 5
Ensure the organization matches the receiving organization
Verify On-Hand Quantity:
Confirm that the inventory has increased by the received quantity (e.g., 5 units)
Purpose: Verifying on-hand quantity ensures the receipt has been processed correctly and inventory records are accurate.
Stage 7: Checking the Material Transactions
Material transactions provide a detailed audit trail of inventory movements.
Navigate to Material Transactions:
Use the Inventory responsibility to open the Material Transactions form
Query the Item and Date:
Enter the item and the transaction date
Review Transaction Details:
View the Source and Transaction Type
View Serial Numbers:
For serial-controlled items, view the serial numbers received
Purpose: Material transactions provide traceability and auditability for all inventory movements.
Stage 8: Creation of Invoice
An invoice is created to record the supplier's bill for the goods received.
Navigate to Requests:
Use any Purchasing responsibility to open the Requests form
Submit the Invoice Creation Request:
Submit the appropriate request, providing the Receipt Number as a parameter
Check the Program Status:
Monitor the request until it completes successfully
Purpose: The invoice creation program automatically generates invoices from receipts, streamlining the payables process.
Stage 9: Checking and Validating the Invoice
Before payment, the invoice must be validated to ensure it matches the purchase order and receipt.
Navigate to Payables Responsibility:
Log in with the Payables responsibility
Open the Invoices Form:
Open the Invoices form
Query the Invoice:
Search using the purchase order number
Validate the Invoice:
Click the Actions button
Check the Validate checkbox
Click OK
Verify the Status:
Confirm the invoice status shows as Validated or Approved
Purpose: Validation ensures the invoice matches the PO and receipt (2-way or 3-way match), preventing payment errors.
Stage 10: Creation of Accounting and Payment
Once the invoice is validated, accounting entries can be created and payment can be processed.
Navigate to the Invoice Form:
Open the Payables responsibility and the Invoices form
Create Accounting:
Click the Actions button
Select Create Accounting
Create Payment:
Click the Actions button
Select Pay in Full or Create Payment
Verify the Payment:
Confirm the payment has been processed and the invoice is closed
Purpose: Creating accounting entries ensures the financial impact is recorded, and creating payment completes the P2P cycle by paying the supplier.
The Complete P2P Flow
The following illustrates the complete Procure-to-Pay cycle:
┌─────────────────────────────────────────────────────────────────┐
│ 1. CHOOSE ITEM │
│ Verify the item is purchasable and view its categories │
└──────────────────────────┬──────────────────────────────────────┘
│
▼
┌─────────────────────────────────────────────────────────────────┐
│ 2. CREATE REQUISITION │
│ Enter the item, quantity, and charge account │
│ Submit for approval │
└──────────────────────────┬──────────────────────────────────────┘
│
▼
┌─────────────────────────────────────────────────────────────────┐
│ 3. CHECK REQUISITION STATUS │
│ Verify the requisition is approved │
└──────────────────────────┬──────────────────────────────────────┘
│
▼
┌─────────────────────────────────────────────────────────────────┐
│ 4. CREATE PURCHASE ORDER │
│ Autocreate from the requisition │
│ Set match approval level and receiving controls │
│ Submit for approval │
└──────────────────────────┬──────────────────────────────────────┘
│
▼
┌─────────────────────────────────────────────────────────────────┐
│ 5. CREATE RECEIPT │
│ Receive the goods against the PO │
│ Note the receipt number │
└──────────────────────────┬──────────────────────────────────────┘
│
▼
┌─────────────────────────────────────────────────────────────────┐
│ 6. CHECK ON-HAND QUANTITY │
│ Verify inventory has increased │
└──────────────────────────┬──────────────────────────────────────┘
│
▼
┌─────────────────────────────────────────────────────────────────┐
│ 7. CHECK MATERIAL TRANSACTIONS │
│ Review the transaction audit trail │
└──────────────────────────┬──────────────────────────────────────┘
│
▼
┌─────────────────────────────────────────────────────────────────┐
│ 8. CREATE INVOICE │
│ Submit the invoice creation request with the receipt number │
└──────────────────────────┬──────────────────────────────────────┘
│
▼
┌─────────────────────────────────────────────────────────────────┐
│ 9. VALIDATE INVOICE │
│ Match the invoice to the PO and receipt │
│ Validate the invoice │
└──────────────────────────┬──────────────────────────────────────┘
│
▼
┌─────────────────────────────────────────────────────────────────┐
│ 10. CREATE ACCOUNTING AND PAYMENT │
│ Create accounting entries │
│ Process payment to the supplier │
└─────────────────────────────────────────────────────────────────┘Key Documents in the P2P Cycle
| Document | Purpose | Created In |
|---|---|---|
| Requisition | Internal request to purchase | Stage 2 |
| Purchase Order | Formal order to the supplier | Stage 4 |
| Receipt | Confirmation of goods received | Stage 5 |
| Invoice | Supplier's bill for goods | Stage 8 |
| Payment | Disbursement to the supplier | Stage 10 |
Key Concepts Explained
Match Approval Level
The Match Approval Level determines how the invoice is matched before payment:
| Level | Description |
|---|---|
| 2-Way | Invoice matches Purchase Order |
| 3-Way | Invoice matches Purchase Order and Receipt |
| 4-Way | Invoice matches PO, Receipt, and Inspection |
Direct Routing
Direct Routing means goods are received directly into inventory without requiring inspection.
Autocreate
Autocreate is the process of automatically generating a purchase order from an approved requisition.
Best Practices
| Practice | Description |
|---|---|
| Verify Item Setup | Ensure items are purchasable and have correct categories |
| Use Proper Charge Accounts | Assign the correct charge account in requisitions |
| Submit for Approval | Always submit requisitions and POs for approval |
| Set Correct Match Level | Choose the appropriate match approval level (2-way, 3-way, 4-way) |
| Receive Against PO | Always receive goods against the correct purchase order |
| Validate Invoices | Always validate invoices before payment |
| Review Material Transactions | Periodically review material transactions for accuracy |
| Reconcile Payments | Reconcile payments with invoices and bank statements |
Troubleshooting Common Issues
| Issue | Possible Cause | Solution |
|---|---|---|
| Requisition not approved | Approval workflow pending | Check the approval status and notify approvers |
| PO not created | Requisition not approved | Ensure the requisition is approved before autocreate |
| Receipt not created | Wrong PO or quantity | Verify the PO number and received quantity |
| On-hand not updated | Receipt not saved | Verify the receipt is saved and processed |
| Invoice not created | Receipt not processed | Ensure the receipt is complete before creating the invoice |
| Invoice not validated | Match failure | Verify the PO, receipt, and invoice amounts match |
| Payment not created | Invoice not validated | Validate the invoice before creating payment |
Summary
The Procure-to-Pay cycle in Oracle Apps R12 involves the following key stages:
Choose an Item: Verify the item is purchasable
Create a Requisition: Capture internal demand and submit for approval
Check Requisition Status: Verify approval
Create a Purchase Order: Autocreate from the requisition and configure controls
Create Receipts: Receive goods against the PO
Check On-Hand Quantity: Verify inventory has increased
Check Material Transactions: Review the audit trail
Create Invoice: Generate the invoice from the receipt
Validate Invoice: Match and validate the invoice
Create Accounting and Payment: Record financial impact and pay the supplier
Key Points to Remember
The Requisition is the starting point of the P2P cycle
The Purchase Order is the formal commitment to buy
The Receipt confirms delivery and updates inventory
The Invoice records the supplier's bill
Validation ensures the invoice matches the PO and receipt
Payment completes the cycle by paying the supplier
Accounting entries record the financial impact at each stage
Why the P2P Cycle Matters
The Procure-to-Pay cycle is critical to any organization because it:
Ensures Control: Provides approvals and controls at each stage
Maintains Accuracy: Matches invoices to POs and receipts to prevent errors
Tracks Inventory: Updates on-hand quantities and material transactions
Records Financials: Creates accounting entries for accurate financial reporting
Manages Suppliers: Ensures timely and accurate payment to suppliers
Provides Auditability: Creates a complete audit trail from requisition to payment
By understanding the P2P cycle, functional consultants and business users can effectively manage procurement processes in Oracle E-Business Suite, ensuring accuracy, control, and efficiency.
References
Oracle E-Business Suite Documentation: Purchasing User's Guide
Oracle E-Business Suite Documentation: Payables User's Guide
Oracle E-Business Suite Documentation: Inventory User's Guide
Oracle E-Business Suite Documentation: Receiving User's Guide
My Oracle Support: Procure-to-Pay Cycle Documentation
No comments:
Post a Comment