oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select distinct to_char(paydate,'Month RRRR') PaySlip_of_month ,to_char(paydate,'DD-MON-RRRR') Payroll_date,payyear,paymonth from apps.XX_TEST_VIEW where person_id=:1 order by payyear desc,paymonth desc

Oracle Community | Jenny_Gomez | 4 years ago
  1. 0

    where clause in VO giving error

    Oracle Community | 4 years ago | Jenny_Gomez
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select distinct to_char(paydate,'Month RRRR') PaySlip_of_month ,to_char(paydate,'DD-MON-RRRR') Payroll_date,payyear,paymonth from apps.XX_TEST_VIEW where person_id=:1 order by payyear desc,paymonth desc
  2. 0

    Unknown Macro: "Existsroute" (File: Drivers\Kinetis\Sdhc_Ldd.Rgi)

    wpthm.com | 1 year ago
    oracle.apps.fnd.framework.OAException: java.lang.ArrayIndexOutOfBoundsException: 0
  3. 0

    Users Getting "Unknown User" In Pre-Boot Despite Log/Epo Showing Otherwise

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

    Automated exception search integrated into your IDE

  5. 0

    db:: 5.06::error exception unknown 3d

    hivmr.com | 11 months ago
    oracle.apps.fnd.framework.OAException: java.lang.ArrayIndexOutOfBoundsException: 0
  6. 0

    db:: 4.21::Exception from "Unknown Source" using swing component, any debug tip ? p7

    hivmr.com | 8 months ago
    oracle.apps.fnd.framework.OAException: java.lang.ArrayIndexOutOfBoundsException: 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 to_char(paydate,'Month RRRR') PaySlip_of_month ,to_char(paydate,'DD-MON-RRRR') Payroll_date,payyear,paymonth from apps.XX_TEST_VIEW where person_id=:1 order by payyear desc,paymonth desc

      at oracle.apps.fnd.framework.OAException.wrapperException()
    2. oracle.apps.fnd
      OAPageBean.renderDocument
      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.OAPageBean.renderDocument(Unknown Source)
      4. oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(Unknown Source)
      4 frames