EGL: 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 JULY 15, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

CUSTOMER ENVIRONMENT
=======================
Application version 9.2
Image 10
Tools 8.53

Database Production upgrade 9.1 to 9.2

ISSUE/ERROR
=============
We are upgrading from Psoft FSCM 9.1 to 9.2. The data conversion in both initial pass and 2nd pass ran for over 12 hours. We noticed 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 = ' '

We have all bugs covered and we have all fixes for those bugs applied but still these updates took way too long.

Since these tables are altered before data conversion, 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?



BUSINESS IMPACT
================
Performance during data conversion

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