My Oracle Support Banner

NL: When Running "Dutch Labour Cost Agreement Audit Report", Error: APP-FND-01564: ORACLE error 1406 in FDFGDF (Doc ID 2282309.1)

Last updated on SEPTEMBER 07, 2018

Applies to:

Oracle HRMS (Netherlands) - Version 12.1.1 to 12.2 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

When attempting to run Dutch Labour Cost Agreement Audit Report , using an organization with name longer than 30 characters the following error occurs.

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 NAME FROM HR_ORGANIZATION_UNITS WHERE ORGANIZATION_ID=:a1 and was executed from the file &ERRFILE.


STEPS
The issue can be reproduced at will with the following steps:

1. run Dutch Labour Cost Agreement Audit Report
2. for "Employer Name" parameter chose an organization with name longer than 30 characters



Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.