oracle.apps.fnd.framework.OAException

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.

  • How to stop OAFpage auto refresh
    via by 884536,
  • VO extension error
    via by 884536,
    • oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select ppf.person_id, ppf.employee_number, god.organization_id, ppf.full_name employee_name, (select full_name from per_people_x where person_id = paf.supervisor_ID ) manager_name, (select full_name from per_people_x where person_id = haou.attribute4 ) hr_name, --hr_general.decode_person_name(haou.attribute4 ) hr_name, haou.name organization_name, GEM.termination_date actual_termination_date, (select meaning from hr_lookups where lookup_type = 'LEAV_REAS' and lookup_code = GEM.Leaving_reason and enabled_flag = 'Y') leaving_reason, god.sub_business sub_business, god.business_segment business_segment, god.industry_focus_group industry_focus_group, pgd.segment2 corporate_Band, tl.territory_short_name country from per_people_f ppf, per_assignments_f paf, hr_all_organization_units haou, per_grades pg, per_grade_definitions pgd, per_addresses pa, fnd_territories_tl tl, XXsm_org_dtl god, XX_EXIT_TRANSACTION GET, XX_EXIT_MANAGER GEM where 1=1 and paf.person_id=:1 and paf.primary_flag='Y' and ppf.person_id = paf.person_id and paf.organization_id=haou.organization_id and paf.organization_id = god.organization_id and trunc(sysdate) between trunc(paf.effective_start_date) and trunc(paf.effective_end_date) and trunc(sysdate) between trunc(ppf.effective_start_date) and trunc(ppf.effective_end_date) and ppf.person_id=GET.employee_id(+) and GET.Transaction_id = GEM.transaction_id and paf.grade_id=pg.grade_id(+) and pg.grade_definition_id=pgd.grade_definition_id(+) and ppf.person_id=pa.person_id(+) and pa.primary_flag(+)='Y' and pa.country=tl.territory_code(+) AND tl.language = USERENV('LANG') AND trunc(sysdate) between trunc(pa.Date_from) and trunc(nvl(pa.Date_to, TO_DATE ('31-DEC-4712', 'DD-MON-YYYY'))) at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:891) at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:865) at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:988) at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211) at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:153) at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:750) at ge.oracle.apps.per.selfservice.eexit.employee.webui.GEExitEmployeeCO.processRequest(GEExitEmployeeCO.java:112) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:587) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247) at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1136) at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:959) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:926) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:646) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247) at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:959) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:926) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:646) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247) at oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353) at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2348) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1747) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:511) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:432) at oa_html._OA._jspService(_OA.java:84) at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119) at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417) at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267) at oracle.jsp.JspServlet.internalService(JspServlet.java:186) at oracle.jsp.JspServlet.service(JspServlet.java:156) at javax.servlet.http.HttpServlet.service(HttpServlet.java:588) at org.apache.jserv.JServConnection.processRequest(JServConnection.java:456) at org.apache.jserv.JServConnection.run(JServConnection.java:294) at java.lang.Thread.run(Thread.java:619)

    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,
    10 more bugmates