Procure to Pay (P2P) Cycle in Oracle Apps Technical

• Create Requisition
• Create Purchase Order
• Create Inventory Receipt
• Enter AP Invoice
• Make Payment
• Transfer to GL

Create Requisition:

Nav: Purchasing à Requisition

Create a purchase requisition.

Tables:

SELECT * FROM PO_REQUISITION_HEADERS_ALL

SELECT * FROM PO_REQUISITION_LINES_ALL
SELECT * FROM PO_REQ_DISTRIBUTIONS_ALL

Create Purchase Order

Nav: Purchasing Responsibility > Auto create

Enter requisition number which is saved and hit search.

Once you find the requisition select it by enabling the checkbox and choose the type of document you want to create and click on Automatic

Now we will select Ship-To field as this is required to create inventory receipt /purchasing receipt.

Tables:

SELECT * FROM PO_HEADERS_ALL
SELECT * FROM PO_LINES_ALL

SELECT * FROM PO_DISTRIBUTIONS_ALL

SELECT * FROM PO_LINE_LOCATIONS_ALL

Create Inventory Receipt

Nav: Purchasing Responsibility > Receiving > Receipts

Enter the Purchase order number to find the PO which is created

Once you create a receipt for PO you will not be allowed to create another receipt for the same PO. It is allowed only in case of partial receipts.           

Tables:

SELECT * FROM RCV_SHIPMENT_HEADERS
SELECT * FROM RCV_SHIPMENT_LINES

SELECT * FROM RCV_TRANSACTIONS 

Once Receipt created we can check whether the requested items are received or not by using these tables in inventory module.
SELECT * FROM MTL_SYSTEM_ITEMS_B
SELECT * FROM MTL_ONHAND_QUANTITIES

Enter AP Invoice and Make payments:

Enter header information in invoice workbench then match the PO and validate the invoice.

Once invoice successfully created without any holds then make payment for the invoice.

Tables:

SELECT * FROM AP_INVOICES_ALL

SELECT * FROM AP_INVOICES_LINES_ALL

SELECT * FROM AP_INVOICE_DISTRIBUTIONS_ALL

To view Invoice holds details:

           Select * from ap_holds_all

To view release the Invoice holds names:

           Select * from ap_holds_release_name_v;

 

Transfer to GL

“Payables Transfer to General Ledger” concurrent program will be executed from SRS screen. This program will transfer all the payment transactions into the G.L Module.

To view from AP to GL:

           Select * from gl_interface;

But in R12 we need to run 'Create Accounting Program' 

In create accounting program window we can see 3 modes

1. Draft : only priview purpose

2. Post : When we select this button sysytem automatically journal entries will be transfer to GL and accounting entries will be genarated.

3. Final post : When we select this button sysytem automatically journal entries will be transfer to GL and accounting entries will be genarated and posted also.

To view journal import details:

           Select * from gl_je_headers       for Headers

           Select * from gl_je_lines            for Lines

           Select * from gl_je_batches       for Batches

To view posting:

           Select * from gl_balances;

Table Joins between PO, AP and GL

Requisitions:

Headers and lines:

requisition_header_id in po_requisition_headers_all = requisition_header_id  in po_requisition_lines_all table.

Lines and distributions:

requisition_line_id in po_req_distributions_all = requisition_line_id in po_requisition_lines_all table.

Requisitions and Purchase Order:

distribution_id in po_req_distributions_all = req_distribution_id in po_distributions_all

Purchase Order to AP Invoices:

Distribution ID in PO_Distributions_All = PO_DISTRIBUTION_ID in ap_invoices_all.

11i AP to GL

When Source is Payable then reference_5 of GL_JE_LINES table is the invoice Number and reference_2 is the invoice_id and Ref3 is the check_id.

R12 Using SLA:

Order to Cash (O2C) Cycle in Oracle Apps Technical

Order to Cash:

