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 user444732, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select peg.name , paf.assignment_number from per_grades peg ,per_grade_definitions pgd ,per_all_assignments_f paf where pgd.grade_definition_id
via Oracle Community by 1761829, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT pos.position_id position_id ,business_group_id ,date_effective ,date_end ,postl.name name ,job_id ,organization_id ,NULL effective_date
via Oracle Community by user632699, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select 'N' as select1, substr(:1,1,15) as Site_Name, organization_id, name,:2 as Site_Name_Display from hr_operating_units WHERE mo_global.check_access(organization_id) = 'Y') QRSLT ORDER BY name
via Oracle Community by 3521229, 10 months ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: Select ItemDescription, ItemNumber, ProductNumber, SerialNumber, null LotNumber, SystemName, null ExternalReference, InstanceStatusName, Quantity, OwnerName
via Oracle Community by ORA_USER1122, 1 year ago
oracle.jbo.DeadViewRowAccessException: JBO-27102: Attempt to access dead view row of persistent id 0
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select peg.name , paf.assignment_numberfrom per_grades peg,per_grade_definitions pgd,per_all_assignments_f pafwhere pgd.grade_definition_id = peg.grade_definition_idand paf.grade_id = peg.grade_idand substr(pgd.segment1 , -3, 3) =(select substr(pgd1.segment1 , -3, 3)from per_grade_definitions pgd1 , per_grades peg1 , per_all_assignments_f paf1where pgd1.grade_definition_id = peg1.grade_definition_idand paf1.grade_id = peg1.grade_idand paf1.assignment_number =:EmployeeNumberand trunc(sysdate) between trunc(effective_start_date) and trunc(effective_end_date) )union allselect peg.name , paf.assignment_numberfrom per_grades peg, per_grade_definitions pgd, per_all_assignments_f pafwhere pgd.grade_definition_id = peg.grade_definition_idand paf.grade_id = peg.grade_idand substr(pgd.segment1 , -3, 3) != 'New'and exists (select 1from per_grade_definitions pgd1, per_grades peg1 , per_all_assignments_f paf1where pgd1.grade_definition_id = peg1.grade_definition_idand paf1.grade_id = peg1.grade_idand paf1.assignment_number =:EmployeeNumberand substr(pgd1.segment1 , -3, 3) != 'New'and trunc(sysdate) between trunc(effective_start_date) and trunc(effective_end_date)and rownum < 10 ) 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.OAPageErrorHandler.processErrors(OAPageErrorHandler.java:1435) at oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:3000) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1884) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:549) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:437) at _OA._jspService(_OA.java:212) at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59) at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:379) at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594) at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64) at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26) at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15) at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318) at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:621) at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370) at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:889) at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453) at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:313) at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199) at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260) at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303) at java.lang.Thread.run(Thread.java:619)