My Oracle Support Banner

12.2 "iStore Search Insert" Errors: ORA-00953: missing or invalid index name ORA-06512: at APPS.IBE_SEARCH_SETUP_PVT (Doc ID 1671997.1)

Last updated on MAY 10, 2022

Applies to:

Oracle iStore - Version 12.2.3 to 12.2.4 [Release 12.2]
Information in this document applies to any platform.


iStore Search Insert Concurrent Program fails with the following error in the concurrent request log,

ORACLE error 953 in FDPSTP

Cause: FDPSTP failed due to ORA-00953: missing or invalid index name
ORA-06512: at "APPS.IBE_SEARCH_SETUP_PVT", line 663
ORA-06512: at line 1

The issue can be reproduced at will with the following steps:
1. Login to EBS with iStore Administrator responsibility
2. Submit "iStore Search Insert" concurrent program
3. Note that program errors

The issue has the following business impact:
Due to this issue, unable to search and add any products in Quoting because Quoting requires this program to complete successfully.


If Quoting user attempts to add a product to a quote, the following error is displayed:
"ORA-20000: Oracle Text error: DRG-10599: column is not indexed FRM-40502: ORACLE error: unable to read list of values."



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

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