oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT EXA.SEGMENT5 ACCOUNT_NAME , EXA.SEGMENT4 ACCOUNT_NUMBER , EXA.SEGMENT3 SORT_CODE , HL.MEANING BANK_NAME , EXA.SEGMENT2 BRANCH , EXA.EXTERNAL_ACCOUNT_ID , EXA.OBJECT_VERSION_NUMBER , EXA.SEGMENT7 BUILDING_SOCIETY_ACCT FROM PAY_EXTERNAL_ACCOUNTS EXA , HR_LOOKUPS HL WHERE EXA.EXTERNAL_ACCOUNT_ID = :1 AND HL.LOOKUP_CODE = EXA.SEGMENT1 AND HL.LOOKUP_TYPE = 'HD_BANKS'

Oracle Community | 936194 | 9 months ago
  1. 0

    issue with KFF

    Oracle Community | 9 months ago | 936194
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT EXA.SEGMENT5 ACCOUNT_NAME , EXA.SEGMENT4 ACCOUNT_NUMBER , EXA.SEGMENT3 SORT_CODE , HL.MEANING BANK_NAME , EXA.SEGMENT2 BRANCH , EXA.EXTERNAL_ACCOUNT_ID , EXA.OBJECT_VERSION_NUMBER , EXA.SEGMENT7 BUILDING_SOCIETY_ACCT FROM PAY_EXTERNAL_ACCOUNTS EXA , HR_LOOKUPS HL WHERE EXA.EXTERNAL_ACCOUNT_ID = :1 AND HL.LOOKUP_CODE = EXA.SEGMENT1 AND HL.LOOKUP_TYPE = 'HD_BANKS'
  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 EXA.SEGMENT5 ACCOUNT_NAME , EXA.SEGMENT4 ACCOUNT_NUMBER , EXA.SEGMENT3 SORT_CODE , HL.MEANING BANK_NAME , EXA.SEGMENT2 BRANCH , EXA.EXTERNAL_ACCOUNT_ID , EXA.OBJECT_VERSION_NUMBER , EXA.SEGMENT7 BUILDING_SOCIETY_ACCT FROM PAY_EXTERNAL_ACCOUNTS EXA , HR_LOOKUPS HL WHERE EXA.EXTERNAL_ACCOUNT_ID = :1 AND HL.LOOKUP_CODE = EXA.SEGMENT1 AND HL.LOOKUP_TYPE = 'HD_BANKS'

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