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.

  • Strange issue on a dynamically created VO.
    via by amit.kochar-Oracle,
  • Error when Extending VO
    via by 594196,
  • Error while extending the VO
    via by 834796,
  • Number formatting issue
    via by 489141,
    • oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT csm.ship_method_code, csm.enabled_flag, fl.enabled_flag lookup_Enabled_Flag, fl.meaning FROM wsh_carrier_ship_methods csm, fnd_lookup_values fl WHERE fl.lookup_type = :1 AND fl.lookup_code = csm.ship_method_code AND fl.view_application_id = :2 AND nvl(fl.start_date_active, sysdate) <= sysdate AND nvl(fl.end_date_active, sysdate) >= sysdate AND fl.language = USERENV('LANG') AND fl.enabled_flag = :3 AND csm.enabled_flag = :4 AND csm.organization_id = :5) QRSLT ORDER BY meaning 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.OAPageBean.renderDocument(OAPageBean.java:3241) at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:3036)

    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,
    9 more bugmates