Edi Yanto (何 萬 新)

The below steps are matching invoices from unmatched invoices to matched invoices.
It’s more safely to use oracle packages to matching invoices than insert into destination table directly.
Step:

Find the matching invoices.
Get total row and amount of matching invoices for old batch, use get_actual_inv_count function and get_actual_inv_amount in ap_batches_pkg package.
Release hold payment, use release_single_hold procedure in ap_holds_pkg [...]

For fix the error fetch out of sequence (APXIIMPT), do the below step :

Find import_invoices and import_invoices_group cursor in ap_import_invoices_pkg package.
Comment or disable the for update syntax (FOR UPDATE of invoice_id NOWAIT).
Recompile this package and run Auto Invoice POII (Payables Open Interface Import) again.