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 OCTOBER 17, 2016

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

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