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.

Symptoms

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 *
FROM (
SELECT csii.INSTANCE_ID ,
  csii.INSTANCE_NUMBER ,
  csii.INSTANCE_DESCRIPTION ,
  csii.INVENTORY_ITEM_ID,
  csii.CONCATENATED_SEGMENTS ,
  csii.DESCRIPTION ,
  csii.LAST_VLD_ORGANIZATION_ID ,
  csii.INV_MASTER_ORGANIZATION_ID,
  csii.organization_name as Vld_Org_Name,
  csii.INVENTORY_REVISION ,
  csiv.VERSION_LABEL as Old_Version_Label,
  csiv.date_time_stamp as Old_Version_Date ,
  csii.SYSTEM_NAME ,
  csii.SYSTEM_ID ,
  csii.EXTERNAL_REFERENCE ,
  csii.INSTANCE_TYPE_CODE ,
  csii.ACCOUNTING_CLASS_CODE ,
  csii.SERIAL_NUMBER_CONTROL_CODE ,
  csii.SERIAL_NUMBER ,
  decode(csii.SERIAL_NUMBER, NULL, 'N', 'Y') as Serial_Number_Exists,
  csii.MFG_SERIAL_NUMBER_FLAG ,
  csii.LOT_CONTROL_CODE ,
  csii.LOT_NUMBER ,
  csii.STATUS_NAME ,
  

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