INVIDITM APP-FND-01564: ORACLE error 1406 in FDFGVD
Last updated on MAY 02, 2018
Applies to:Oracle Inventory Management - Version 12.1.1 and later
Information in this document applies to any platform.
On : 12.1.1 version, Item Issues
After upgrading from 11i to R12.1.3, When users attempt to go to the Item form, enter the DFF and receive error:
APP-FND-01564: ORACLE error 1406 in FDFGVD
Cause: FDFGVD failed due to ORA-01406: fetched column value was truncated.
The SQL statement being executed at the time of the error was: SELECT
LOOKUP_CODE,LOOKUP_CODE VALUE, MEANING DESCRIPTION, NVL('N', 'N'),
NVL(TO_NUMBER(NULL), -1), NULL, NVL('Y', 'Y'), NVL(TO_CHAR(TO_DATE(NULL),
'J'), 0), NVL(TO_CHAR(TO_DATE(NULL), 'J'), 0) FROM FND_LOOKUPS FND_LOOKUPS
WHERE ( LOOKUP_TYPE = 'JLBR_ITEM_ORIGIN' AND NVL(END_DATE_ACTIVE, SYSDATE
+ 1) > SYSDATE ) AND LOOKUP_CODE = :X and was executed from the file
The issue can be reproduced at will with the following steps:
1) Navigate : INVENTORY > Items > Organization Items >
2) When prompted, select organization. Enter Item Number and click Find
3) Click on Global Flexfield and Get the error.
Upgrade from 11i to R12.1.3
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