ELM 9.0 to ELM 9.2 Upgrade, Rename Script Missing Resulting in Error: "ORA-00942: Table or View Does Not Exist" (Doc ID 1601501.1)

Last updated on JANUARY 17, 2016

Applies to:

PeopleSoft Enterprise ELS Enterprise Learning Management - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When upgrading from ELM 9.0 to ELM 9.2, receive SQL error in AE UPG_LM_OBJ.LdMaster.Step01

Or in Procedure sp_rename, receive Error: The new name 'PS_UPG_ADHCEQV_TBL' is already in use as a object name and would cause a duplicate that is not permitted.

Steps to Replicate Issue:
1) Login as System User
2) Run the Data Conversion Program UPG_LM90


Error :
 
ORA-00942: table or view does not exist
Failed SQL stmt: INSERT INTO PS_LM_RTNG_MDL_TBL ( LM_RATING_MODEL ,EFFDT ,EFF_STATUS ,DESCR ,DESCRSHORT ,LM_EXT_RTNGMDL ,LM_END_EFFDT ) SELECT LM_RATING_MODEL ,EFFDT ,EFF_STATUS ,DESCR ,DESCRSHORT ,LM_EXT_RTNGMDL ,LM_END_EFFDT FROM PS_UPG_RTNGMDL_TBL

Or

sp_rename PS_LM_ADHC_EQV_TBL, PS_UPG_ADHCEQV_TBL
Procedure sp_rename, 
Error: The new name 'PS_UPG_ADHCEQV_TBL' is already in use as a object name and would cause a duplicate that is not permitted.

Or

[Microsoft][SQL Server Native Client 10.0][SQL Server] 
 Invalid object name 'PS_UPG_RTNGMDL_TBL'.  
 Failed SQL stmt: INSERT INTO PS_LM_RTNG_MDL_TBL ( LM_RATING_MODEL ,EFFDT ,EFF_STATUS ,DESCR ,DESCRSHORT ,LM_EXT_RTNGMDL ,LM_END_EFFDT ) SELECT 
 LM_RATING_MODEL ,EFFDT ,EFF_STATUS ,DESCR ,DESCRSHORT ,LM_EXT_RTNGMDL ,LM_END_EFFDT FROM PS_UPG_RTNGMDL_TBL   
 Process..... ABENDED at Step UPG_LM_OBJ.LdMaster.Step01 (SQL) -- RC = 601 
 (108,524)

 

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