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)

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web1197

  • via Oracle Community by Asmirnov-Oracle, 11 months ago
    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
  • via Oracle Community by Myvizhi Selvi, 11 months ago
    f where f.user_id = a.user_id and a.document_type = 'CM' order by 2) QRSLT WHERE (( UPPER(CURRENCY_CODE) like UPPER(:1) AND (CURRENCY_CODE like :2 OR CURRENCY_CODE like :3 OR CURRENCY_CODE like :4 OR CURRENCY_CODE like :5))) ORDER BY DESCRIPTION asc
  • via Oracle Community by 839403, 11 months ago
    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select fu.user_name, ppf.full_name, HR_GENERAL.DECODE_POSITION_LATEST_NAME (paf.POSITION_ID) POSITION_NAME, ppf.email_address from fnd_user fu
  • Stack trace

    • 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(Unknown Source)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    You’re the first here who have seen this exception.