oracle.apps.fnd.framework.OAException

oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select distinct pg.name grade_name, pg.grade_id, 'Yes' valid_for_job from per_valid_grades pvg, per_grades pg where pvg.grade_id = pg.grade_id and pvg.job_id = :1 union all select distinct pg.name grade_name, pg.grade_id, 'No' valid_for_grade from per_grades pg where not exists (select pvg.job_id from per_valid_grades pvg where pg.grade_id = pvg.grade_id and pvg.job_id = :1)) QRSLT WHERE (( UPPER(GRADE_NAME) like UPPER(:1) AND (GRADE_NAME like :2 OR GRADE_NAME like :3 OR GRADE_NAME like :4 OR GRADE_NAME like :5)))

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 web1656

  • via Oracle Community by 743539, 1 year ago
    and pvg.job_id = :1 union all select distinct pg.name grade_name, pg.grade_id, 'No' valid_for_grade from per_grades pg where not exists (select pvg.job_id from per_valid_grades pvg where pg.grade_id = pvg.grade_id and pvg.job_id = :1)) QRSLT WHERE (( UPPER(GRADE_NAME) like UPPER(:1) AND (GRADE_NAME like :2 OR GRADE_NAME like :3 OR GRADE_NAME like :4 OR GRADE_NAME like :5)))
  • via Oracle Community by 578386, 1 year ago
    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select distinct a.trx_number InvoiceNumber from ra_customer_trx_all a, hz_cust_accounts b where a.bill_to_customer_id = b.cust_account_id and
  • via Oracle Community by 1030500, 11 months ago
    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT lookup_code fault_code FROM fnd_lookup_values flv WHERE lookup_type = 'XXCC_DR_WRNTY_LINKING_DETS' AND attribute2 = :1 AND
  • Stack trace

    • oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select distinct pg.name grade_name, pg.grade_id, 'Yes' valid_for_job from per_valid_grades pvg, per_grades pg where pvg.grade_id = pg.grade_id and pvg.job_id = :1 union all select distinct pg.name grade_name, pg.grade_id, 'No' valid_for_grade from per_grades pg where not exists (select pvg.job_id from per_valid_grades pvg where pg.grade_id = pvg.grade_id and pvg.job_id = :1)) QRSLT WHERE (( UPPER(GRADE_NAME) like UPPER(:1) AND (GRADE_NAME like :2 OR GRADE_NAME like :3 OR GRADE_NAME like :4 OR GRADE_NAME like :5))) at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:891) at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1145) at oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(OAPageErrorHandler.java:1408) at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2406) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1759) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:511) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:432)

    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, 11 months ago
    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    14 more bugmates