My Oracle Support Banner

Upgrade From 11.5.10 to 12.2 - MSCSEQUP.sql Has Performance Issue When Running The 12.2 Base Upgrade (Doc ID 2193142.1)

Last updated on APRIL 04, 2025

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

When applying the upgrade patch to move from 11.5.10 to 12.2 base release, we have several reports of long running during execution of SQL file - MSCSEQUP.sql

Customers find that BOM MLOG's used for collections are have many rows and when we execute this SQL file - we are dropping snapshots for ASCP Collection functionality.

Per standard RDBMS functionality - when a snapshot is dropped, the related MLOG table used to refresh that snapshot will have the rows deleted

Since the upgrade process is making many change to BOM tables via execution of file bom10u03.sql, this delete is taking a long time - sometimes several hours or longer depending on the size of customer BOM components table

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
References


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