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
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded 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