Error JBO-27122 When Clicking On Shopping List (Doc ID 1557400.1)

Last updated on MAY 25, 2016

Applies to:

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

Symptoms

When Clicking on Shopping List in iProcurement,  users encounter an error.
Due to this issue, users cannot use "Shopping List" to create requisitions


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
...
...
Debug Log shows exception ORA-29908: missing primary invocation for ancillary

 

Steps To Reproduce
1. Log in and access iProcurement.
2. Click on "Shopping List".
3. Get the JBO-27122 error.

 


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