ORA-29275: Partial Multibyte Character Querying IBY_EXT_BANK_ACCOUNTS
Last updated on NOVEMBER 16, 2017
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?
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