Error While Searching Catalog Item - Error: DRG-10599: column is not indexed
(Doc ID 2317295.1)
Last updated on MAY 03, 2021
Applies to:
Oracle iProcurement - Version 12.0.6 and laterInformation 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
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
| Symptoms |
| Cause |
| Solution |
| References |