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

Samebug tips0

We couldn't find tips for this exception.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web1298

  • via Unknown by Jenny_Gomez,
  • Stack trace

    • 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(Unknown Source) at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(Unknown Source) at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(Unknown Source) at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(Unknown Source)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    9 more bugmates