EGM - How To Resolve Data Integrity Problems (Reset) If GM_GMFACS Fails (Doc ID 660958.1)

Last updated on APRIL 06, 2016

Applies to:

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

Symptoms

GM_GMFACS failed in production during the Cobol budget checking step due to a time-out and therefore was unable to rollback all data.  The process restarted and ran to completion but 193 rows remained in the KK_SOURCE_HDR table with a KK_PROCESS_STATUS of "I".  72 rows were processed successfully resulting in SFA rows in PROJ_RESOURCE and commitment control updates in KK_ACTIVITY_LOG and journal generation of the SFA amounts. Manual rollback of all updates done by the processes is therefore not feasible.

.

Cause

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