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, [...]

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.