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.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, 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, SEHA_CW_PERSONAL_INFO_EO.REMARKS, SEHA_CW_PERSONAL_INFO_EO.orcl_person_id FROM SEHA_CW_PERSONAL_INFO SEHA_CW_PERSONAL_INFO_EO WHERE 1=1 AND SEHA_CW_PERSONAL_INFO_EO.CREATOR_BG_ID = NVL(:1,SEHA_CW_PERSONAL_INFO_EO.CREATOR_BG_ID)) QRSLT WHERE (( UPPER(MEANING_STATUS) = UPPER(:1) AND (MEANING_STATUS like :2 OR MEANING_STATUS like :3 OR MEANING_STATUS like :4 OR MEANING_STATUS like :5))) ORDER BY 2 asc

Oracle Community | Shahzad.H.Magsi | 2 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

    oracle.jbo.SQLStmtException: JBO-27122:

    Oracle Community | 2 years ago | Shahzad.H.Magsi
    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.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, 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, SEHA_CW_PERSONAL_INFO_EO.REMARKS, SEHA_CW_PERSONAL_INFO_EO.orcl_person_id FROM SEHA_CW_PERSONAL_INFO SEHA_CW_PERSONAL_INFO_EO WHERE 1=1 AND SEHA_CW_PERSONAL_INFO_EO.CREATOR_BG_ID = NVL(:1,SEHA_CW_PERSONAL_INFO_EO.CREATOR_BG_ID)) QRSLT WHERE (( UPPER(MEANING_STATUS) = UPPER(:1) AND (MEANING_STATUS like :2 OR MEANING_STATUS like :3 OR MEANING_STATUS like :4 OR MEANING_STATUS like :5))) ORDER BY 2 asc

    Root Cause Analysis

    1. 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.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, 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, SEHA_CW_PERSONAL_INFO_EO.REMARKS, SEHA_CW_PERSONAL_INFO_EO.orcl_person_id FROM SEHA_CW_PERSONAL_INFO SEHA_CW_PERSONAL_INFO_EO WHERE 1=1 AND SEHA_CW_PERSONAL_INFO_EO.CREATOR_BG_ID = NVL(:1,SEHA_CW_PERSONAL_INFO_EO.CREATOR_BG_ID)) QRSLT WHERE (( UPPER(MEANING_STATUS) = UPPER(:1) AND (MEANING_STATUS like :2 OR MEANING_STATUS like :3 OR MEANING_STATUS like :4 OR MEANING_STATUS like :5))) ORDER BY 2 asc

      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.processRequest(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
      ServletRequestDispatcher$2.oc4jRun
      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.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:259)
      4. com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:51)
      5. com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:193)
      5 frames
    8. oracle.oc4j.security
      OC4JSecurity.doPrivileged
      1. oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:283)
      1 frame
    9. com.evermind.server
      EvermindPageContext.forward
      1. com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:198)
      2. com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:392)
      2 frames
    10. Unknown
      _OA._jspService
      1. _OA._jspService(_OA.java:80)
      1 frame
    11. com.orionserver.http
      OrionHttpJspPage.service
      1. com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
      1 frame
    12. 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
    13. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
      1 frame
    14. com.evermind.server
      ServletRequestDispatcher$2.oc4jRun
      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.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:259)
      4. com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:51)
      5. com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:193)
      5 frames
    15. oracle.oc4j.security
      OC4JSecurity.doPrivileged
      1. oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:283)
      1 frame
    16. com.evermind.server
      EvermindPageContext.forward
      1. com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:198)
      2. com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:392)
      2 frames
    17. Unknown
      _OA._jspService
      1. _OA._jspService(_OA.java:80)
      1 frame
    18. com.orionserver.http
      OrionHttpJspPage.service
      1. com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
      1 frame
    19. 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
    20. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
      1 frame
    21. 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
    22. oracle.oc4j.network
      ServerSocketReadHandler$SafeRunnable.run
      1. oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
      1 frame
    23. com.evermind.util
      ReleasableResourcePooledExecutor$MyWorker.run
      1. com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
      1 frame
    24. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:595)
      1 frame