My Oracle Support Banner

Orders Tab Performance In iSupplier Portal (Doc ID 1951222.1)

Last updated on MARCH 27, 2019

Applies to:

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


On : 12.1.3 version, Purchase Order Issues

When a supplier logs in to iSupplier and clicks the Orders Tab it is very slow to respond.

The Profile POS_ORDER_DISPLAY_PERIOD = 40.  Lowering the value for the profile has no impact.

The view pos_view_po_summary_v is slow with the bottom half of the union in the view. The query using the view when loading the page adds the following condition:

   AND trunc(approved_date) >= trunc(sysdate - 40)"

However, the field approved_date in table PO_RELEASES_ARCHIVE_ALL is not indexed; even after adding the index the code is not using it because of the trunc on the condition.

Due to this issue, application is very slow to open the Orders Tab in iSupplier Portal; it takes a minimum of 60 seconds to open the page. 

Steps To Reproduce
1. Log in in to iSupplier as a Supplier user
2. When home page displays, click on orders tab.
3. Observe slow performance when opening.


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.