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

Oracle Community | amit.kochar-Oracle | 6 years ago
  1. 0

    Strange issue on a dynamically created VO.

    Oracle Community | 6 years ago | amit.kochar-Oracle
    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
  2. 0

    Error when personalizing page with new item created in VO extension

    Oracle Community | 6 years ago | 594196
    oracle.apps.fnd.framework.OAException: oracle.jbo.NoDefException: JBO-25058: Definition CHARGE_ACCOUNT of type Attribute not found in ReqLinesNotificationsVO
  3. 0

    Error when Extending VO

    Oracle Community | 6 years ago | 594196
    oracle.apps.fnd.framework.OAException: java.lang.ArrayIndexOutOfBoundsException: 1
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Error while extending the VO

    Oracle Community | 6 years ago | 834796
    oracle.apps.fnd.framework.OAException: java.lang.ArrayIndexOutOfBoundsException: 0
  6. 0

    HELP URGENT - Entity Object Substitution not working as advertised!!!!!

    Oracle Community | 6 years ago | 839957
    oracle.apps.fnd.framework.OAException: oracle.jbo.AttrValException: JBO-27019: Get method for attribute "ItemNumber" in XxEgoMtlSystemItemsVLEOEx could not be resolved.

    1 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. 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()
    2. oracle.apps.fnd
      OAPageBean.renderDocument
      1. oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
      2. oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1169)
      3. oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:3241)
      4. oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:3036)
      4 frames