Error While Searching Catalog Item - Error: DRG-10599: column is not indexed

(Doc ID 2317295.1)

Last updated on OCTOBER 13, 2017

Applies to:

Oracle iProcurement - Version 12.0.6 and later
Information in this document applies to any platform.

Symptoms

On : 12.0.6 version, Catalog Shopping

When attempting to search an item,
the following error occurs.

ERROR
-----------------------
Exception Details.
 oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM ( SELECT ctxh.ip_category_id ShoppingCategoryId,count(1) ItemCount FROM icx_cat_items_ctx_hdrs_tlp ctxh WHERE contains(ctxh.ctx_desc, :INTERMEDIA_KEY1, 1) > 0 AND ICX_CAT_UTIL_PVT.is_item_valid_for_search( ctxh.source_type, ctxh.po_line_id, ctxh.req_template_name, ctxh.req_template_line_num, ctxh.po_category_id, ctxh.org_id) = 1 AND ctxh.ip_category_id IN( SELECT child_category_id FROM icx_cat_browse_trees icbt, icx_cat_categories_tl icct WHERE icbt.child_category_id = icct.RT_CATEGORY_ID AND icct.TYPE = 2 AND icct.LANGUAGE = :CATALOG_LANG_KEY1) GROUP BY ctxh.ip_category_id) bvoq
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:896)
...........
...........
## Detail 0 ##
java.sql.SQLException: ORA-20000: Oracle Text error:
DRG-10599: column is not indexed


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. IProcurement Responsibility ->
2. Shop Tab -> Stores
3. Search item -> Go
4. Error occurs


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