My Oracle Support Banner

Search for Product Item to Add To Quote Using Brackets in Search String Error: "oracle.apps.fnd.framework.OAException, ORA-20000, DRG-51030 or JBO-27122 When Searching For Items With Brackets" (Doc ID 1288700.1)

Last updated on MARCH 31, 2020

Applies to:

Oracle Quoting - Version 12.0.6 and later
Information in this document applies to any platform.


HTML User Interface

When attempting to search item, the following error occurs.



   oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException:
    JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM
    (SELECT msiv.inventory_item_id    ,msiv.concatenated_segments inventory_item,icis.description,msiv.primary_uom_code
  ## Detail 0 ##
  java.sql.SQLException: ORA-29902: error in executing ODCIIndexStart()
  ORA-20000: Oracle Text error:
  DRG-51030: wildcard query expansion resulted in too many terms


Log File

Eshows error "JBO-27122: SQL error during statement preparation"


Steps to Reproduce

The issue can be reproduced at will with the following steps:

  1. Login to Quoting HTML UI
  2. Create Quote
  3. Search Item which has "()" (brackets) to the end, for example, MAWSOPT(AUDIO)
  4. See that UI returns 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.