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 )

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, 5 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 undefined._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)

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.