My Oracle Support Banner

Data Extraction for Text Data Mart is Generating Invalid Output when Enclosing Character is Set To ' (Quote) (Doc ID 2595752.1)

Last updated on OCTOBER 12, 2019

Applies to:

Oracle Health Sciences Data Management Workbench - Version and later
Information in this document applies to any platform.


On Oracle Health Sciences Data Management Workbench (DMW) version,

When submitting a job for a Text Data Mart from "Data Extraction" tab associated with a Data Model,
the CSV output is generated in the following format:

It would be expected that the table data to be extracted and exported in CSV format.

The issue can be reproduced with the following steps:
1. Create a Data Model of type Text in DMW using the 'Text Export' option for Data Mart.
2. Install the Data Model.
3. Load data into the input table.
4. Go to "Data Extraction" tab.
5. Select the Data Mart Name and click on "Execute" button.
6. Under "Run History", click on "View Output" corresponding to the submitted job.
7. From "Data Extracts Output", select the .csv name and click on "View" icon.
8. Verify the CSV file contents.


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

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