My Oracle Support Banner

Variable Rent Billing Report(PNVRSUMMR) Error: APP-FND-01564: ORACLE error 1406 in FDFGVD (Doc ID 2139042.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Property Manager - Version 12.1.1 and later
Information in this document applies to any platform.


Variable Rent Billing Report(PNVRSUMMR) errors when lease number given in parameters:

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 LEASE_ID,LEASE_ID VALUE, TO_CHAR(NAME) 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), LEASE_NUM "Lease Number" FROM PN_LEASES_ALL WHERE 1=1 AND LEASE_ID = :X and was executed from the file &ERRFILE.


If No Lease Number passed in parameters report gives details but some leases are missing on output.


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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.