Fusion : FBL Failing to Load Departments with DFF Fields (Doc ID 1680850.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Fusion Global Human Resources - Version 11.1.7.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.7.0.0 version, File Based Loader

When attempting to load Job using FBL flexfiled PER_JOBS_DFF
the following error occurs.

ERROR
-----------------------
JBO-29000: Unexpected exception caught: oracle.jbo.AttrSetValException, msg=JBO-FND:::FND_VS_VAL_MAX_LEN_EXCEEDED: FND-3109<
java.lang.NumberFormatException: For input string: "value1"
java.lang.NumberFormatException: For input string: "value2"
java.lang.NumberFormatException: For input string: "value3"
java.lang.NumberFormatException: For input string: "value4"
java.lang.NumberFormatException: For input string: "value5"
java.lang.NumberFormatException: For input string: "value6"
java.lang.NumberFormatException: For input string: "value7"



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Prepare source data
2. Load data into Fusion

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot load the job data

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