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

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 Praveen.oatc, 1 year ago
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
via Oracle Community by user635152, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT NOTIFICATION_ID , COMPANY , PAYGROUP , SOURCE , INITIATOR , SUPPLIER_NAME , TRX_DATE FROM LMG_NOTIFICATION_V WHERE COMPANY = NVL(:1,COMPANY) AND INITIATOR = NVL(:2,INITIATOR) AND PAYGROUP = NVL(:3,PAYGROUP) AND SOURCE = NVL(:4,SOURCE) AND SUPPLIER_NAME = NVL(:4,SUPPLIER_NAME)
via Oracle Community by Srini-999, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT PCE.COMPETENCE_ELEMENT_ID, PCE.BUSINESS_GROUP_ID, PCE.COMPETENCE_ID, PCE.PROFICIENCY_LEVEL_ID, PCE.HIGH_PROFICIENCY_LEVEL_ID, PCE.WEIGHTING_LEVEL_ID
via orafaq.com by Unknown author, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select pa.address_id ,pa.primary_flag ,pa.address_type ,pa.style ,pa.address_line1 ,pa.address_line2
via Oracle Community by 964558, 1 year ago
oracle.jbo.AttributeLoadException: JBO-27022: Failed to load value at index 23 with java object of type java.lang.String due to java.sql.SQLException.
via Oracle Community by CSK, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT AERL.* FROM ap_expense_report_params_all AERP *,ap_expense_report_headers_all AERH* *,ap_expense_report_lines_all AERL
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 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.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 undefined._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)

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.