oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT competence_id, step_value || ' - ' || name step_value FROM per_competence_levels_v) QRSLT WHERE (COMPETENCE_ID = :1 AND ( UPPER(STEP_VALUE) like UPPER(:2) AND (STEP_VALUE like :3 OR STEP_VALUE like :4 OR STEP_VALUE like :5 OR STEP_VALUE like :6)))

Oracle Community | 901919 | 5 years ago
  1. 0

    Dependent Lov

    Oracle Community | 5 years ago | 901919
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT competence_id, step_value || ' - ' || name step_value FROM per_competence_levels_v) QRSLT WHERE (COMPETENCE_ID = :1 AND ( UPPER(STEP_VALUE) like UPPER(:2) AND (STEP_VALUE like :3 OR STEP_VALUE like :4 OR STEP_VALUE like :5 OR STEP_VALUE like :6)))
  2. 0

    LOV query with bind variable

    Oracle Community | 9 years ago | 574833
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select comp_plan_id,name,org_id from cn_comp_plans_all where sysdate between start_date and nvl(end_date,sysdate+1) and org_id = :1) QRSLT WHERE (( UPPER(NAME) like :2 AND (NAME like :3 OR NAME like :4 OR NAME like :5 OR NAME like :6)))
  3. 0

    Problem with table in table implementation

    Oracle Community | 9 years ago | 554101
    oracle.apps.fnd.framework.OAException: java.lang.NullPointerException
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Problem with messageLovChoice

    Oracle Community | 8 years ago | 605963
    oracle.apps.fnd.framework.OAException: java.lang.NullPointerException
  6. 0

    Help needed in Table in Table Approach using OAF

    Oracle Community | 8 years ago | 669809
    oracle.apps.fnd.framework.OAException: java.lang.NullPointerException

    11 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 competence_id, step_value || ' - ' || name step_value FROM per_competence_levels_v) QRSLT WHERE (COMPETENCE_ID = :1 AND ( UPPER(STEP_VALUE) like UPPER(:2) AND (STEP_VALUE like :3 OR STEP_VALUE like :4 OR STEP_VALUE like :5 OR STEP_VALUE like :6)))

      at oracle.apps.fnd.framework.OAException.wrapperException()
    2. oracle.apps.fnd
      OAPageBean.preparePage
      1. oracle.apps.fnd.framework.OAException.wrapperException(Unknown Source)
      2. oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(Unknown Source)
      3. oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(Unknown Source)
      4. oracle.apps.fnd.framework.webui.OAPageBean.processRequest(Unknown Source)
      5. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)
      6. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)
      7. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)
      7 frames