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 blogspot.com by Unknown author, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.   Statement: SELECT * FROM (SELECT ca.location LocId, ca.party_site_number LocNumber, ca.party_name PartyName, ca.party_number PartyNumber, ca.address1 Address1
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 5a1630f0-0de2-490c-91db-6d734cee73a4, 8 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_number
from per_grades peg
,per_grade_definitions  pgd
,per_all_assignments_f paf
where pgd.grade_definition_id  = peg.grade_definition_id
and  paf.grade_id  = peg.grade_id
and substr(pgd.segment1 , -3, 3)  =
(select substr(pgd1.segment1 , -3, 3)
from  per_grade_definitions  pgd1 , per_grades  peg1 , per_all_assignments_f paf1
where pgd1.grade_definition_id  = peg1.grade_definition_id
and   paf1.grade_id  = peg1.grade_id
and   paf1.assignment_number =:EmployeeNumber
and   trunc(sysdate) between trunc(effective_start_date) and trunc(effective_end_date) )
union all
select peg.name , paf.assignment_number
from per_grades peg
, per_grade_definitions  pgd
, per_all_assignments_f paf
where pgd.grade_definition_id  = peg.grade_definition_id
and  paf.grade_id  = peg.grade_id
and  substr(pgd.segment1 , -3, 3) != 'New'
and exists  (
select 1
from per_grade_definitions  pgd1
, per_grades  peg1 , per_all_assignments_f paf1
where pgd1.grade_definition_id  = peg1.grade_definition_id
and   paf1.grade_id  = peg1.grade_id
and paf1.assignment_number =:EmployeeNumber
and 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)