My Oracle Support Banner

Buyer Work Center > View Order Distribution Detail with Performance Issue (Doc ID 2415416.1)

Last updated on JUNE 26, 2018

Applies to:

Oracle iSupplier Portal - Version 12.2.6 and later
Oracle Purchasing - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.6 version, 


ACTUAL BEHAVIOR
---------------
When navigate through purchasing > buyer work center > orders > query one order > click distribution > select actions = view invoices, system shows poor performance issue together with expensive sql id "cvcjw0mkn14a3" in awrrpt report output.

EXPECTED BEHAVIOR
-----------------------
buyer work center > order distribution - view invoices does NOT have performance issue.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. purchasing > buyer work center > orders > query example PO 
2 - click distribution > select actions = view invoices, system shows poor performance issue together with expensive sql id as follow which introduces in file awrrpt report output:


 

 

 

 

 

Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.