My Oracle Support Banner

BIP CSV Output Is Comma Delimited Even Though the Report Properties Is Defined As One Of The Other Options Semi-Colon/Tab/Pipe (Doc ID 2754577.1)

Last updated on MARCH 24, 2021

Applies to:

Oracle Fusion Financials Common Module Cloud Service - Version 11.13.20.10.0 and later
Information in this document applies to any platform.

Symptoms

CSV output always shows as comma delimited even though the CSV Delimiter is defined as "Semicolon(;)"
The same issue occurs when defining the CSV Delimiter to: Tab(\t) or Pipe(|)

Steps to reproduce:
1. From Administration > Runtime Configuration > Properties > CSV Output > CSV Delimiter : Semicolon(;)

 

 

2. From the Report Properties, set CSV Output > CSV Delimiter : Semicolon(;)

 

 

3. Run the report and change the Output format to CSV.

 

 

4. See that the report is still Comma delimited

 

Changes

 
Followed steps documented in these notes:
<Note: 2735830.1> BIP Report's CSV Delimiter ocassionally ignored
<Note: 2535673.1> How To Show BI CSV Report Output In Comma/Semi-Colon/Tab/Pipe Delimiter?

 

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.