My Oracle Support Banner

Performance problem in Invoice Workbench: It Takes Long Time When Changing The Supplier Site (Doc ID 1572029.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.


On : 12.1.3 version,

Performance problem in the Invoice workbench.
For an existing invoice, when selecting another
supplier site from the list of values,
the form shows the window message:

APP-SQLAP-10131: When you update the supplier name, number or site for an existing invoice,
Oracle Payables does not update the invoice with the defaults from the new supplier or site.
Update each invoice value individually.

After clicking OK button in the window message,
the form takes 1 minute to complete the change.

The following SQL statement is taking long time:







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.