R12 ARXCCU Credit Limit Usages Report Fails to Submit With 'APP-FND-01564: Oracle error 1406 in FDFGVD'

(Doc ID 550240.1)

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.


-- Problem Statement:
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) ...
from hr_operation_units
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


Fresh Install Release 12 or upgrade from any prior release


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