Payables and Cash Management - EBS (MOSC)

MOSC Banner

Running get_approval_status for all invoices in the system

edited Sep 8, 2009 6:36AM in Payables and Cash Management - EBS (MOSC) 4 commentsAnswered
Hi there,

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center