11i /AP: APXINWKB Performance Problem: Slow Response Querying Invoices in Invoice form
(Doc ID 1269912.1)
Last updated on FEBRUARY 15, 2019
Applies to:Oracle Payables - Version 22.214.171.124 to 126.96.36.199 [Release 11.5]
Information in this document applies to any platform.
***Checked for relevance on 25-Dec-2015***
On : 188.8.131.52 version,
Performance problem when clicking on INVOICES button
to retrieve the invoices form the Invoice batches form.
Also , there is a performance problem when
going from one invoice to the next one.
The issue can be reproduced at will with the following steps:
1. Go to AP responsibility
2. Navigate to Invoices: Entry: Invoice Batches
3. In the Invoice Batches form, query by batch name
4. Click the INVOICES button
5. The form retrieved the invoices after 4 minutes
6. The cursor is on the first invoice
7. Click the down arrow key to go to the next invoice
8. It took 2 minutes to go to the next invoice
The SQL statement that is taking most of the time is the following:
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document