Asset Details Page Error JBO-27122

(Doc ID 2039024.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

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


Within a Site and in the Asset details screen you enter an Item Description > Go or click on the Asset number displayed to see the asset details and they give the error:

Oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT *
  csii.organization_name as Vld_Org_Name,
  csiv.VERSION_LABEL as Old_Version_Label,
  csiv.date_time_stamp as Old_Version_Date ,
  csii.SYSTEM_NAME ,
  csii.SYSTEM_ID ,
  decode(csii.SERIAL_NUMBER, NULL, 'N', 'Y') as Serial_Number_Exists,
  csii.LOT_NUMBER ,
  csii.STATUS_NAME ,


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