My Oracle Support Banner

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

Last updated on FEBRUARY 05, 2019

Applies to:

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

Symptoms

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


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.