My Oracle Support Banner

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 to [Release 11.5]
Information in this document applies to any platform.
***Checked for relevance on 25-Dec-2015***


On : 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.