Performance Issue With Grants Portal>Award Summary>Financial - Click On Invoiced Amount Link For One Of The Award

(Doc ID 2196545.1)

Last updated on DECEMBER 30, 2016

Applies to:

PeopleSoft Enterprise FIN Grants - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


On : 9.2 version, Performance

Grants Portal>Award Summary>Financial>Invoiced

When using the Grants Portal >Award Summary - select a contract and do a search. Then go to the Financial tab and select the 'invoiced' link the Grants portal hangs and eventually times out. After doing a trace it seems to be calling a stand alone sql (GM_PT_INV_SUM_SEL) that has 2 full tables scans in it. The user count is in our system is 221.

The Grants Portal pages should return data quickly.

The issue can be reproduced at will with the following steps:
1. Performance issue with Grants Portal>Award Summary>Financial - Click on Invoiced Amount link for one of the Award


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