oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT csm.ship_method_code, csm.enabled_flag, fl.enabled_flag lookup_Enabled_Flag, fl.meaning FROM wsh_carrier_ship_methods csm, fnd_lookup_values fl WHERE fl.lookup_type = :1 AND fl.lookup_code = csm.ship_method_code AND fl.view_application_id = :2 AND nvl(fl.start_date_active, sysdate) <= sysdate AND nvl(fl.end_date_active, sysdate) >= sysdate AND fl.language = USERENV('LANG') AND fl.enabled_flag = :3 AND csm.enabled_flag = :4 AND csm.organization_id = :5) QRSLT ORDER BY meaning

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 amit.kochar-Oracle, 1 year ago
, fnd_lookup_values fl WHERE fl.lookup_type = :1 AND fl.lookup_code = csm.ship_method_code AND fl.view_application_id = :2 AND nvl(fl.start_date_active, sysdate) <= sysdate AND nvl(fl.end_date_active, sysdate) >= sysdate AND fl.language = USERENV('LANG') AND fl.enabled_flag = :3 AND csm.enabled_flag = :4 AND csm.organization_id = :5) QRSLT ORDER BY meaning
via Oracle Community by sseth29, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT lookup_code, meaning FROM fnd_lookup_values WHERE trunc(nvl(start_date_active, SYSDATE)) <= trunc(SYSDATE) AND trunc(nvl(end_date_active, SYSDATE
via Oracle Community by sseth29, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT lookup_code, meaning FROM fnd_lookup_values WHERE trunc(nvl(start_date_active, SYSDATE)) <= trunc(SYSDATE) AND trunc(nvl(end_date_active, SYSDATE
via Oracle Community by 712742, 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 VIEW_APPLICATION_ID = :2 AND LANGUAGE = USERENV('LANG') AND ENABLED_FLAG = 'Y' AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE - 1) AND NVL(END_DATE_ACTIVE, SYSDATE + 1) AND SECURITY_GROUP_ID = 0
via Oracle Community by 745019, 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 VIEW_APPLICATION_ID = :2 AND LANGUAGE = USERENV('LANG') AND ENABLED_FLAG = 'Y' AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE - 1) AND NVL(END_DATE_ACTIVE, SYSDATE + 1) AND SECURITY_GROUP_ID = 0
via Oracle Community by 712742, 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 VIEW_APPLICATION_ID = :2 AND LANGUAGE = USERENV('LANG') AND ENABLED_FLAG = 'Y' AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE - 1) AND NVL(END_DATE_ACTIVE, SYSDATE + 1) AND SECURITY_GROUP_ID = 0
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT csm.ship_method_code, csm.enabled_flag, fl.enabled_flag lookup_Enabled_Flag, fl.meaning FROM wsh_carrier_ship_methods csm, fnd_lookup_values fl WHERE fl.lookup_type = :1 AND fl.lookup_code = csm.ship_method_code AND fl.view_application_id = :2 AND nvl(fl.start_date_active, sysdate) <= sysdate AND nvl(fl.end_date_active, sysdate) >= sysdate AND fl.language = USERENV('LANG') AND fl.enabled_flag = :3 AND csm.enabled_flag = :4 AND csm.organization_id = :5) QRSLT ORDER BY meaning
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1169)
at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:3241)
at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:3036)

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.