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.

  • No current row for View
    via by Kaushal Bhati,
  • Extension iRec
    via by Rakesh S,
  • Error when updating BI Publisher template
    via by user5628632,
  • db:: 4.05::Error 1579 8z
    via by Unknown author,
  • Set IN condition
    via by Rakesh S,
  • Getting error while querying data
    via by 787796,
  • OA framework sample Search Page
    via by Kaushal Bhati,
    • oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT Emp1.EMP_ID, Emp1.CREATION_DATE, Emp1.CREATED_BY, Emp1.LAST_UPDATED_BY, Emp1.LAST_UPDATE_DATE, Emp1.LAST_UPDATE_LOGIN, Emp1.EMP_NAME, Emp1.CITY, Emp1.MGR_CODE, Emp1.DESIGNATION, Emp1.SALARY FROM EMP Emp1 WHERE (( UPPER(Emp1.EMP_NAME) like :2 AND (Emp1.EMP_NAME like :3 OR Emp1.EMP_NAME like :4 OR Emp1.EMP_NAME like :5 OR Emp1.EMP_NAME like :6))) at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:891) at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1145) at oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(OAPageErrorHandler.java:1408) at oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:2680) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1683) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:509) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:430)

    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