R12.1.1 Upgrade - Performance Issue - CSTMTAUPG.SQL script (Doc ID 1435439.1)

Last updated on JUNE 23, 2017

Applies to:

Oracle Cost Management - Version 12.1.1 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.1 version, Install or Patch Issues

ACTUAL BEHAVIOR
----------------------
Find that when upgrading from 11.5.10.2 to R 12.1.1 , the execution of cstmtaupg.sql was running for almost 4 hours and was impacting the total duration to complete the R12 upgrade process


EXPECTED BEHAVIOR
-----------------------
To improve performance in running cstmtaupg.sql and complete the process in an acceptable time that will not affect the R12.1.1 upgrade process


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run cstmtaupg.sql as part of the R12.1.1 upgrade process

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