Cancel Invoice - Invoice Distribution is not equal to Invoice Amount (Script to Cancel the invoice)

Hello Gurus,

i am on Oracle 11i 5.10.2.

We have an Invoice that we are trying to cancel.

Invoice Amount is 0 but invoice distribution is -850.  I understand that 2 holds are placed on this Invoice.

However, no action can be taken on the voucher now. As per the screenshots below, no lines can be added to the distribution, nothing can be reversed and only the calculate tax button is available.

Beside, deleting the lines on ap_invoice_distributions_all is there another script that could be suggested that could help fix this issue?

I would like not to delete the wring lines on ap_invoice_distributions_all.