My Oracle Support Banner

E1: RDA: The CSV Output Created by an UBE Becomes Misaligned Because Fields Added to the CSV File Are Containing Double Quote Marks (") (Doc ID 2895317.1)

Last updated on SEPTEMBER 13, 2022

Applies to:

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

Symptoms

A special designated UBE is used to create a CSV flat file containing data from database. There are several text fields which are required to have double quote marks (") or comma (,).

The data shown in JD Edwards EnterpriseOne application or Databrowser, looks like this:

a. In the application used to manage the data:

b. In Databrowser:

After the UBE processes the data, the resulting CSV file has the following content:

If the CSV file is opened in Microsoft Excel, the data will look like this:

It is also noted that beside the fact that the columns are misaligned, the invoice number which was stored in CSV as "0000083850" is transformed to number and the leading zeros are missing (83850).

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


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