EGL9.2: Missing Default Value Of "0" On LEDGER And Some Other Records Lead To Performance Issue On Step=UPG_GL.GLC01 Runs In FSCM 9.1 To 9.2 Upgrade
(Doc ID 1981662.1)
Last updated on APRIL 16, 2021
Applies to:PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
While upgrading from Psoft FSCM 9.1 to 9.2 data conversion in both initial pass and 2nd pass ran for over 12 hours. It spent most of those hours in these steps that update DATE_CODE to 0:
UPDATE %Table(LEDGER_BUDG) SET DATE_CODE = '0'
UPDATE PS_LEDGER SET DATE_CODE = '0' WHERE DATE_CODE = ' '
Is it possible to alter and update that field to 0 before data conversion and mark these steps complete in the data conversion application engine ?
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