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
  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)
  2. 0

    Error while exporting data into Excel Sheet

    Oracle Community | 4 years ago | Myvizhi Selvi
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select f.user_name , f.description , a.currency_code, a.amount_to , a.amount_from from seacds.ar_approval_user_limits_nv a , seacds.fnd_user_nv 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
  3. 0

    Bind Variable in oaf

    Oracle Community | 5 years ago | 839403
    oracle.apps.fnd.framework.OAException: 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, per_people_f ppf, per_assignments_f paf where ppf.person_id = fu.employee_id and ppf.person_id=paf.person_id and trunc(sysdate) between ppf.effective_start_date and ppf.effective_end_date and trunc(sysdate) between paf.effective_start_date and paf.effective_end_date and fu.user_name :1 and employee_id in (select paf2.person_id from per_assignments_f paf1, per_assignments_f paf2 where paf1.person_id = (select distinct employee_id from fnd_user where user_name =:1 ) AND (paf2.position_id = paf1.position_id OR (paf2.position_id IN ( SELECT parent_position_id FROM PER_POS_STRUCTURE_ELEMENTS START WITH subordinate_position_id = paf1.position_id CONNECT BY subordinate_position_id = PRIOR parent_position_id and rownum <2 )))) order by HR_GENERAL.DECODE_POSITION_LATEST_NAME (paf.POSITION_ID)) QRSLT WHERE (( UPPER(FNAME) like UPPER(:2) AND (FNAME like :3 OR FNAME like :4 OR FNAME like :5 OR FNAME like :6)))
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Date Format &amp; Advanced Search Region

    Oracle Community | 9 years ago | 55166
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation SELECT .... AND NOT EXISTS (SELECT 1 FROM XXDAV.XXDAV_INVOICE_IMPORT_LINES_STG STG WHERE APCC.TRX_ID = STG.TRX_ID)) QRSLT WHERE (( UPPER(EMPLOYEE_NAME) = :1 AND (EMPLOYEE_NAME like :2 OR EMPLOYEE_NAME like :3 OR EMPLOYEE_NAME like :4 OR EMPLOYEE_NAME like :5)AND BILLED_DATE > :6 )) ORDER BY TRANSACTION_DATE ASC, BILLED_AMOUNT ASC
  6. 0

    Job Lov Extension ORA-01006: bind variable does not exist

    Oracle Community | 7 years ago | Rakesh S
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT pj.job_id, pj.name job, pj.business_group_id, pj.date_from, pj.date_to, hlc.meaning flsa_status, pj.attribute3 xxatc_job_dff FROM per_jobs_v pj, hr_leg_lookups hlc WHERE hlc.lookup_code(+)= pj.job_information3 and hlc.lookup_type(+)='US_EXEMPT_NON_EXEMPT') QRSLT WHERE (JOB like :1 AND ( UPPER(JOB) like :4 AND (JOB like :5 OR JOB like :6 OR JOB like :7 OR JOB like :8))) ORDER BY job

    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 '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