Oracle APPS : Requisition to PO auto creation-issues

Why is an approved Requisition Line not available in the autocreate form to create into a Purchase Order ?

SOLUTION

It is possible that a PO has been already created from the Requisition Line.
NO we can't create PO from already used Requisition line

How to check  if the REQ is ready for Autocreate Process :

By running the following queries one can find whether PO is created from Requisition or not

A)
   select * from
         po.po_requisition_headers_all
    where segment1 = & requisition number
B)
       select * from
                    po.po_requisition_lines_all
        where requisition_header_id = & header id
C)
         select * from
                po.po_req_distributions_all
           where requisition_line_id = & line id

2- At line Requisition Line level, REQS_IN_POOL_FLAG should not be N

3 - At Requisition Line level, LINE_LOCATION_ID should be null



If case "REQS_IN_POOL_FLAG" = N  and 'LINE_LOCATION_ID' has a value, then that means a PO has been already created from that Requisition Line

In that case we can't create Purchase order from Requisitions