APP-FND-01564: Oracle error 1406 in fdfgdf in element rate types EIT following R12 upgrade

(Doc ID 1355650.1)

Last updated on JANUARY 10, 2017

Applies to:

Oracle HRMS (UK) - Version 12.1.1 and later
Information in this document applies to any platform.


When attempting to Enter details in the historic rates flexfield, the following error occurs.

APP-FND-01564: ORACLE error 1406 in FDFGDF

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


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


Steps to Reproduce:
The issue can be reproduced at will with the following steps:

1. Upgrade the application to 12.1.X from 11i.
2. Navigate to the Element > Extra element information > historic rate - rate types flexfield
3. Error message generated



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