Index on the column MTL_MATERIAL_TRANSACTIONS.LAST_UPDATE_DATE missing after upgrade from 12.2.6. (Doc ID 3031131.1)

Last updated on JUNE 25, 2024

Applies to:

Oracle Inventory Management - Version 12.2.11 and later
Information in this document applies to any platform.

On : 12.2.11 version, MICC Transfer to TSC

ACTUAL BEHAVIOR
---------------

Custom report is running longer than usual after upgrading from 12.2.6.

EXPECTED BEHAVIOR
-----------------------
Report used to complete in less than 1 min but now takes 45 mins.

STEPS
-----------------------
Run the custom program, notice performance lag.

	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

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