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 AUGUST 24, 2016

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.

Symptoms

-- 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

ERROR
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


Changes

Fresh Install Release 12 or upgrade from any prior release

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