APP-FND-01564: ORACLE Error 1406 In Fdxwho (Doc ID 2069643.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Order Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Transaction Entry

When attempting to view the record history in the Sales Order form
or Order Organizer, users receive the following form error:

ERROR
-----------------------

APP-FND-01564: ORACLE error 1406 in fdxwho

Cause: fdxwho failed due to ORA-01406: fetched column value
was truncated.

The SQL statement being executed at the time of the error was:

select USER_NAME from FND_USER where USER_ID =
:user_id and was executed from the file &ERRFILE.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a user with a long user name like:

PR1996XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX@APP-FND.COM

2. Assign "Order Management Super User" responsibility to the user
3. Login with the new user name

4. Create a Sales Order. Save.
5. Click on Help > Record History
6. Error is displayed.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Users can not access history for some orders.

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