My Oracle Support Banner

JBO-27122: Sql Error During Statement Preparation In Shopping List When Adding a Category (Doc ID 1400256.1)

Last updated on OCTOBER 10, 2022

Applies to:

Oracle iProcurement - Version 12.0.4 to 12.1.3 [Release 12 to 12.1]
Information in this document applies to any platform.


When adding a category or making any change within any of the content zones defined, the shopping list starts showing error.


oracle.jbo.SQLStmtException: 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

Steps To Reproduce
1. Log in and access iProcurement Catalog Administrator.
2. Make any update in any of the content zones defined.
3. Go to iProcurement.
4. On shopping tab , select Shopping List.
5. Encounter the reported error.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.