Financials for India - EBS (MOSC)

MOSC Banner

iprocurement shoppinglist getting error

edited Jun 20, 2017 5:00AM in Financials for India - EBS (MOSC) 1 commentAnswered

Error description:-

JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM ( SELECT bq.relevance_score Relevance,bq.inventory_item_id INVENTORY_ITEM_ID,msikfv.organization_id ORGANIZATION_ID,bq.un_number UN_NUMBER,bq.hazard_class HAZARD_CLASS,'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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center