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 JULY 12, 2017

Applies to:

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


Symptoms

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.

 

Changes

R12.0.6 upgrade

Cause

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 hundreds of Community platforms