EGL9.2: Performance Issue Using Original Script With SQL "UPDATE PS_JRNL_LN SET ACCOUNT_CODE = ' ' "
(Doc ID 2513722.1)
Last updated on MAY 29, 2019
Applies to:PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
PeopleSoft Enterprise PT PeopleTools - Version 8.55 to 8.55 [Release 8.4]
Information in this document applies to any platform.
While applying 9.2.30, when running an alter script there is one sql statement UPDATE PS_JRNL_LN SET ACCOUNT_CODE = ' ' that is taking hours yet not updating ACCOUNT_CODE = ' ' (space) on about 7 million rows. When tried to run just the update sql statement on database server itself thru sql plus, still no luck. Please let us know how to run the below sql in our FINDEV database so that it completes.
Below excerpt from attached alter script from Image 30:
ALTER TABLE PS_JRNL_LN ADD ACCOUNT_CODE VARCHAR2(20)
UPDATE PS_JRNL_LN SET ACCOUNT_CODE = ' '
ALTER TABLE PS_JRNL_LN MODIFY ACCOUNT_CODE NOT NULL
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