My Oracle Support Banner

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

Last updated on DECEMBER 13, 2018

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.


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:


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?


To view full details, sign in with your My Oracle Support account.

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

In this Document
 Community Discussions

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.