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 | 11 months 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

    issue with KFF

    Oracle Community | 11 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 | 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 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