My Oracle Support Banner

JBO-27122 Exception Error When Searched With Single Quote in Show Filter Attributes (Doc ID 2603450.1)

Last updated on SEPTEMBER 07, 2021

Applies to:

Oracle Product Hub - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

 

Exception error in search functionality given in 'Show Filter' in Item User Defined Attributes page(UDA)
If user enters single quote in number attribute on filter criteria in user defined attributes page(UDA) and click on Apply button then getting an exception.


ERROR
-----------------------
Error Page Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during
statement preparation.  Statement: SELECT * FROM (select * from ( SELECT * FROM ( SELECT  
ET.EXTENSION_ID  ,ET.DATA_LEVEL_ID , ET.N_EXT_ATTR1 NExtAttr1, ET.C_EXT_ATTR1
CExtAttr1, NVL( ( SELECT  av2.flex_value_meaning  FROM FND_FLEX_VALUES_VL av2 WHERE
av2.flex_value_set_id = 1021904 AND av2.flex_value = E..........




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Development Manager > Item Catalog > Item Simple Search > Search with Item which has User Defined Attributes page(UDA)
2. Click on Item Details hyperlink
3. On the left hand side menu of item details page, click on any of item page which has User Defined Attributes group attached
4. On UDA page, click on 'Show Filter' menu
5. Enter single quote in number attribute on filter criteria
6. Click on Apply button
7. See exception error




Changes

 

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
Changes
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.