Monday, May 16, 2016

R12.1.3 Payables: Invoice Validation program has performance issue

For the article "R12: AP: Invoice Validation program (APPRVL): Performance Issue - Insufficient Parameters" on My Oracle Support via document ID 2138625.1 you need to read up on the attached bug as well since it appears this dynamic query is actually being designed to run for an excessive amount of time if you do not provide an invoice date range.  That means that just entering an Operating Unit parameter does not actually limit the query as much as you would think, and Oracle Development has closed the bug as "not a bug" even though it really sounds like a bug!

No comments:

Post a Comment