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)

Oracle Community | 929839 | 5 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Error while running the page

    Oracle Community | 5 years ago | 929839
    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)
  2. 0

    Nullpointerexception ....

    Oracle Community | 10 years ago | 572444
    oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_GENERIC_MESSAGE. Tokens: MESSAGE = java.lang.NullPointerException; (Could not lookup message because there is no database connection)
  3. 0

    oracle.apps.per.selfservices.appraisals.server.AppraisalVO

    Oracle Community | 5 years ago | OliverM-Oracle
    oracle.apps.fnd.framework.OAException: java.lang.NullPointerException
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Getting JBO-25005: Object name for type View Object is invalid Error!

    Oracle Community | 10 years ago | 588819
    oracle.apps.fnd.framework.OAException: oracle.jbo.InvalidObjNameException: JBO-25005: Object name for type View Object is invalid
  6. 0

    db:: 3.47::oracle.jbo.InvalidParamException: JBO-25006: Invalid parameter value fc

    hivmr.com | 8 months ago
    oracle.apps.fnd.framework.OAException: oracle.jbo.InvalidParamException: JBO-25006: Invalid parameter value PoRequisitionLinesVO for destination passed to method ViewLinkImpl.setDestination. Explanation: view def mismatch

    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 * 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()
    2. oracle.apps.fnd
      OAException.wrapperInvocationTargetException
      1. oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:888)
      2. oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:862)
      3. oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:985)
      3 frames