Invoice struck in payment process request with selecting invoices for payment status - Urgent
I have a situation in dev environment where the PPR struck with the status selecting invoices for payments
I tried cancelling this from backend using the below queries but not suucessful for some. System changed the status of the PPR to cancelled payment however when I am trying to pay off these invoices again i am getting the error in the attached
Your inputs are appreciated
UPDATE AP_INV_SELECTION_CRITERIA_ALL ISC
SET ISC.status = 'CANCELED'
WHERE ISC.checkrun_name = 'TDK Payment';
commit;
UPDATE IBY_PAY_SERVICE_REQUESTS PSR
SET PSR.payment_service_request_status = 'TERMINATED'
WHERE PSR.call_app_pay_service_req_code = 'TDK Payment';