Performance Issue With GM_GMFACS at FS_BP_ATAO.iActTAO.iActTAO (Doc ID 2099523.1)

Last updated on MARCH 09, 2017

Applies to:

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

Goal

While testing a PeopleTools 8.52.09 to 8.54.15 upgrade as well as an Oracle DB upgrade from 11g to 12c, the F&A process, GM_GMFACS, took almost 7 hours to process 3832 rows. Of that, almost 6 hours was spent executing step FS_BP_ATAO.iActTAO.iActTAO.
 

Solution

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