R12 ARXCCU Credit Limit Usages Report Fails to Submit With 'APP-FND-01564: Oracle error 1406 in FDFGVD'
Last updated on JUNE 05, 2018
Applies to:Oracle Receivables - Version: 12.0.3 to 12.1.2 - Release: 12.0 to 12.1
Information in this document applies to any platform.
On 12.0.3 in Production:
When attempting to run the Credit Limit Usages Report,
the following error occurs while submitting the report
APP-FND-01564: Oracle error 1406 in FDFGVD
Cause: FDFGFD failed due to ORA-1406: fetched column value was truncated
The SQL statement executed at the time of the error was
select organization_id, name value, name description, vnl('N','N'), nvl(to_number(null),-1) ...
where 1=1 and name=:X
-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Navigate to the request submission screen
2. Try to run the Credit Limit Usages Report
-- Business Impact:
The issue has the following business impact:
Due to this issue, users cannot run this report
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms