oracle.apps.fnd.framework.OAException

oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select rowid ,null select_checkbox ,resource_name person ,resource_id resource_id ,person_id person_id ,to_char(optional_competence_match + mandatory_competence_match) || '/' || to_char(optional_competence_count + mandatory_competence_count) competence_match ,optional_competence_match + mandatory_competence_match competence_match_number ,to_char(optional_competence_match) || '/' || to_char(optional_competence_count) optional_competence_match ,optional_competence_match optional_comp_match_number ,to_char(availability) || decode(to_char(availability), NULL, NULL, '%') availability ,availability availability_number ,resource_job_level job_level ,resource_organization_name organization ,DECODE(city, '', country_code, city || ', ' || region || ', ' || country_code) location ,'OA.jsp?akRegionCode=PA_ASSIGN_RESOURCE_LAYOUT&akRegionApplicationId=275&paPersonId='||to_char(person_id) assign_button ,'OA.jsp?akRegionCode=PA_OPEN_ASMT_DETAILS_LAYOUT&akRegionApplicationId=275&paAssignmentId='||to_char(assignment_id) reference_number ,project_id project_id ,project_name||'('||project_number||')' project_name_number ,assignment_name assignment_name ,assignment_id assignment_id ,assignment_start_date start_date ,assignment_end_date end_date ,PA_CANDIDATE_UTILS.Get_Active_Candidates_Number(assignment_id) candidate_number ,assignment_number assignment_number ,decode(candidate_in_req_flag,'Y','Y','N') candidate_in_req_flag ,mandatory_competence_match mandatory_competence_match ,mandatory_competence_count mandatory_competence_count ,candidate_score candidate_score ,to_char(potential_availability) || decode(to_char(potential_availability), NULL, NULL, '%') potential_availability ,potential_availability potential_availability_num ,resource_email resource_email ,resource_manager resource_manager from pa_search_results_temp) QRSLT WHERE (MANDATORY_COMPETENCE_COUNT=MANDATORY_COMPETENCE_MATCH AND AVAILABILITY_NUMBER >= :1 and custom_indicator = 1 and (OPTIONAL_COMPETENCE_COUNT=0 or optional_comp_match_number>0))

Samebug tips0

We couldn't find tips for this exception.

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

Solutions on the web1658

  • via Unknown by Praveen.oatc,
  • Stack trace

    • oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select rowid ,null select_checkbox ,resource_name person ,resource_id resource_id ,person_id person_id ,to_char(optional_competence_match + mandatory_competence_match) || '/' || to_char(optional_competence_count + mandatory_competence_count) competence_match ,optional_competence_match + mandatory_competence_match competence_match_number ,to_char(optional_competence_match) || '/' || to_char(optional_competence_count) optional_competence_match ,optional_competence_match optional_comp_match_number ,to_char(availability) || decode(to_char(availability), NULL, NULL, '%') availability ,availability availability_number ,resource_job_level job_level ,resource_organization_name organization ,DECODE(city, '', country_code, city || ', ' || region || ', ' || country_code) location ,'OA.jsp?akRegionCode=PA_ASSIGN_RESOURCE_LAYOUT&akRegionApplicationId=275&paPersonId='||to_char(person_id) assign_button ,'OA.jsp?akRegionCode=PA_OPEN_ASMT_DETAILS_LAYOUT&akRegionApplicationId=275&paAssignmentId='||to_char(assignment_id) reference_number ,project_id project_id ,project_name||'('||project_number||')' project_name_number ,assignment_name assignment_name ,assignment_id assignment_id ,assignment_start_date start_date ,assignment_end_date end_date ,PA_CANDIDATE_UTILS.Get_Active_Candidates_Number(assignment_id) candidate_number ,assignment_number assignment_number ,decode(candidate_in_req_flag,'Y','Y','N') candidate_in_req_flag ,mandatory_competence_match mandatory_competence_match ,mandatory_competence_count mandatory_competence_count ,candidate_score candidate_score ,to_char(potential_availability) || decode(to_char(potential_availability), NULL, NULL, '%') potential_availability ,potential_availability potential_availability_num ,resource_email resource_email ,resource_manager resource_manager from pa_search_results_temp) QRSLT WHERE (MANDATORY_COMPETENCE_COUNT=MANDATORY_COMPETENCE_MATCH AND AVAILABILITY_NUMBER >= :1 and custom_indicator = 1 and (OPTIONAL_COMPETENCE_COUNT=0 or optional_comp_match_number>0)) at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:616) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252) at oracle.apps.fnd.framework.webui.beans.layout.OAHeaderBean.processRequest(OAHeaderBean.java:391) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252) at oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252) at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1182) at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252) at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252) at oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353) at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2607) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1940) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431) 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.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:713) at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370) at com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:259) at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:51) at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:193) at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:284) at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:198) at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:395) at _OA._jspService(_OA.java:221) 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:871) 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 visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    14 more bugmates