oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: Select template_name, template_code,application_short_name, template_type_code from xdo_templates_vl where ds_app_short_name = :1 and data_source_code = :2 and template_status= 'E' and sysdate between start_date and nvl(end_date,sysdate)

Oracle Community | 1008289 | 4 years ago
  1. 0

    Reprint/Republish Functionality Erroring out

    Oracle Community | 4 years ago | 1008289
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: Select template_name, template_code,application_short_name, template_type_code from xdo_templates_vl where ds_app_short_name = :1 and data_source_code = :2 and template_status= 'E' and sysdate between start_date and nvl(end_date,sysdate)
  2. 0

    db:: 5.87::oracle.jbo.NoDefException JBO-25058 1k

    hivmr.com | 5 months ago
    oracle.apps.fnd.framework.OAException: oracle.jbo.NoDefException: JBO-25058: Definition DESCRIPTION of type Attribute not found in PreviousEmployment
  3. 0

    "Unknown Source" Errors

    wpthm.com | 1 year ago
    oracle.apps.fnd.framework.OAException: java.lang.ArrayIndexOutOfBoundsException: 16
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    db:: 3.71::I have an issue with an unknown User Account on the computer. 3d

    hivmr.com | 5 months ago
    oracle.apps.fnd.framework.OAException: java.lang.ArrayIndexOutOfBoundsException: 16

    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 template_name, template_code,application_short_name, template_type_code from xdo_templates_vl where ds_app_short_name = :1 and data_source_code = :2 and template_status= 'E' and sysdate between start_date and nvl(end_date,sysdate)

      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:3247)
      4. oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:3042)
      4 frames