oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select distinct ffvl.flex_value,ffvl.description, mcb.category_id from fnd_flex_value_sets ffvs ,fnd_flex_values_vl ffvl, mtl_categories_b mcb,fnd_id_flex_structures_vl fifsl where ffvs.flex_value_Set_name = 'XXLSC_DELIVERY_LOCATION_CODES' and ffvs.flex_value_set_id = ffvl.flex_value_set_id and ffvl.enabled_flag = 'Y' and nvl(ffvl.end_date_active,trunc(sysdate) + 1) >= trunc(sysdate) and nvl(ffvl.flex_value,'ABC') = nvl(mcb.segment5,'ABC') and mcb.segment1||'.'||mcb.segment2 = :1 and mcb.segment3 = :2 and to_date(:3,'YYYY-MM-DD') between trunc(to_date(mcb.attribute3,'RRRR/MM/DD HH24:MI:SS')) and nvl(mcb.disable_date,to_date('31/12/4712','DD/MM/RRRR')) and mcb.segment4 = :4 --and nvl(mcb.disable_date,trunc(sysdate)+1) >= trunc(sysdate) and mcb.enabled_flag = 'Y' and mcb.structure_id = fifsl.id_flex_num and fifsl.id_flex_structure_code = 'XXLSC_CAT_LOC_RELATIONS' and fifsl.application_id = 401 and fifsl.ID_FLEX_CODE = 'MCAT' order by ffvl.description

Oracle Community | Siva Prasad Nidimamidi | 4 years ago
  1. 0

    java.sql.SQLException: ORA-01008: not all variables bound

    Oracle Community | 4 years ago | Siva Prasad Nidimamidi
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select distinct ffvl.flex_value,ffvl.description, mcb.category_id from fnd_flex_value_sets ffvs ,fnd_flex_values_vl ffvl, mtl_categories_b mcb,fnd_id_flex_structures_vl fifsl where ffvs.flex_value_Set_name = 'XXLSC_DELIVERY_LOCATION_CODES' and ffvs.flex_value_set_id = ffvl.flex_value_set_id and ffvl.enabled_flag = 'Y' and nvl(ffvl.end_date_active,trunc(sysdate) + 1) >= trunc(sysdate) and nvl(ffvl.flex_value,'ABC') = nvl(mcb.segment5,'ABC') and mcb.segment1||'.'||mcb.segment2 = :1 and mcb.segment3 = :2 and to_date(:3,'YYYY-MM-DD') between trunc(to_date(mcb.attribute3,'RRRR/MM/DD HH24:MI:SS')) and nvl(mcb.disable_date,to_date('31/12/4712','DD/MM/RRRR')) and mcb.segment4 = :4 --and nvl(mcb.disable_date,trunc(sysdate)+1) >= trunc(sysdate) and mcb.enabled_flag = 'Y' and mcb.structure_id = fifsl.id_flex_num and fifsl.id_flex_structure_code = 'XXLSC_CAT_LOC_RELATIONS' and fifsl.application_id = 401 and fifsl.ID_FLEX_CODE = 'MCAT' order by ffvl.description
  2. 0

    Error when creating Advanced Table in Advanced Table

    Oracle Community | 8 years ago | 664298
    oracle.apps.fnd.framework.OAException: java.lang.ClassCastException: oracle.jbo.domain.Number
  3. 0

    Error after deployment

    Oracle Community | 7 years ago | 753359
    oracle.apps.fnd.framework.OAException: oracle.jbo.NoDefException: JBO-25002: Definition AdditionalLetterText of type Attribute not found
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    db:: 3.44::Getting oracle.jbo.InvalidDefNameException: JBO-25004 pp

    hivmr.com | 4 months ago
    oracle.apps.fnd.framework.OAException: oracle.jbo.InvalidDefNameException: JBO-25004: Definition name for type View Definition is invalid
  6. 0

    Error in running OAF page from server:

    Oracle Community | 5 years ago | AntonyRaj
    oracle.apps.fnd.framework.OAException: java.lang.StringIndexOutOfBoundsException: String index out of range: 0

    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 distinct ffvl.flex_value,ffvl.description, mcb.category_id from fnd_flex_value_sets ffvs ,fnd_flex_values_vl ffvl, mtl_categories_b mcb,fnd_id_flex_structures_vl fifsl where ffvs.flex_value_Set_name = 'XXLSC_DELIVERY_LOCATION_CODES' and ffvs.flex_value_set_id = ffvl.flex_value_set_id and ffvl.enabled_flag = 'Y' and nvl(ffvl.end_date_active,trunc(sysdate) + 1) >= trunc(sysdate) and nvl(ffvl.flex_value,'ABC') = nvl(mcb.segment5,'ABC') and mcb.segment1||'.'||mcb.segment2 = :1 and mcb.segment3 = :2 and to_date(:3,'YYYY-MM-DD') between trunc(to_date(mcb.attribute3,'RRRR/MM/DD HH24:MI:SS')) and nvl(mcb.disable_date,to_date('31/12/4712','DD/MM/RRRR')) and mcb.segment4 = :4 --and nvl(mcb.disable_date,trunc(sysdate)+1) >= trunc(sysdate) and mcb.enabled_flag = 'Y' and mcb.structure_id = fifsl.id_flex_num and fifsl.id_flex_structure_code = 'XXLSC_CAT_LOC_RELATIONS' and fifsl.application_id = 401 and fifsl.ID_FLEX_CODE = 'MCAT' order by ffvl.description

      at oracle.apps.fnd.framework.OAException.wrapperException()
    2. oracle.apps.fnd
      OAPageBean.renderDocument
      1. oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:891)
      2. oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1145)
      3. oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:2946)
      4. oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:2743)
      4 frames