ORA-01502:Index 'SIEBEL.S_NOTE_BUS_PLAN_P1' Or Partition Of Such Index Is In Unusable State (Doc ID 1921145.1)

Last updated on JULY 12, 2017

Applies to:

Siebel Tools - Version 8.1.1.11 [IP2013] and later
Information in this document applies to any platform.

Symptoms

A custom CLOB extension column was added to the S_NOTE_BUS_PLAN table. 

Then the Apply schema changes were done for this table in Siebel Tools with the Apply button.
At that time, Siebel Tools converted the existing "out of the box" vanilla Long column to a CLOB data type.
This is the expected behavior when adding a custom CLOB column to a table with an existing Long column.

Then when testing creating new records in this business component, Users receive an error message.

An error has occurred writing to a record.

Please continue or ask your systems administrator to check your application configuration if the problem persists.
(SBL-DBC-00111)

ORA-01502: index 'SIEBEL.S_NOTE_BUS_PLAN_P1' or partition of such index is in unusable state

 Error mentioned above is similar to doc 1447276.1

Changes

A custom column extension with data type CLOB was added and applied to a table that already had an "out of the box" or "vanilla" Long column. 

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