Cannot Browse Item Catalog, Get Error oracle.jbo.SQLStmtException: JBO-27122 SQL error during statement preparation (Doc ID 1531684.1)

Last updated on MAY 21, 2017

Applies to:

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

Symptoms

When attempting to browse item catalog in Item Advanced Search, the following error occurs.

ERROR
-----------------------
Exception Details.
 oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT DISTINCT
  A.ASSOCIATION_ID ASSOCIATION_ID ,
  A.OBJECT_ID OBJECT_ID ,
  O.OBJ_NAME OBJECT_NAME ,

.... continued


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Switch to Development Manager Responsibility
2. Path: Item > Item Advanced Search
3. At "Select Item Catalog Category" (ICC) field, input problem ICC.
4. Press "Go" button
5. Error Page found

WHAT IS WORKING
-----------------------
For some of the ICCs it is working fine.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms