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 )

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web1061

  • via Oracle Community by user444732, 11 months ago
    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 )
  • via Oracle Community by user621385, 1 year ago
    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT paf1.full_name, paf1.last_name, paf1.first_name, paf1.email_address, nvl(paf1.employee_number,paf1.npw_number) AS employee_num
  • via Oracle Community by Avaneesh Jain, 11 months ago
    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select ppf.person_id, ppf.employee_number, god.organization_id, ppf.full_name employee_name, (select full_name from per_people_x where person_id
  • Stack trace

    • 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)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown user
    Once, 10 months ago
    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    14 more bugmates