6660348_psur.Sql Contains Hardcoded Schema Name (Doc ID 866693.1)

Last updated on AUGUST 02, 2009

Applies to:

Adverse Event Reporting System - Version: 4.5.2.34
Information in this document applies to any platform.

Goal

Installing Oracle AERS_4.5.2.47 ipatch per <<Bug 6660400>>

But found failing to install since schema name 'AERS1' is hardcoded
in script: 6660348_psur.sql.

Customer's AERS schema name is other than 'AERS1' so script is failing and logs show the following:


Insert into aers1.CODE_LISTS
*
ERROR at line 1:
ORA-00942: table or view does not exist


Insert into aers1.CODE_LIST_DTLS
*
ERROR at line 1:
ORA-00942: table or view does not exist


Insert into aers1.CODE_LIST_DTLS
*
ERROR at line 1:
ORA-00942: table or view does not exist


Insert into aers1.parameters
*
ERROR at line 1:
ORA-00942: table or view does not exist


Insert into aers1.program_parameters
*
ERROR at line 1:
ORA-00942: table or view does not exist


Solution

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