My Oracle Support Banner

E1: TC: Flat File With Special Characters Fail to Convert when Table Conversion UBE is Run (Doc ID 2577341.1)

Last updated on AUGUST 18, 2019

Applies to:

JD Edwards EnterpriseOne Tools - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

When running a table conversion UBE which reads data from an input flat file (.CSV) and output the data to EnterpriseOne custom table, the record is not inserted into the table if the flat file data contains special character. the system stops processing if there's any strange character found in the input file. For example, a word like 'Rajongói', 'Telepítő' would not be processed.

The flat file encoding has been set up as UTF8 in P93081 application.

The UBE debug log contains the following error:

TCE009018 - Missing delimiter after column xxx in format yyy

Changes

 

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