Apply patch failed with ORA-01502: index 'BOM.BOM_DELETE_SQL_STATEMENTS_U1' (Doc ID 1939425.1)

Last updated on MAY 12, 2016

Applies to:

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

Symptoms

On : 12.1.3 version, Other Inventory Issues

When attempting to apply patch 14555362, got following error in the log:

ERROR
-----------------------
Dumped the batch (BOM_DELETE_SQL_STATEMENTS ITM_DEL1 , BOM_DELETE_SQL_STATEMENTS ITM_DEL111 ) into FND_SEED_STAGE_ENTITY
Uploading from staging tables
Error loading seed data for BOM_DELETE_SQL_STATEMENTS: SQL_STATEMENT_NAME = ITM_DEL111, ORA-01502: index 'BOM.BOM_DELETE_SQL_STATEMENTS_U1' or partition of such index is in unusable state
ORA-01403: no data found

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply patch 14555362
2. Check the log file.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot apply patch 14555362

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