oracle.apps.fnd.framework.OAException

oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT DISTINCT WORK.division,COUNT(distinct WORK.win_code) sum_count,SUM(WORK.ADMIN_SANCTION_AMT/100000) sum_amount,'zone_desc','status_id' FROM PW.pw_works_admin_mstr WORK ,pw.pw_wo a WHERE WORK.WIN_CODE=a.WIN_CODE(+) AND STATUS_ID='SPILLOVER WORKS' and nvl(DUPLI,'N') <> 'Y' GROUP BY WORK.division) QRSLT WHERE (ZONE_DESC = :3 and STATUS_ID = :4)

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

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

Solutions on the web1015

  • via Oracle Community by 929839, 11 months ago
    ' FROM PW.pw_works_admin_mstr WORK ,pw.pw_wo a WHERE WORK.WIN_CODE=a.WIN_CODE(+) AND STATUS_ID='SPILLOVER WORKS' and nvl(DUPLI,'N') <> 'Y' GROUP BY WORK.division) QRSLT WHERE (ZONE_DESC = :3 and STATUS_ID = :4)
  • oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select distinct meaning , attribute4 from splwms.so_lookups where lookup_type = 'SHIPMENT_PRIORITY' and enabled_flag = 'Y' and attribute4 = :Carrier order by meaning
  • via Oracle Community by Devang Thakkar, 1 year ago
    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select distinct country from xx_qa_comp_decision_tree_v where country =nvl(:1,country)) QRSLT ORDER BY 1
  • Stack trace

    • oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT DISTINCT WORK.division,COUNT(distinct WORK.win_code) sum_count,SUM(WORK.ADMIN_SANCTION_AMT/100000) sum_amount,'zone_desc','status_id' FROM PW.pw_works_admin_mstr WORK ,pw.pw_wo a WHERE WORK.WIN_CODE=a.WIN_CODE(+) AND STATUS_ID='SPILLOVER WORKS' and nvl(DUPLI,'N') <> 'Y' GROUP BY WORK.division) QRSLT WHERE (ZONE_DESC = :3 and STATUS_ID = :4) at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:888) at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:862) at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:985)

    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 user
    Once, 10 months ago
    Unknown user
    Once, 10 months ago
    Unknown user
    Once, 10 months ago
    Unknown user
    Once, 11 months ago
    Unknown user
    Once, 11 months ago
    9 more bugmates