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 APRIL 19, 2016

Applies to:

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

Symptoms

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

ERROR
-----------------------
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

STEPS
-----------------------
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

BUSINESS IMPACT
-----------------------
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."

 

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