EGL 9.2: Upgrade Data Conversion Error - "Table or view does not exist Failed SQL stmt: TRUNCATE TABLE SYSADM.PS_UPG_LEDG_TAO15" (Doc ID 1927338.1)

Last updated on MAY 16, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 and later
Information in this document applies to any platform.
checked for relevance 16-MAY-2016

Symptoms

On : Upgrade to 9.2, Performing Data Conversion Step

After resolving first error below by applying BUG 19144876 conversion script failed again - received second error below

ERRORS
-----------------------
(1)
-- 09.35.48 Process 1164797 ABENDED at Step UPG_GL.GLC05.DttmStmp (Action SQL) -- RC = 1407
ROLLBACK
/
-- 09.35.48 SQL Error: ORA-01407: cannot update ("SYSADM"."PS_JRNLGEN_DEFN"."FIELDNAME_DT_STAMP") to NULL

(2)
After applying BUG 19144876 - conversion script failed again, received second error below

Process 1738853 resumed after step UPG_GL.GLC05.[start] (108,538)

UPG_GL GLC05 completed at 2014-08-26-12.03.44.000000 (274,4)

File: /vob/peopletools/src/psappeng/psaesql.cppSQL error. Stmt #: 2955 Error Position: 22 Return: 942 - ORA-00942: table or view does not exist
Failed SQL stmt: TRUNCATE TABLE SYSADM.PS_UPG_LEDG_TAO15

Temporary Table processing failure during allocation phase. (108,530)

Process 1738853 ABENDED at Step PTIADATACONV.Process.Step010 (Call Section) -- RC = ? (108,524)

Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s

PSAESRV completed service request at 12.03.45 2014-08-26


STEPS
-----------------------
1. Run 9.2 upgrade data conversion


BUSINESS IMPACT
-----------------------
Due to this issue, users cannot complete the upgrade process

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