oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select ename from scott.emp) QRSLT WHERE (DEPTNO=:1)

Oracle Community | e630688d-de97-43ea-9d13-8a33fc0641df | 3 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Dependent Poplist through Code

    Oracle Community | 3 years ago | e630688d-de97-43ea-9d13-8a33fc0641df
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select ename from scott.emp) QRSLT WHERE (DEPTNO=:1)
  2. 0

    Getting Error when setting the default value in LOV

    Oracle Community | 2 years ago | 2973180
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select oos.name, oos.description, mcv.segment3 "DefaultSourceFlag" from oe_order_sources oos , mtl_categories_v mcv , fnd_responsibility_tl frt WHERE (mcv.structure_name LIKE 'XXG_ORM_ORD_SOURCE_RESTRICT') AND mcv.segment2 = to_char(frt.RESPONSIBILITY_ID) AND mcv.ENABLED_FLAG = 'Y' AND mcv.segment1 = oos.name And frt.responsibility_name = :1
  3. 0

    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation

    Oracle Community | 2 years ago | Shahzad.H.Magsi
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT SEHA_CW_PERSONAL_INFO_EO.CW_PERSON_ID, SEHA_CW_PERSONAL_INFO_EO.CW_NUMBER, SEHA_CW_PERSONAL_INFO_EO.CREATOR_BG_ID, SEHA_CW_PERSONAL_INFO_EO.TITLE, SEHA_CW_PERSONAL_INFO_EO.FIRST_NAME, SEHA_CW_PERSONAL_INFO_EO.MIDDLE_NAME, SEHA_CW_PERSONAL_INFO_EO.FAMILY_NAME, SEHA_CW_PERSONAL_INFO_EO.FULL_NAME, SEHA_CW_PERSONAL_INFO_EO.GENDER, SEHA_CW_PERSONAL_INFO_EO.DATE_OF_BIRTH, SEHA_CW_PERSONAL_INFO_EO.APPROVAL_STATUS, SEHA_CW_PERSONAL_INFO_EO.WORK_EMAIL_ADDRESS, SEHA_CW_PERSONAL_INFO_EO.WORK_PHONE_NUMBER, SEHA_CW_PERSONAL_INFO_EO.WORK_MOBILE_NUMBER, SEHA_CW_PERSONAL_INFO_EO.SEHA_EMAIL_ADDRESS, SEHA_CW_PERSONAL_INFO_EO.SEHA_WORK_PHONE_NUMBER, SEHA_CW_PERSONAL_INFO_EO.SEHA_MOBILE_NUMBER, SEHA_CW_PERSONAL_INFO_EO.CW_PICTURE, SEHA_CW_PERSONAL_INFO_EO.FULL_NAME AS Custom_Full_Name, (SELECT meaning Meaning FROM fnd_lookup_values l WHERE lookup_type = 'SEHA_HRMS_APPROVAL' AND l.language = 'US' AND l.enabled_flag = 'Y' AND l.lookup_code = SEHA_CW_PERSONAL_INFO_EO.APPROVAL_STATUS) Meaning_Status, DECODE(SEHA_CW_PERSONAL_INFO_EO.APPROVAL_STATUS, 'INCOMPLETE', 'Update_Enabled', 'REJECTED', 'Update_Enabled', 'APPROVED', 'Update_Enabled', 'Update_Disabled') Update_Swither, SEHA_CW_PERSONAL_INFO_EO.Created_By, SEHA_CW_PERSONAL_INFO_EO.BATCH_NO, SEHA_CW_PERSONAL_INFO_EO.BIO_METRIC, SEHA_CW_PERSONAL_INFO_EO.EMPLOYEE_BADGE_NO, SEHA_CW_PERSONAL_INFO_EO.KRONOS_BADGE_NO, /*(SELECT 1 SECTION FROM seha_global_emp_new_mv jj WHERE jj.section_id = (SELECT case when j.divsion_id is not null and j.depart_id is null and j.section_id is null then j.divsion_id when j.divsion_id is null and j.depart_id is not null and j.section_id is null then j.depart_id when j.divsion_id is null and j.depart_id is null and j.section_id is not null then j.section_id when j.divsion_id is not null and j.depart_id is not null and j.section_id is null then j.depart_id when j.divsion_id is not null and j.depart_id is not null and j.section_id is not null then j.section_id else -0089 end sec_dep_div_id FROM seha_global_emp_new_mv j, FND_USER U WHERE U.EMPLOYEE_ID = j.PERSON_ID AND J.BUSINESS_GROUP_ID = 81 AND U.USER_ID = SEHA_CW_PERSONAL_INFO_EO.CREATED_BY) union SELECT 2 DEPART FROM seha_global_emp_new_mv jj WHERE jj.depart_id = (SELECT case when j.divsion_id is not null and j.depart_id is null and j.section_id is null then j.divsion_id when j.divsion_id is null and j.depart_id is not null and j.section_id is null then j.depart_id when j.divsion_id is null and j.depart_id is null and j.section_id is not null then j.section_id when j.divsion_id is not null and j.depart_id is not null and j.section_id is null then j.depart_id when j.divsion_id is not null and j.depart_id is not null and j.section_id is not null then j.section_id else -0089 end sec_dep_div_id FROM seha_global_emp_new_mv j, FND_USER U WHERE U.EMPLOYEE_ID = j.PERSON_ID AND J.BUSINESS_GROUP_ID = 81 AND U.USER_ID = SEHA_CW_PERSONAL_INFO_EO.CREATED_BY) UNION SELECT 3 DIVISION FROM seha_global_emp_new_mv jj WHERE jj.divsion_id = (SELECT case when j.divsion_id is not null and j.depart_id is null and j.section_id is null then j.divsion_id when j.divsion_id is null and j.depart_id is not null and j.section_id is null then j.depart_id when j.divsion_id is null and j.depart_id is null and j.section_id is not null then j.section_id when j.divsion_id is not null and j.depart_id is not null and j.section_id is null then j.depart_id when j.divsion_id is not null and j.depart_id is not null and j.section_id is not null then j.section_id else -0089 end sec_dep_div_id FROM seha_global_emp_new_mv j, FND_USER U WHERE U.EMPLOYEE_ID = j.PERSON_ID AND J.BUSINESS_GROUP_ID = 81 AND U.USER_ID = SEHA_CW_PERSONAL_INFO_EO.CREATED_BY )) SEC_DEP_DIV,*/ SEHA_CW_PERSONAL_INFO_EO.ACTIVE_INACTIVE_YN, decode(SEHA_CW_PERSONAL_INFO_EO.ACTIVE_INACTIVE_YN, 'A', 'Active', 'Inactive') Meaning_ActiveStatus, SEHA_CW_PERSONAL_INFO_EO.ARABIC_NAME AS ARABIC_NAME, SEHA_CW_PERSONAL_INFO_EO.ALTERNATE_EMAIL AS ALTERNATE_EMAIL, SEHA_CW_PERSONAL_INFO_EO.CONTIGENT_WORKER_TYPE AS Contigent_worker_type, (SELECT MEANING FROM apps.hr_lookups WHERE lookup_type = 'SEHA CONTIGENT WORKER TYPE' AND LOOKUP_CODE = SEHA_CW_PERSONAL_INFO_EO.CONTIGENT_WORKER_TYPE) ContigentWorkertypeMeaning, trunc(SEHA_CW_PERSONAL_INFO_EO.creation_date) as CreationDate, SEHA_CW_PERSONAL_INFO_EO.organization_id as OrganizationId FROM SEHA_CW_PERSONAL_INFO SEHA_CW_PERSONAL_INFO_EO WHERE SEHA_CW_PERSONAL_INFO_EO.CREATOR_BG_ID = 81 AND SEHA_CW_PERSONAL_INFO_EO.Organization_Id in (SELECT org.organization_id FROM hr_all_organization_units org, per_org_structure_elements ose WHERE 1 = 1 AND org.organization_id = ose.organization_id_child START WITH ose.organization_id_child IN (SELECT paaf.organization_id FROM fnd_user fu, per_all_people_f papf, per_all_assignments_f paaf WHERE papf.person_id = fu.employee_id AND TRUNC(sysdate) BETWEEN papf.effective_start_date AND papf.effective_end_date AND papf.person_id = paaf.person_id AND TRUNC(sysdate) BETWEEN paaf.effective_start_date AND paaf.effective_end_date AND fu.user_id = :1) CONNECT BY PRIOR ose.organization_id_child = ose.organization_id_parent)) QRSLT ORDER BY 2 asc
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    The OA Dialog Page not working correctly for all users

    Oracle Community | 2 years ago | 2880934
    oracle.apps.fnd.framework.OAException: java.lang.NullPointerException
  6. 0

    null pointer exception for Date field

    Oracle Community | 2 years ago | 2614650
    oracle.apps.fnd.framework.OAException: java.lang.NullPointerException

    11 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. oracle.apps.fnd.framework.OAException

      oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select ename from scott.emp) QRSLT WHERE (DEPTNO=:1)

      at oracle.apps.fnd.framework.OAException.wrapperException()
    2. oracle.apps.fnd
      OAPageBean.preparePage
      1. oracle.apps.fnd.framework.OAException.wrapperException(Unknown Source)
      2. oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(Unknown Source)
      3. oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(Unknown Source)
      4. oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(Unknown Source)
      5. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)
      6. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)
      7. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)
      7 frames
    3. Unknown
      _OA._jspService
      1. _OA._jspService(_OA.java:71)
      1 frame
    4. com.orionserver.http
      OrionHttpJspPage.service
      1. com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
      1 frame
    5. oracle.jsp.runtimev2
      JspServlet.service
      1. oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:462)
      2. oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
      3. oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
      3 frames
    6. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
      1 frame
    7. com.evermind.server
      HttpRequestHandler.run
      1. com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:713)
      2. com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
      3. com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871)
      4. com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)
      5. com.evermind.server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java:221)
      6. com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:122)
      7. com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:111)
      7 frames
    8. oracle.oc4j.network
      ServerSocketReadHandler$SafeRunnable.run
      1. oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
      1 frame
    9. com.evermind.util
      ReleasableResourcePooledExecutor$MyWorker.run
      1. com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
      1 frame
    10. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:595)
      1 frame