oracle.apps.fnd.framework.OAException: 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 tag = :2 UNION SELECT lookup_code fault_code FROM fnd_lookup_values flv WHERE lookup_type = 'XXCC_DR_WRNTY_LINKING_DETS' AND tag = :2 UNION SELECT diagnostic_code fault_code FROM csd_diagnostic_codes_vl dc, csd_dc_domains_v cd, mtl_categories mc WHERE dc.diagnostic_code_id = cd.diagnostic_code_id AND cd.category_id = mc.category_id AND mc.segment2 = :2) QRSLT WHERE (( UPPER(FAULT_CODE) like UPPER(:3) AND (FAULT_CODE like :4 OR FAULT_CODE like :5 OR FAULT_CODE like :6 OR FAULT_CODE like :7)))

Oracle Community | 1030500 | 1 year ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    Error in union query in LOV VO

    Oracle Community | 1 year ago | 1030500
    oracle.apps.fnd.framework.OAException: 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 tag = :2 UNION SELECT lookup_code fault_code FROM fnd_lookup_values flv WHERE lookup_type = 'XXCC_DR_WRNTY_LINKING_DETS' AND tag = :2 UNION SELECT diagnostic_code fault_code FROM csd_diagnostic_codes_vl dc, csd_dc_domains_v cd, mtl_categories mc WHERE dc.diagnostic_code_id = cd.diagnostic_code_id AND cd.category_id = mc.category_id AND mc.segment2 = :2) QRSLT WHERE (( UPPER(FAULT_CODE) like UPPER(:3) AND (FAULT_CODE like :4 OR FAULT_CODE like :5 OR FAULT_CODE like :6 OR FAULT_CODE like :7)))
  2. 0

    submit request using oaf page

    Oracle Community | 9 years ago | user626324
    oracle.apps.fnd.framework.OAException: java.lang.NullPointerException
  3. 0

    Running sourcing Pages in Jdeveloper.

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

    Automated exception search integrated into your IDE

  5. 0

    Dependant LOV

    Oracle Community | 9 years ago | 578386
    oracle.apps.fnd.framework.OAException: 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 b.account_number = :1) QRSLT WHERE (( UPPER(INVOICENUMBER) like :2 AND (INVOICENUMBER like :3 OR INVOICENUMBER like :4 OR INVOICENUMBER like :5 OR INVOICENUMBER like :6)))
  6. 0

    Problem: Add Another Row in AdvancedTable

    Oracle Community | 9 years ago | 646477
    oracle.apps.fnd.framework.OAException: java.lang.ClassCastException: oracle.apps.fnd.framework.webui.beans.table.OAAdvancedTableBean

    5 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 * FROM (SELECT lookup_code fault_code FROM fnd_lookup_values flv WHERE lookup_type = 'XXCC_DR_WRNTY_LINKING_DETS' AND attribute2 = :1 AND tag = :2 UNION SELECT lookup_code fault_code FROM fnd_lookup_values flv WHERE lookup_type = 'XXCC_DR_WRNTY_LINKING_DETS' AND tag = :2 UNION SELECT diagnostic_code fault_code FROM csd_diagnostic_codes_vl dc, csd_dc_domains_v cd, mtl_categories mc WHERE dc.diagnostic_code_id = cd.diagnostic_code_id AND cd.category_id = mc.category_id AND mc.segment2 = :2) QRSLT WHERE (( UPPER(FAULT_CODE) like UPPER(:3) AND (FAULT_CODE like :4 OR FAULT_CODE like :5 OR FAULT_CODE like :6 OR FAULT_CODE like :7)))

      at oracle.apps.fnd.framework.OAException.wrapperException()
    2. oracle.apps.fnd
      OAException.wrapperException
      1. oracle.apps.fnd.framework.OAException.wrapperException(Unknown Source)
      1 frame