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.

  • View Link Invalid Number
    via by AnilA,
  • 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 qfapa.list_line_id, qfapa.pricing_attribute_context, qfapa.pricing_attribute, qfapa.pricing_attr_value_from, qfapa.pricing_attr_value_to, qfapa.factor_list_id, qfapa.comparison_operator_code, qfapa.pricing_attribute_id, qfapa.creation_date, qfapa.created_by, qfapa.last_update_date, qfapa.last_updated_by, qfapa.orig_sys_header_ref, qfapa.orig_sys_line_ref, qfapa.orig_sys_pricing_attr_ref FROM qpfv_factor_asso_pricing_attrs qfapa WHERE qfapa.pricing_attribute = NVL (:2, qfapa.pricing_attribute) AND qfapa.comparison_operator_code = NVL (:3, qfapa.comparison_operator_code) AND NVL (qfapa.pricing_attr_value_from, 'xxxxx') = NVL (:4, NVL (qfapa.pricing_attr_value_from, 'xxxxx')) AND NVL (qfapa.pricing_attr_value_to, 'xxxxx') = NVL (:5, NVL (qfapa.pricing_attr_value_to, 'xxxxx'))) QRSLT WHERE (LIST_LINE_ID = :1) 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.OAPageBean.renderDocument(OAPageBean.java:2970) at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:2767)

    Users with the same issue

    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    9 more bugmates