ICXR12PD.Sql Runs Slowly During Upgrade to 12.1.1
Last updated on DECEMBER 23, 2014
Applies to:Oracle iProcurement - Version 12.1.1 and later
Information in this document applies to any platform.
With E-Business Suite 188.8.131.52 and RDBMS 184.108.40.206, while upgrading to R12.1.1 the script
icxr12pd.sql version 120.3 has been running for 16 hours and still has not completed.
The following steps from the UPGRADE manual were followed:
The instance has 11i.AD.I.6 Minipack applied.
The conversion to OATM is done.
The mandatory step "Gather schema statistics for CBO" is done before starting the upgrade driver. ICXVPPDB.pls is at the latest version.
The script is still showing slow performance and taking a very long time to complete
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms