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

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

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:

 

 

 

 

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms