Oracle Puchasing Flow (PO)

Below is the detail Step by Step flow for oracle Purchasing Module.

1)      Login to Purchasing Vision Operations responsibility Requisitions-->Requisitions

2)      In requisitions window under lines tab you have to enter the Item, Revision, quantity, Price and Need by Information. And Save the Record.

Tables affected are - PO_REQUISITION_HEADERS_ALL

                                            _REQUISITION_LINES_ALL

Requisition Header information is stored in PO_REQUISITION_HEADERS_ALL

  Requisition Number :-  segment1

  Type of Requisition (internal/Purchase) :- TYPE_LOOKUP_CODE

  Status :- AUTHORIZATION_STATUS

Requisition Line Information will be stored in PO_REQUISITION_LINES_ALL

Item_id

Destination_type_code,

Link between above two tables are REQUISITION_HEADER_ID 

3)      Then Approve this requisition by Pressing the APPROVE button in the same window.

After approving this requisition, Requisition window doesn’t show this requisition information.

4) Then you can see your Approved Requisition in Requisition Summary Window by  giving requisition number.  

 

5)  Now you can create the Purchase Order by using Auto create.

Double click on Auto create window.  In this window delete buyer name.

And press find button.

        6)  After Clicking on the Find Button it will show the requisition lines under that requisition number. And also it is asking which type purchase order you want to create.

Select the lines you want to create purchase order. And Press Automatic button.

7) After Pressing the Automatic button it is asking Supplier name and site.

8) Now you press Create button. And it creates Purchase Order. And also showing the purchase order window.

 

9) After creating the purchase order. Then approve this purchase order.

Tables affected are - PO_HEADERS_ALL,

                                            PO_LINES_ALL,

                                            PO_LINE_LOCATIONS_ALL,

                                            PO_RELEASES_ALL,

                                            PO_DOCUMENT_TYPES

                                            PO_DISTRIBUTIONS_ALL

 

10) After approving this Purchase order the status set to ‘Approved’

 

11) After Approving the Purchase Order. Then go to

Receiving Click on Receipts.

12 )Enter the purchase Order number and press find button.

 

13) After find it is showing 

14) Change the Receipt date. It is corresponding to open GL period

15) Select the line. In this screen you can split the total qty into multiple lines and receive in different inventories

16) After selecting the line , Click on Lot-Serial button.

It is asking start Serial number. Give any number that represents lot serial number started and press tab it is automatically taking the end serial number.. It it is not accepted then try with another number.

The window like this

And press DONE. And Press Save Button.

17) After saving this receipt it will generate the receipt number….

Next go to Receiving transaction Summary window…. It is asking purchase order number.. Enter purchase order number. And it is showing receipt number.

Tables affected are       RCV_SHIPMENT_HEADERS

                                                RCV_SHIPMENT_LINES

                                                RCV_TRANSACTIONS

18) Press find button. It is showing receipt number

19) Press Transactions Button. It is showing all the transactions. Under that receipt…