My Oracle Support Banner

Reports Error: Submitting Report with Reporting Level = Operating Unit Raises Error: APP-FND-01564: ORACLE error 1406 in FDFGDF (Doc ID 983431.1)

Last updated on FEBRUARY 07, 2018

Applies to:

Oracle Receivables - Version 12.0.1 and later
Information in this document applies to any platform.
Submission form for concurrent request


When you submit a report with Reporting Level set to Operating Unit, you get the error:

APP-FND-01564: ORACLE error 1406 in FDFGDF
Cause: FDFGDF failed due to ORA-01406: fetched column value was truncated.
The SQL statement being executed at the time of the error was: SELECT ENTITY_NAME, ENTITY_ID FROM FND_MO_REPORTING_ENTITIES_V WHERE REPORTING_LEVEL = :a1 AND ROWNUM=1 and was executed from the file &ERRFILE.

Steps to Reproduce:
Responsibility: Receivables Manager
Navigation: Reports > Accounting

  1. Submit a Single Request for Transaction Register
  2. Fill in the parameters, for Reporting Level pick Operating Unit
  3. For Reporting Context, pick a value - the error is raised
Note this error can be raised in any report that has the Reporting Level / Reporting Context parameters.



R12.0.6 upgrade


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.