oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT Approval_status FROM APPS.HXC_TIMECARD_SUMMARY WHERE RESOURCE_ID like NVL(:1,RESOURCE_ID) and start_time = NVL(:2,start_time) and stop_time =NVL(:3,stop_time)

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 Sukanya C U, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT Approval_status FROM APPS.HXC_TIMECARD_SUMMARY WHERE RESOURCE_ID like NVL(:1,RESOURCE_ID) and start_time = NVL(:2,start_time) and stop_time =NVL(:3,stop_time)
via blogspot.com by Unknown author, 2 years ago
oracle.jbo.RowNotFoundException: JBO-25060: Unexpected error encountered while trying to retrieve the next row from JDBC ResultSet for collection OAExportHelper_SecondRowSet
via apps2fusion.com by Unknown author, 1 year ago
oracle.jbo.RowCreateException: JBO-25017: Error while creating a new entity row for TMP_EMP_OAF_EO.
via Oracle Community by 2973180, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select oos.name, oos.description, mcv.segment3 "DefaultSourceFlag" from oe_order_sources oos , mtl_categories_v mcv , fnd_responsibility_tl frt WHERE
via Oracle Community by e630688d-de97-43ea-9d13-8a33fc0641df, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select ename from scott.emp) QRSLT WHERE (DEPTNO=:1)
via Oracle Community by Shahzad.H.Magsi, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT SEHA_CW_PERSONAL_INFO_EO.CW_PERSON_ID, SEHA_CW_PERSONAL_INFO_EO.CW_NUMBER, SEHA_CW_PERSONAL_INFO_EO.CREATOR_BG_ID
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT Approval_status FROM APPS.HXC_TIMECARD_SUMMARY WHERE RESOURCE_ID like NVL(:1,RESOURCE_ID) and start_time = NVL(:2,start_time) and stop_time =NVL(:3,stop_time)
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:2704)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1707)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:511)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:432)
at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:56)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:317)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:465)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:379)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:727)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:306)
at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:767)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:259)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:106)
at java.lang.Thread.run(Thread.java:534)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 week 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

Write tip

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