Purchase Requisition(PR) Manual Cancellation and Recreate PR for a Sales Order

There are some scenario PO will not create due some Mandatory columns missed in the PR data. Sometime PR created without Values like vendor_id

vendor_site_id , SUGGESTED_VENDOR_NAME, SUGGESTED_VENDOR_LOCATION and NEGOTIATED_BY_PREPARER_FLAG from Order Data.

In This case how we need to cancel the PR and Recreate the PR.

1. Check the Order Status

 2.      Find the Requisition Number created for this Order and Line Number

      SQL>select segment1,a.*  from po_requisition_headers_all a where interface_Source_line_id=6603893

 

     3.  Go To NL Purchasing Super Setup Resp.  à Requisition Summary à Find on Requisition Number

è  Go To Tools à Control Document à Cancel Requsition

    4.     Click On OK and it will get cancelled

   5.     If You Re query the same Requisition Number and see the status is Cancelled

6.     And Order Status will be coming back to Supply Eligible.

7.     Now Again go to NL Order Management and Progress the Order by selecting  ‘Create Supply Order  - Eligible’ action in the list of action.

 

8.     Internally Auto Create Internal requisition Program and Requisition Import Programs Are Running. (if Not Submit the programs)

When Auto Create Internal Requisition will create the records in Requisition Interface tables

When Requisition Import Program Runs(If not submit the program) It will create the PR for associated SO and Line.

     And Order and Line Status Becoming to EXTERNAL_REQ_OPEN again 

 

9.     And Order and Line Status Becoming to EXTERNAL_REQ_OPEN again

10.     And Re query the Requisitions created for the source line id.