enter image description herePlease I need to know how to delete a row from AP_PAYMENT_SCHEDULES_ALL table in oracle R12?

Thanks in advance

2 Answers

Why you want to delete all rows? If you can't use HOLD_FLAG to 'Y' to place a hold on the scheduled payment ? - Abhi

1

According to the documentation the primary key on AP_INVOICE_PAYMENTS_ALL is INVOICE_PAYMENT_ID. Therefore, given a valid value for INVOICE_PAYMENT_ID you'd do something like

DELETE FROM AP_INVOICE_PAYMENTS_ALL WHERE INVOICE_PAYMENT_ID = #####

where ##### is the invoice payment ID.

Best of luck.

1

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password

Post as a guest

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.