JBO-27122: Sql Error During Statement Preparation In Shopping List
(Doc ID 562656.1)
Last updated on MARCH 13, 2024
Applies to:
Oracle iProcurement - Version 12.0.0 to 12.2 [Release 12 to 12.2]Information in this document applies to any platform.
Symptoms
When clicking on the Shopping List sub-tab, the following error is displayed:
ERROR:
"JBO-27122: SQL error during statement preparation"
The FND LOG shows the following additional details:
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)
.....
STEPS TO REPRODUCE:
The issue can be reproduced at will with the following steps:
1. Log into iProcurement
2. Open Shopping Lists sub-tab.
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 |