Payment holds are released in the following ways:
References:https://docs.oracle.com/cloud/farel8/financialscs_gs/FAWDE/F1005004AN1204B.htm

Why can't I cancel an invoice?
The invoice is:
Additional reasons thatyou can't cancel an invoice are as follows:
You can cancel any unapproved invoice, or an approved invoice that does not have anyeffective payments or posting holds.
References:https://docs.oracle.com/cloud/latest/financialscs_gs/FAPPP/FAPPP1011878.htm#FAPPP1011878

When you submit a "payment process request", you can enable the Apply credits up to zero amount payment option. Enablingthe option causes the payment process to apply credits when the credits reduce the payment amount below zero.
The following scenario illustrate the impact of this option.
Credit Amount Greater Than Invoice Amount
An invoice for 200 USD and a credit memofor 225 USD are due for payment.
The following table describes the payment processing that occurs based on the setting for the Apply credits up to zero amount payment option.
Assume that the "Apply Credits Up to Zero Amount" option is enabled.
Payment processing applies 200 USD of the credit memo to the invoice and creates a payment for 0 USD. The remaining credit is 25 USD.
References:https://fusionhelp.oracle.com/helpPortal/topic/TopicId_P_9F438E13CC89BA0CE040D30A68816F77