The vendor/site in the requisition need to be linked to a contract.
1) Set the following attributes of the CREATEPO workflow:
'Is Automatic Creation Allowed?' Y
'Is Automatic Approval Allowed?' Y
'Should Contract be used to Autocreate PO' Y
'Is Contract Required on the req line?' N
Should Non-Catalog Requests be Autosourced From Contract? Y
To update the attributes, follow these steps in workflow builder:
a. Open workflow builder and connect to the database as the APPS user. Open the PO Create Workflow. The display name is PO Create Documents.
b. Expand the data source, and then the PO Create workflow item type branch within that data source.
c. Expand the Attributes branch within the PO Create workflow branch.
d. Double click on the attribute to open the Properties window. Set the value of the attributes as indicated.
2) Check to see if the contract does exist:
select max(po_header_id)
from po_headers_all
where vendor_id = &vendor_id
and vendor_site_id = &vendor_site_id
and type_lookup_code = 'CONTRACT'
and nvl(cancel_flag,'N') = 'N'
and sysdate between nvl(start_date, sysdate - 1)
and nvl(end_date, sysdate + 1)
and authorization_status = 'APPROVED'
and nvl(closed_code,'OPEN') = 'OPEN';
3) Also need to check attribute: 'Send PO Autocreation to Background' of the Requisition workflow. If it is set to 'Y', then need to make sure to run Workflow Background Engine for the item type = PO Requisition Approval
4) The user needs to specify the vendor information on the requisition.
