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.

  • Migration issue in OAF-urgent
    via by user5425941,
  • Bind Variable in oaf
    via by 839403,
  • handling escape characters in R12 versus 11i
    via by Asmirnov-Oracle,
  • Error when i create a resourse
    via by 882688,
    • oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT ibyprvl.PAYMENT_REASON_CODE, ibyprvl.MEANING, ibyprvl.DESCRIPTION, ibyprvl.territory_code, countries.territory_short_name FROM IBY_PAYMENT_REASONS_VL ibyprvl, fnd_territories_vl countries WHERE countries.territory_code(+)=ibyprvl.territory_code AND sysdate >= NVL(ibyprvl.INACTIVE_DATE,sysdate) /*and ((ibyprvl.territory_code is NULL) or (ibyprvl.territory_code in ( select hl.country from ap_supplier_sites_all assa, hz_party_sites hps, hz_locations hl where assa.vendor_site_id = :1 and assa.party_site_id = hps.party_site_id and hps.location_id = hl.location_id)))*/ 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