oracle.apps.fnd.framework.OAException

oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT VAC.NAME vname, meaning status FROM XX_VACANCY_VIEW VAC, xx_fnd_lookups ST WHERE VAC.STATUS=ST.LOOKUP_CODE AND VAC.NAME like :1 AND MEANING like :2

Solutions on the web1038

  • via Oracle Community by 27091988, 11 months ago
    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT VAC.NAME vname, meaning status FROM XX_VACANCY_VIEW VAC, xx_fnd_lookups ST WHERE VAC.STATUS=ST.LOOKUP_CODE AND VAC.NAME like :1 AND MEANING like :2
  • oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT LOOKUP_CODE, MEANING FROM FND_LOOKUP_VALUES_Vl WHERE LOOKUP_TYPE = :1 and enabled_flag = 'Y' ORDER BY MEANING ASC
  • via Oracle Community by Chacks, 11 months ago
    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT LOOKUP_CODE, MEANING FROM fnd_lookup_values WHERE LOOKUP_TYPE = :1 and enabled_flag = 'Y' ORDER BY MEANING ASC
  • Stack trace

    • oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT VAC.NAME vname, meaning status FROM XX_VACANCY_VIEW VAC, xx_fnd_lookups ST WHERE VAC.STATUS=ST.LOOKUP_CODE AND VAC.NAME like :1 AND MEANING like :2 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)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown user
    Once, 10 months ago
    Unknown user
    Once, 10 months ago
    Unknown user
    Once, 11 months ago
    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    14 more bugmates