Upgrade to 12.0.4 Adwork Fails On Eammsnup.Sql

(Doc ID 559008.1)

Last updated on OCTOBER 27, 2016

Applies to:

Oracle Enterprise Asset Management - Version 12.0.0 and later
Information in this document applies to any platform.


When attempting to UPGRADE FROM 12.0.0 TO 12.0.4 (RUP4) ADWORK FAILS ON EAMMSNUP.SQL
the following error occurs.

ERROR at line 1:
ORA-20000: Error occurred in obtaining transaction type. ORA-01403: no data
foundEncountered an error while upgrading MTL_SERIAL_NUMBERS data. Please
verify the error log table.
ORA-06512: at line 2186


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