Fusion : FBL Error When a Double Quote is Contained for a Flexfield in an Input Dat File (Doc ID 1644671.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Fusion Global Human Resources Cloud Service - 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 the Person DFF that is configured on the Attribute14 with a value set - "Text Area"
if the the value contain a double quote ("), the process fails with the below error

 
ERROR
-----------------------
HRC_SQLLOADER ORA-06501: PL/SQL: program error ORA-06512: at "FUSION.HRC_SQLLOADER", line 1143 ORA-06512: at "FUSION.HRC_SQLLOADER", line 3622



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