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
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
