11.5.10 Personalization to Apply a Custom Hold by the time of Validation

Dear All

I have a weird business requirement where one Vendor can request and Advance, so a Prepayment will be generate, later the Vendor will send the invoice "ABC" that must be manually apply to the Prepayment.

However if the Invoice "ABC" is not apply to the Prepayment, that invoice will be paid, hence the vendor will receive money twice once for the Advance and the invoice as well.

Hence we need by the time the invoice is being validated Oracle Apply a hold if there are any avaliable prepayments for that vendor.

Thanks for your comments

Best Regards