My Oracle Support Banner

After Item Search - Click Item For More Details Throws Error JBO-27122 - Missing Defines (Doc ID 2693083.1)

Last updated on JULY 21, 2020

Applies to:

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

Symptoms

On : 12.2.8 version, Item Catalog

When an item is searched and clicked for more details below error is observed

ERROR
-----------------------

Error Page
Exception Details.
 oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT
  egoag.APPLICATION_ID,
  egoag.descriptive_flexfield_name AS ATTR_GROUP_TYPE,
  egoag.descriptive_flex_context_code AS ATTR_GROUP_NAME,
  egoag.ATTR_GROUP_ID,
  (SELECT func.function_name
  FROM fnd_form_functions func, ego_attr_group_dl ag_dl
  WHERE func.function_id = ag_dl.view_privilege_id
  AND ag_dl.attr_group_id = egoag.attr_group_id
  AND ag_dl.data_level_id = assoc.data_level_id
  ) AS VIEW_PRIVILEGE_NAME,
  (SELECT func.function_name
  FROM fnd_form_functions func, ego_attr_group_dl ag_dl
  WHERE func.function_id = ag_dl.edit_privilege_id
  AND ag_dl.attr_group_id = egoag.attr_group_id
  AND ag_dl.data_level_id = assoc.data_level_id
  ) AS EDIT_PRIVILEGE_NAME,
  pgb.PAGE_ID,
  egoag.multi_row as MULTI_ROW_CODE,
  egoag.BUSINESS_EVENT_FLAG,
  pgb.OBJECT_ID,
  pgb.CLASSIFICATION_CODE,
  (SELECT descriptive_flex_context_name
  FROM fnd_descr_flex_contexts_tl
  WHERE application_id = egoag.application_id
  AND descriptive_flexfield_name = egoag.descriptive_flexfield_name
  AND descriptive_flex_context_code = egoag.descriptive_flex_context_code
  AND language = USERENV('LANG')
  ) as ATTR_GROUP_DISP_NAME,
  pgb.data_level as DATA_LEVEL_INT_NAME
FROM
  EGO_FND_DSC_FLX_CTX_EXT egoag,
  EGO_PAGES_B pgb,
  EGO_PAGE_ENTRIES_B peb,
  EGO_OBJ_AG_ASSOCS_B assoc
WHERE pgb.page_id = peb.page_id
  AND peb.association_id = assoc.association_id
  AND assoc.attr_group_id = egoag.attr_group_id) QRSLT WHERE (PAGE_ID = :1)
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:886)
.....................
## Detail 0 ##
java.sql.SQLException: Missing defines
at oracle.jdbc.driver.OracleStatement.checkAccessorsUsable(OracleStatement.java:1229)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1268)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1441)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3823)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1671)
at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:135)
at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:860)
at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:669)
at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:3754)
at oracle.jbo.server.OAJboViewObjectImpl.executeQueryForCollection(Unknown Source)
at oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQueryForCollection(OAViewObjectImpl.java:4602)
at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:751)
at oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java:900)
at oracle.jbo.server.ViewRowSetImpl.executeQueryForMode(ViewRowSetImpl.java:814)
at oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java:808)
at oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java:3674)
at oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQuery(OAViewObjectImpl.java:441)
at oracle.apps.ego.extfwk.user.presentation.server.EgoExtFwkAMImpl.getSecuredPageLinks(EgoExtFwkAMImpl.java:819)
at oracle.apps.ego.extfwk.user.presentation.server.EgoExtFwkAMImpl.getPageLinks(EgoExtFwkAMImpl.java:791)STEPS
-----------------------

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

1) Navigate to Development Manager -> Item Catalog -> Item Simple Search
2) Search for an item
3) On the results - click on Hyperlink of Item
Above error is reported


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


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