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 907823, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT flv.lookup_code, flv.lookup_type, flv.meaning FROM fnd_lookup_values_vl flv WHERE lookup_type = 'INL_SHIP_TASKS' AND ENABLED_FLAG = 'Y
via Oracle Community by bmn, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT , ( CASE WHEN pce.attribute1 = 'Y' THEN 1 ELSE 0 END ) is_yes FROM per_all_people_f ppf, per_competences pce WHERE ppf.person_id = pce.person_id (+) AND TRUNC(SYSDATE) BETWEEN ppf.effective_start_date AND NVL(ppf.effective_end_date, SYSDATE) AND ppf.person_id = :1
via Oracle Community by 835862, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT PACKING_UNIT_NUM ,PACKING_UNIT_STATUS ,PO_NUM ,PO_LINE ,PROJECT_NUM ,VENDOR_NAME ,CUSTOMER_PLANT ,ITEM_NUMBER ,PARENT_ITEM ,SUPPLIER_REFERENCE
via Oracle Community by 828271, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT CT_TL.body , AH.doctype_id FROM pon_contracts_tl CT_TL , pon_contracts CT , pon_auction_headers_all AH WHERE CT_TL.language = :1 AND
via Oracle Community by 868733, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select CONSOLIDATION_SUMMARY_ID ,CREATION_DATE ,CREATED_BY ,BATCH_ID ,PROCESS_FLAG ,ERROR_MESSAGE ,CUSTOMER_ID ,BILLING_FREQUENCY
via Oracle Community by Sandeep Oracle, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select (address1 || ',' ||city || ',' || Country ||','||postal_code)address from HZ_ORG_PROFILES_CPUI_V
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT flv.lookup_code, flv.lookup_type, flv.meaning
FROM fnd_lookup_values_vl flv
WHERE lookup_type = 'INL_SHIP_TASKS'
AND ENABLED_FLAG = 'Y'
AND SYSDATE BETWEEN NVL((TRUNC(start_date_active)),SYSDATE) AND
NVL((TRUNC(end_date_active)+.99999)-1,SYSDATE)
AND lookup_code IN ('GENERATE_CHARGE','TAXATION', 'VALIDATION', 'CALCULATION', 'SUBMIT', 'MANAGE_ASSOC',
'MANAGE_CHARGE','SEPARATOR_10', 'VIEW_LANDEDCOST', 'SEPARATOR_20', 'SEPARATOR_30')) QRSLT WHERE (lookup_code NOT IN ( 'SUBMIT')) ORDER BY DECODE(lookup_code, 'GENERATE_CHARGE', 0, DECODE(LOOKUP_CODE, 'TAXATION', 1, DECODE(LOOKUP_CODE, 'SEPARATOR_10', 2, DECODE(LOOKUP_CODE, 'VALIDATION', 3, DECODE(LOOKUP_CODE, 'CALCULATION',4, DECODE(LOOKUP_CODE, 'SUBMIT',5, DECODE(LOOKUP_CODE, 'SEPARATOR_20',6, DECODE(LOOKUP_CODE, 'MANAGE_CHARGE',7, DECODE(LOOKUP_CODE, 'MANAGE_ASSOC',8, DECODE(LOOKUP_CODE, 'SEPARATOR_30', 9, DECODE(LOOKUP_CODE, 'VIEW_LANDEDCOST',10,11)))))))))))	at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:616)	at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)	at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1182)	at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)	at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)	at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)	at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)	at oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353)	at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2607)	at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1786)	at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543)	at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431)