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.

  • Search based on a shuttle
    via by 27091988,
  • How to sort based on date
    via by 807913,
  • Null pointer exception
    via by 828271,
  • Add search parameter in oaf page
    via by Renu Gupta,
  • Fnd Load Issue
    via by Unknown author,
  • SEPL and VO Extension
    via by 567494,
    • oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT VAC.NAME vname, meaning xxstatus FROM XX_VACANCY_VIEW VAC, xx_fnd_lookups st) QRSLT WHERE (VAC.STATUS=xx_fnd_lookups.LOOKUP_CODE and vac.name like xxGL AND meaning in ('Waiting For Approval')) at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:896) 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:2867) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1840) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:538) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:426)

    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