Poor Performance When Selecting New Item Request (NIR) Or Change Order (CO) Worklist Notification Detail
Last updated on MAY 03, 2016
Applies to:Oracle Product Hub - Version 12.1.2 and later
Information in this document applies to any platform.
Poor performance when attempting to view Notification
Performance was OK on R12.0.6, but after upgrade to 12.1.2 it takes almost 1-2 minutes.
During navigating to notification detail page, you can see long-running SQL.
The issue can be reproduced at will with the following steps:
Create NIR or CO > go HomePage > select notification on worklist result page
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