My Oracle Support Banner

Unusable Indexes In OE/OM Module (Doc ID 2410740.1)

Last updated on JUNE 13, 2018

Applies to:

Oracle Order Management - Version 12.0.1 to 12.2.7 [Release 12.0 to 12.2]
Information in this document applies to any platform.

Symptoms

On : 12.1.0.2 version, Order Management

ACTUAL BEHAVIOR
---------------
Unusable Index in OE/OM module

We are on EBS 12.2.4. Database version 12.1.0.2.

We have  Unusable Indexes in OE module.   We are planning to drop these indexes. Please suggest.
Indexes are

OE SO_HOLD_RELEASES_N1
OE SO_HOLD_RELEASES_N2 
OE SO_HOLD_RELEASES_U1 
OE SO_OBJECTS_U3 NORMAL
OE SO_OBJECTS_U1 NORMAL
OE SO_OBJECTS_U2 NORMAL 
OE SO_STANDARD_VALUE_RULE_SETS_U2 
OE SO_STANDARD_VALUE_RULE_SETS_U1 
OE SO_HOLD_SOURCES_N2 
OE SO_HOLD_SOURCES_N1 
OE SO_HOLD_SOURCES_U1

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!


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