My Oracle Support Banner

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.

Symptoms

On R12.0 and later, Reports Issues

When running AR Invoice Print Selected Invoices for a specific transaction type, an error occurs.

 
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 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.




STEPS
-----------------------
Run the Invoice Print New Invoices or Invoice Print Selected Invoices for a specific transaction type


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot print the transactions.

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.