My Oracle Support Banner

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.

Symptoms

Issue:
-------

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
*************

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.