+6

Has anyone experienced the following error in iProcurement when you select a Category to view the Items:

Error

JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM ( SELECT bq.relevance_score Relevance,'l#' || bq.inventory_item_id || '#' || bq.po_line_id ||'#' || bq.req_template_name || '#' ||bq.req_template_line_num || '#' || :ORG_ID_KEY1 ItemKey,bq.source_type SourceType,DECODE(bq.source_type,'TEMPLATE',decode(least(length(bq.req_template_name) , 20),20,substr(bq.req_template_name,1,17) ||'...',bq.req_template_name),'INTERNAL_TEMPLATE',decode(least(length(bq.req_template_name) , 20),20,substr(bq.req_template_name,1,17) ||'...',bq.req_template_name),'QUOTATION',ICX_CAT_UTIL_PVT.get_message('ICX_CAT_QUOTATION_SOURCE','NUMBER',bq.document_number) ,'BLANKET',ICX_CAT_UTIL_PVT.get_message('ICX_CAT_BLANKET_SOURCE','NUMBER',bq.document_number),'GLOBAL_BLANKET',ICX_CAT_UTIL_PVT.get_message('ICX_CAT_BLANKET_SOURCE','NUMBER',bq.document_number), null) SOURCE,bq.inventory_item_id ItemId,nvl(avtlp.description, bq.description) DESCRIPTION,DECODE(LEAST(LENGTH(decode(1,1, nvl(avtlp.description, bq.description))),25), 25, SUBSTR(decode(1,1, nvl(avtlp.description, bq.description)),1, 22)||'...', decode(1,1, nvl(avtlp.description, bq.description))) TruncatedDescription,avtlp.long_description LONG_DESCRIPTION,DECODE(LEAST(LENGTH(avtlp.long_description), 180), 180, SUBSTR(avtlp.long_description, 1, 177)||'...', avtlp.long_description) TruncatedLongDescription,msikfv.concatenated_segments INTERNAL_ITEM_NUM,decode(bq.item_revision, '-2', to_char(null), bq.item_revision) ITEM_REVISION,bq.po_header_id PoHeaderId,decode(bq.merged_source_type, 'REQ_TEMPLATE',NVL(bq.req_template_po_line_id,-2), bq.po_line_id) PoLineId,bq.document_number DocumentNumber,bq.line_num DocumentLineNumber,bq.req_template_name ReqTemplateName,bq.req_template_line_num ReqTemplateLineNum,decode(bq.order_type_lookup_code, 'AMOUNT', 1, decode(bq.allow_price_override_flag, 'Y', 1, 0)) AllowPriceOverrideFlag,bq.not_to_exceed_price AmountLimit,decode(bq.order_type_lookup_code, 'FIXED PRICE', 1, 0) IsFixedPrice,decode(bq.order_type_lookup_code, 'QUANTITY', 0, 1) IsFixedPriceOrAmountBased,decode(bq.order_type_lookup_code, 'AMOUNT', 0, decode(bq.allow_price_override_flag, 'Y', 0, 1)) IsAmountReadOnly,decode(bq.order_type_lookup_code,