INVIDITM APP-FND-01564: ORACLE error 1406 in FDFGVD
(Doc ID 1445592.1)
Last updated on MARCH 05, 2019
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
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