RAXINV: Invoice Print Program Errors When Printing For A Specific Transaction Type - APP-FND-01564: ORACLE error 1406 in FDFGVD
(Doc ID 2417614.1)
Last updated on JULY 03, 2018
Applies to:Oracle Receivables - Version 12 and later
Information in this document applies to any platform.
On R12.0 and later, Reports Issues
When running AR Invoice Print Selected Invoices for a specific transaction type, an error occurs.
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 TRX.TRX_NUMBER,TRX.TRX_NUMBER VALUE, SUBSTR( L1.MEANING || ' : ' || TYPE.NAME,1,30) 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 RA_CUSTOMER_TRX TRX, RA_CUST_TRX_TYPES TYPE, AR_LOOKUPS L1 WHERE ( TRX.COMPLETE_FLAG = 'Y' AND TRX.PRINTING_OPTION = 'PRI' AND TRX.CUST_TRX_TYPE_ID = TYPE.CUST_TRX_TYPE_ID AND TYPE.TYPE = L1.LOOKUP_CODE AND L1.LOOKUP_TYPE = 'INV/CM' AND TYPE.TYPE = NVL( :b1, TYPE.TYPE ) AND TRX.CUST_TRX_TYPE_ID = NVL( :b2, TRX.CUST_TRX_TYPE_ID ) AND TRX.CUSTOMER_TRX_ID IN (SELECT MAX(TRX2.CUSTOMER_TRX_ID) FROM RA_CUSTOMER_TRX TRX2, RA_CUST_TRX_TYPES TYPE2, AR_LOOKUPS L2 WHERE TRX2.COMPLETE_FLAG = 'Y' AND TRX2.PRINTING_OPTION = 'PRI' AND TRX2.CUST_TRX_TYPE_ID = TYPE2.CUST_TRX_TYPE_ID AND TYPE2.TYPE = L2.LOOKUP_CODE AND L2.LOOKUP_TYPE = 'INV/CM' AND TYPE2.TYPE = NVL( :b3, TYPE2.TYPE ) AND TRX2.CUST_TRX_TYPE_ID = NVL( :b4, TRX2.CUST_TRX_TYPE_ID) AND TRX2.TRX_NUMBER = TRX.TRX_NUMBER) ) AND TRX.TRX_NUMBER = :X and was executed from the file &ERRFILE.
Run the Invoice Print New Invoices or Invoice Print Selected Invoices for a specific transaction type
The issue has the following business impact:
Due to this issue, users cannot print the transactions.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!