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 | 11 months ago
  1. 0

    Error in union query in LOV VO

    Oracle Community | 11 months 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 | 8 years ago | user626324
    oracle.apps.fnd.framework.OAException: java.lang.NullPointerException
  3. 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)))
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Problem: Add Another Row in AdvancedTable

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

    exportButton meet error.

    Oracle Community | 6 years ago | 781391
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: ??????? SQL ?????: select column1, column2 from table t where t.id = :1 and t.name = :2

    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