My Oracle Support Banner

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
 1.- Modify existing Index on MTL_TRANSACTION_ACCOUNTS Table
 2.- Purge / Archive some CST Tables
 3.- Other action to be considered
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.