How to delete a row from AP_PAYMENT_SCHEDULES_ALL Oracle R12 table?

Please 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

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.