Payables and Cash Management - EBS (MOSC)

MOSC Banner

Invoice struck in payment process request with selecting invoices for payment status - Urgent

edited Mar 13, 2013 1:50AM in Payables and Cash Management - EBS (MOSC) 5 commentsAnswered
Hello All

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center