Script EAMSNUPD.SQL In R12 Upgrade Performance Issue (Doc ID 564965.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Enterprise Asset Management - Version 12.0.0 to 12.1.3 [Release 12 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 20-Mar-2013***


Symptoms

This issue can occur when upgrading from previous versions to R12: Script eamsnupd.sql takes near to one hour in the R12 upgrade run off driver u4440000.drv
Same issue will occur also  if you use 12.0.0 + RUP4 or you use the new CD techstack 12.0.4 with driver u6394500.drv

Solution in this Note is applicable for both these cases.

.

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