oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT Emp1.EMP_ID, Emp1.CREATION_DATE, Emp1.CREATED_BY, Emp1.LAST_UPDATED_BY, Emp1.LAST_UPDATE_DATE, Emp1.LAST_UPDATE_LOGIN, Emp1.EMP_NAME, Emp1.CITY, Emp1.MGR_CODE, Emp1.DESIGNATION, Emp1.SALARY FROM EMP Emp1 WHERE (( UPPER(Emp1.EMP_NAME) like :2 AND (Emp1.EMP_NAME like :3 OR Emp1.EMP_NAME like :4 OR Emp1.EMP_NAME like :5 OR Emp1.EMP_NAME like :6)))

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 Kaushal Bhati, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT Emp1.EMP_ID, Emp1.CREATION_DATE, Emp1.CREATED_BY, Emp1.LAST_UPDATED_BY, Emp1.LAST_UPDATE_DATE, Emp1.LAST_UPDATE_LOGIN, Emp1.EMP_NAME, Emp1.CITY, Emp1
via Oracle Community by 862079, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select opi.invoice_num ,opi.purchase_orders ,op.payment_num ,opi.amount_paid Amountpaid ,op.check_date paymentDate ,op.check_number
via Oracle Community by 862079, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select opi.invoice_num ,opi.purchase_orders ,op.payment_num ,opi.amount_paid Amountpaid ,op.check_date paymentDate ,op.check_number
via Oracle Community by Myvizhi Selvi, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select f.user_name , f.description , a.currency_code, a.amount_to , a.amount_from from seacds.ar_approval_user_limits_nv a , seacds.fnd_user_nv
via Oracle Community by 839403, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select fu.user_name, ppf.full_name, HR_GENERAL.DECODE_POSITION_LATEST_NAME (paf.POSITION_ID) POSITION_NAME, ppf.email_address from fnd_user fu
via Oracle Community by 680096, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select distinct mc.SEGMENT1||'.'||mc.SEGMENT2 "Comodity" ,poe.SEGMENT_VALUE "Major Account" ,poe.RULE_VALUE_ID ,poe2.segment_value "CC" from
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT Emp1.EMP_ID, Emp1.CREATION_DATE, Emp1.CREATED_BY, Emp1.LAST_UPDATED_BY, Emp1.LAST_UPDATE_DATE, Emp1.LAST_UPDATE_LOGIN, Emp1.EMP_NAME, Emp1.CITY, Emp1.MGR_CODE, Emp1.DESIGNATION, Emp1.SALARY FROM EMP Emp1 WHERE (( UPPER(Emp1.EMP_NAME) like :2 AND (Emp1.EMP_NAME like :3 OR Emp1.EMP_NAME like :4 OR Emp1.EMP_NAME like :5 OR Emp1.EMP_NAME like :6)))
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.OAPageErrorHandler.processErrors(OAPageErrorHandler.java:1408)
at oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:2680)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1683)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:509)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:430)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 2 years 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, 2 years ago
14 more bugmates

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