My Oracle Support Banner

Performance Issue While Applying Upgrade Patches - invupginv.sql Runs Very Long Due To Huge Volume Of Records In MTL_MATERIAL_TRANSACTIONS (Doc ID 1131215.1)

Last updated on MAY 16, 2022

Applies to:

Oracle Inventory Management - Version 11.5.10.2 to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.

Symptoms

Performance issue while applying Patch 9265857 (RUP19), invupginv.sql  is running for more than 14hrs.
May also occur with Patch 8478486, Patch 7303033 or other RUP Patches or when performing application upgrades.

Steps

Apply patch and see bad performance when running invupginv.sql.

Slow SQL is:

Changes

 

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
Changes
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.