Wednesday, July 6, 2016

Complete Oracle P2P cycle

Complete Oracle P2P cycle

Lets do a complete P2P Cycle

Step 1) Create Item
Step 2) Create Requisition and Approve it
Step 3) Auto Create RFQ
Step 4) Create Quotation
Step 5) Auto Create PO and Approve it
Step 6) Receipt
Step 7) Auto Invoice Generation (Remember Pay on Receipt should be checked on vendor site before creation of purchasing document and vendor site must be a pay site). Or you can manually create an invoice by using match option on Invoice entry form
Step 8) Validating Invoice and Accounting Creation
Step 9) Make Payment and Create accounting for payments
Step 10) Payables Transfer to General Ledger

Step 1) Lets Create an Item using Purchased template

Navigate to PO> Item> Master Item

Oracle P2P cycle
Item Creation













Step 2) Create a Requisition for this Item and Approve the same

Oracle P2P cycle
Requisition Creation






























Tables Involved here. Also refer PO Data Flow 

PO_REQUISITION_HEADERS_ALL
PO_REQUISITION_LINES_ALL

PO_REQ_DISTRIBUTIONS_ALL

Step 3) Auto Create an RFQ from this requisition

Navigate to PO> Auto Create and query for the requisition # 14930.

Select Document type as RFQ

Oracle P2P cycle
Auto Create RFQ















Select RFQ as Standard RFQ





















Click Create

























Click on Supplier and add suppliers who you want to send this RFQ



















You can also specify Price breaks and terms

Now change the status of this RFQ active to send it to suppliers



Step 4) Create Quotation

Query RFQ > Tools> Copy Document

Oracle P2P cycle
Create Quote























Click OK
























Now please remember, standard quotation can only be converted to Blanket Agreement through Tools> Copy Document otherwise use AutoCreate form and Requisition to create standard PO.

Bid Quotations can be converted to Standard PO. You can even change the type of quotation here.

Step 5) Create PO

































A new Standard PO # 6930 got generated. Approve it















Tables Involved.Also refer PO Data Flow
PO_HEADERS_ALL
PO_LINES_ALL

PO_DISTRIBUTIONS_ALL

Step 6) Receive the PO




Tables Involved.
RCV_SHIPMENT_HEADERS
RCV_SHIPMENT_LINES
Also refer PO Data Flow

Step 7) Auto Invoice Generation

You can see the "ADS  (Pay On Receipt AutoInvoice)" run automatically because of supplier level setups.

Remember you pay on receipt should be checked on vendor site before creation of purchasing document.










Step 8) Go To Payable responsibilty and click on Invoice> inquiry> Invoice










































Click on Action > Validate























Also Manually Approve the invoice

Now again click on Action > Create Accounting

 You will see a successful message


















You can also see from tools>View Accounting events

Step 9) Make Payments and create Accounting for Payments

Now payment Click on action and select "Pay in Full"


Select Bank account, Payment Process Profile and Payment Date and save you work




















Now create accounting for payments Click Actions > select Creating accounting


A confirmation message will be displayed




Step 10) Run  "Transfer Journal Entries to GL" request


Transfer Journal Entries to GL

























No comments:

Post a Comment

Oracle Fusion - Cost Lines and Expenditure Item link in Projects

SELECT   ccd.transaction_id,ex.expenditure_item_id,cacat.serial_number FROM fusion.CST_INV_TRANSACTIONS cit,   fusion.cst_cost_distribution_...