Running get_approval_status for all invoices in the system
I need to get the approval status for every lines in ap_invoices_all table. Right now we are using the fonction AP _INVOICES_PKG.GET_ APPROVAL _ STATUS , but because of all the context change, it takes a very long time (around 5 hours) since there is more than 5 millions rows in the table.
Does anyone know another way to get the status in a more performant way ?
Regards,
Guillaume Goulet-Vallières