ORA-29275: Partial Multibyte Character Querying IBY_EXT_BANK_ACCOUNTS (Doc ID 806024.1)

Last updated on OCTOBER 18, 2016

Applies to:

Oracle Payments - Version 12.0.4 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.

Symptoms

When querying table IBY_EXT_BANK_ACCOUNTS_V from an SQL environment (SQL*Plus or Toad), the query does not retrieve any data is and is receiving an error ORA-29275: partial multibyte character.

This view is created using multiple tables all allowing the viewing of their data accept for IBY_EXT_BANK_ACCOUNTS which is generating the same error. It was found that the error is thrown when trying to query the following fields from table IBY_EXT_BANK_ACCOUNTS:

eb.bank_account_num_hash1,
eb.bank_account_num_hash2,
eb.iban_hash1,
eb.iban_hash2

This problem doesn’t seem to be affecting the application, only the querying of data in AR_CASH_RECEIPTS_V.


Question: why does this error occur when the above table is queried from an SQL environment?
Will the application be affected by this behavior?

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms