oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT DISTINCT X.CL_LOOKUP_ID, X.CL_LOOKUP_ORDER, X.CL_LOOKUP_DETAIL_ID, (X.CL_LOOKUP_ORDER || ' - ' || X.CL_DESC) CODEDESC, ('RenderDisableSub') RENDER_ENABLED, XCS.VESSEL_ID, XCS.CL_SURVEY_TYPE_ID, XCS.CL_PERIOD_ID, XCS.SURVEY_REPORT_ID, XCS.SURVEY_ID, 'N' DETAIL_YES FROM XXDENIZ.XXDP_CL_LOOKUP_VALUES_DETAIL X, XXDENIZ.XXDP_CL_SURVEY XCS, XXDENIZ.XXDP_CL_SETUP XC WHERE X.ENABLED = 'Y' AND XC.CL_SETUP_ID = XCS.CL_SETUP_ID AND X.CL_LOOKUP_DETAIL_ID = XC.CL_LOOKUP_DETAIL_ID) QRSLT WHERE ((:1 = CL_LOOKUP_ID))

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • View Link Invalid Number
    via by AnilA,
  • Number formatting issue
    via by 489141,
    • oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT DISTINCT X.CL_LOOKUP_ID, X.CL_LOOKUP_ORDER, X.CL_LOOKUP_DETAIL_ID, (X.CL_LOOKUP_ORDER || ' - ' || X.CL_DESC) CODEDESC, ('RenderDisableSub') RENDER_ENABLED, XCS.VESSEL_ID, XCS.CL_SURVEY_TYPE_ID, XCS.CL_PERIOD_ID, XCS.SURVEY_REPORT_ID, XCS.SURVEY_ID, 'N' DETAIL_YES FROM XXDENIZ.XXDP_CL_LOOKUP_VALUES_DETAIL X, XXDENIZ.XXDP_CL_SURVEY XCS, XXDENIZ.XXDP_CL_SETUP XC WHERE X.ENABLED = 'Y' AND XC.CL_SETUP_ID = XCS.CL_SETUP_ID AND X.CL_LOOKUP_DETAIL_ID = XC.CL_LOOKUP_DETAIL_ID) QRSLT WHERE ((:1 = CL_LOOKUP_ID)) at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:891) at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1145) at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:2970) at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:2767)

    Users with the same issue

    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    9 more bugmates