Reports Error: Submitting Report with Reporting Level = Operating Unit Raises Error: APP-FND-01564: ORACLE error 1406 in FDFGDF
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
- Submit a Single Request for Transaction Register
- Fill in the parameters, for Reporting Level pick Operating Unit
- For Reporting Context, pick a value - the error is raised
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