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 APRIL 24, 2019

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.

Symptoms

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

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.

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
References


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