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))

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Oracle Community by AnilA, 1 year ago
, ('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))
via Oracle Community by sreese, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select distinct meaning , attribute4 from splwms.so_lookups where lookup_type = 'SHIPMENT_PRIORITY' and enabled_flag = 'Y' and attribute4 = :Carrier order by meaning
via Oracle Community by 818948, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT GANTT_VIEW_ID ,NAME FROM PA_GANTT_VIEWS_VL where ENABLE_FLAG ='Y' and GANTT_VIEW_USAGE = ?
via Oracle Community by 452203, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT DISTINCT MAKE,YEAR FROM XXXXX_ICUST_ABC_YMM_LOV1 WHERE YEAR=:1
via Oracle Community by user10816003, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT asb.status_code, ast.meaning FROM apps.as_statuses_b asb, apps.as_statuses_tl ast WHERE asb.status_code=:1 AND ast.language= userenv('LANG') AND asb.enabled_flag = 'Y' AND asb.opp_flag = 'Y' AND asb.opp_open_status_flag = 'Y' and asb.status_code = ast.status_code
via Oracle Community by User338888, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select lookup_code, meaning from fnd_lookup_values where lookup_type = :1 and language = :2 and (lookup_code = 'EXPENSE' OR (lookup_code = 'INVENTORY' AND :3 = 'Y') OR (lookup_code = 'SHOP FLOOR' AND :4 = 'Y')) order by meaning asc
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

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
9 more bugmates

Know the solutions? Share your knowledge to help other developers to debug faster.