error when we try to export invoice line details from invoice work bench
Hello,
Customer on 12.1.3 encounters the following issue:
We are getting below error when we try to export invoice line details from invoice work bench.
Cause: FDFGCD failed due to ORA-01406: fetched column value was truncated.
The SQL statement being executed at the time of the error was: SELECT ENABLED_FLAG, SUMMARY_FLAG, NVL(TO_CHAR(START_DATE_ACTIVE, 'J'), 0),NVL(TO_CHAR(END_DATE_ACTIVE, 'J'), 0),SEGMENT1, INVENTORY_ITEM_ID FROM MTL_SYSTEM_ITEMS_B WHERE ORGANIZATION_ID = :num AND INVENTORY_ITEM_ID = :id and was executed from the file &ERRFILE.
Navigation:
Open the invoice, go to lines and then File->Export