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.

  • handling escape characters in R12 versus 11i
    via by Asmirnov-Oracle,
  • Migration issue in OAF-urgent
    via by user5425941,
  • Bind Variable in oaf
    via by 839403,
  • 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 FTHeaderEO.HEADER_ID, FTHeaderEO.SUPPLIER, ………………………………… and NVL(op.operation_seq_num,'-99') = NVL(FTHeaderEO.operation_seq_num,'-99') and op.organization_id(+) = wo.organization_id) QRSLT WHERE (ft_num like upper(?) and nvl(upper(project),'%') like upper(?) and status like ? and nvl(upper(wip_entity_name),'%') like upper(?) and vendor_id = ? and trunc(need_by_date) >= nvl(?,trunc(need_by_date)) and trunc(need_by_date) <= nvl(?,trunc(need_by_date))) ORDER BY HEADER_ID desc 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 visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    14 more bugmates