• Enter the sales order
• Book the sales order
• Launch pick release
• Ship confirm
• Create Invoice
• Create Receipt
• Transfer to GL
• Journal Import
• Posting 

Enter the sales order:

Navigation: Order Management Super User ->Orders Returns -> Sales Orders

Enter the Customer details (Ship to and Bill to address), Order type and line details under lines tab.

In OE_ORDER_HEADERS_ALL-> Flow_status_code = “Entered”

Book the sales order:

Under same page Book the Order by clicking on the Book Order button.

OE_ORDER_HEADERS_ALL —> Flow_status_code =“BOOKED”

OE_ORDER_LINES_ALL—> Flow_Status_code = “AWAITING_SHIPPING”

Record will be created into “WSH_DELIVERY_ASSIGNMENTS” MTL_DEMAND

WSH_DELIVERY_ASSIGNMENTS —> Released_Status = ‘R’ (read to release)

Launch Pick Release:

Navigation: Shipping > Release Sales Order > Release Sales Orders.

If auto create delivery is set to ‘YES’ then new record will be created in WSH_NEW_DELIVERIES.

delivery_id is populated with WSH_DELIVERY_ASSIGNMENTS in

 WSH_DELIVERY_DETAILS = ‘Y’ (pick confirm)

                                                   ’S’ (Release to warehouse)

Ship Confirm the order:

Navigation: Order Management Super User>Shipping >Transactions.

Query with the Order Number.

Now click on delivery tab and confirm the shipment.

OE_ORDER_HEADERS_ALL —> Flow_status_code= “booked”

OE_ORDER_LINES_ALL —> Flow_Status_code = “Shipped”

WSH_DELIVERY_DETAILS —> release_status = C (ship confirm)

Create Invoice:

Run workflow background Process

Navigation: Order Management >view >Requests

Workflow Background Process inserts the records RA_INTERFACE_LINES_ALL with

INTERFACE_LINE_CONTEXT     =     ‘ORDER ENTRY’

INTERFACE_LINE_ATTRIBUTE1=     Order_number

INTERFACE_LINE_ATTRIBUTE3=     Delivery_id

and runs Auto invoice Master Program and Auto invoice import program which creates Invoice for that particular Order.

The Invoice created can be seen using the Receivables responsibility

Navigation: Receivables Super User> Transactions> Transactions

Query with the Order Number as Reference.

RA_CUSTOMER_TRX_ALL will have the Invoice header information.

The column INTERFACE_HEADER_ATTRIBUTE1 will have the Order Number.

RA_CUSTOMER_TRX_LINES_ALL will have the Invoice lines information.

The column INTERFACE_LINE_ATTRIBUTE1 will have the Order Number.

CREATE RECEIPT:

Navigation: Receivables> Receipts> Receipts

After entering the receipt information you could see the information in AR_CASH_RECEIPTS_ALL

TRANSFER:

In Release 12,  “General ledger transfer program” and Journal Import is no longer used. we are using Submit Accounting program instead this spawns Revenue Recognition Process.

POSTING:

After Posting we can see the data in GL_BALANCES.

Over View:

OE_ORDER_HEADERS_ALL—> Flow_ststus_code= Entered

                                                                                     = Booked

OE_ORDER_LINES_ALL —> Flow_status_code = “Awaiting_shipping”

                                                                                   =“Shipped”

WSH_DELIVERY_DETAILS—>Released_Status = “R” (Read to release - book sale order)

                                                               = “Y” (Pick Confirm -launch pick release)

                                                               = “S” (Release to warehouse - launch pick rel)

                                                               = “C” (ship confirm - Ship confirm)

Table Joins between OM, AR and GL

OM and AR

oe_order_lines_all.header_id = ra_customer_trx_all.interface_line_attribut6

AR and GL

Ra_cust_trx_line_gl_dist_all.code_combination_id= code_combination_id.gl_code_combinations.