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

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • Bind Variable in oaf
    via by 839403,
  • Migration issue in OAF-urgent
    via by user5425941,
  • handling escape characters in R12 versus 11i
    via by Asmirnov-Oracle,
  • Error when i create a resourse
    via by 882688,
  • How To Caluclate The SIT Date Caluclation.?
    via by Srini-999,
    • 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))) at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912) at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1169) at oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(OAPageErrorHandler.java:1435) at oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:2978) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1875) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431)

    Users with the same issue

    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    14 more bugmates