FS_BP selects the requisition but does not process it.
Hi Team,
I am cancelling a requistion (ePRO) whose PO is already cancelled using the following query:
When I run the budget check, it goes to success with:
No documents were selected to process for request number 1.
Request 1 Statistics. Documents Processed: 0, Errors: 0, Warnings: 0.
Why is not picking the requisition for processing?
UPDATE PS_REQ_HDR SET REQ_STATUS = 'X', IN_PROCESS_FLG = 'N', ACTIVITY_DATE = SYSDATE, BUDGET_HDR_STATUS = 'N'
WHERE (BUSINESS_UNIT,REQ_ID) IN (('BU','REQID'))
AND REQ_STATUS NOT IN ('C','X');
UPDATE PS_REQ_LINE SET CURR_STATUS = 'X'
WHERE (BUSINESS_UNIT,REQ_ID) IN (('BU','REQID'))