oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT 'Y' SelectFlag, pere.full_name EmployeeName, pafe.assignment_number EmployeeNumber, jbt.name Jobtitle, pers.full_name SupervisorName, pafs.assignment_number SupervisorNumber, hou.name Department, pere.person_id PersonId FROM PER_JOBS_TL jbt ,PER_PEOPLE_F pere ,PER_PEOPLE_F pers ,HR_ORGANIZATION_UNITS hou ,PER_ASSIGNMENTS_F pafe ,PER_ASSIGNMENTS_F pafs ,tvap.TVAP_OIE_CARD_MANAGE_HIST cchist ,AP_CARD_PROGRAMS_ALL cp WHERE pafe.job_id = jbt.job_id(+) ... AND (cchist.record_status = 'ACTIVE' OR cchist.record_status = 'APPROVED' OR cchist.record_status = 'PENDING') ORDER BY 2) QRSLT WHERE (PERSONID = :1 AND ( UPPER(EmployeeName) like UPPER(:1) AND (EmployeeName like :2 OR EmployeeName like :3 OR EmployeeName like :4 OR EmployeeName like :5))) ORDER BY EmployeeName ASC ... at TVA.oracle.apps.tvap.ccw.webui.CheckOwnerSearchCO.processFormRequest(CheckOwnerSearchCO.java:83)

Oracle Community | Asmirnov-Oracle | 4 years ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 0

    how to clear query region result set

    Oracle Community | 4 years ago | Asmirnov-Oracle
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT 'Y' SelectFlag, pere.full_name EmployeeName, pafe.assignment_number EmployeeNumber, jbt.name Jobtitle, pers.full_name SupervisorName, pafs.assignment_number SupervisorNumber, hou.name Department, pere.person_id PersonId FROM PER_JOBS_TL jbt ,PER_PEOPLE_F pere ,PER_PEOPLE_F pers ,HR_ORGANIZATION_UNITS hou ,PER_ASSIGNMENTS_F pafe ,PER_ASSIGNMENTS_F pafs ,tvap.TVAP_OIE_CARD_MANAGE_HIST cchist ,AP_CARD_PROGRAMS_ALL cp WHERE pafe.job_id = jbt.job_id(+) ... AND (cchist.record_status = 'ACTIVE' OR cchist.record_status = 'APPROVED' OR cchist.record_status = 'PENDING') ORDER BY 2) QRSLT WHERE (PERSONID = :1 AND ( UPPER(EmployeeName) like UPPER(:1) AND (EmployeeName like :2 OR EmployeeName like :3 OR EmployeeName like :4 OR EmployeeName like :5))) ORDER BY EmployeeName ASC ... at TVA.oracle.apps.tvap.ccw.webui.CheckOwnerSearchCO.processFormRequest(CheckOwnerSearchCO.java:83)

    Root Cause Analysis

    1. oracle.apps.fnd.framework.OAException

      oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT 'Y' SelectFlag, pere.full_name EmployeeName, pafe.assignment_number EmployeeNumber, jbt.name Jobtitle, pers.full_name SupervisorName, pafs.assignment_number SupervisorNumber, hou.name Department, pere.person_id PersonId FROM PER_JOBS_TL jbt ,PER_PEOPLE_F pere ,PER_PEOPLE_F pers ,HR_ORGANIZATION_UNITS hou ,PER_ASSIGNMENTS_F pafe ,PER_ASSIGNMENTS_F pafs ,tvap.TVAP_OIE_CARD_MANAGE_HIST cchist ,AP_CARD_PROGRAMS_ALL cp WHERE pafe.job_id = jbt.job_id(+) ... AND (cchist.record_status = 'ACTIVE' OR cchist.record_status = 'APPROVED' OR cchist.record_status = 'PENDING') ORDER BY 2) QRSLT WHERE (PERSONID = :1 AND ( UPPER(EmployeeName) like UPPER(:1) AND (EmployeeName like :2 OR EmployeeName like :3 OR EmployeeName like :4 OR EmployeeName like :5))) ORDER BY EmployeeName ASC ... at TVA.oracle.apps.tvap.ccw.webui.CheckOwnerSearchCO.processFormRequest(CheckOwnerSearchCO.java:83)

      at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest()
    2. oracle.apps.fnd
      OAWebBeanHelper.processFormRequest
      1. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(Unknown Source)
      1 frame