We have a requirement to extract data with all string/text fields double quoted and double quotes escaped. How can we best accomplish it? May be in the e-text template?
This is in Oracle Fusion Application - BI Publisher
Hi @User_0ONK7, Here is the documentation for Creating eText Templates: Introduction : An eText template is an RTF-based template that is used to generate text output for Electronic Funds Transfer (EFT) and Electronic Data Interchange (EDI). At runtime, BI Publisher applies this template to an input XML data file to create an output text file that can be transmitted to a bank or other customer. Because the output is intended for electronic communication, the eText templates must follow very specific format instructions for exact placement of data.
More details on : https://docs.oracle.com/cd/E21764_01/bi.1111/e13881/T421739T481436.htm Thanks, Dimple N
What is the type of output file txt or csv?
Attached document should help.
BI Publisher : Double Quotes Get Added To Some Values by Default When Generating CSV Output (Doc ID 2081010.1)
Thanks.
@User_0ONK7 , Please do not double post, mostly when not adding much compared to the existing question.
Will close the original thread as this one has the same replies for Publisher.
I created a XLSX template in Oracle Analytics Publisher Desktop 26.01.01 and uploaded the template to a BI Publisher report in OTBI. Things worked initially, but this morning when running the report I received an error: The report cannot be rendered because of an error, please contact the administrator. Error Detail:…
Hi All, I have a question regarding the BI Publisher Outputs. I have configured the rtf template output as Excel but when the XML Report Publisher program completes and I click on View Output, the output opens in a browser and renders as an HTML. Can some one please assist why this is so. The BI Publisher version is…
The issue is related to the NordPass browser extension installed via our corporate policy. Issue observed: Users were unable to upload custom BI Publisher templates in Oracle Fusion (BI Publisher / Oracle Analytics) using Microsoft Edge and Google Chrome. The upload dialog remained indefinitely at "Uploading, please…
Hi, We are scheduling a report to be sent out every week. We were wondering if it was possible to keep the latest date that the report ran as a parameter somewhere so that we could use that to only fetch the values in the report which have a latest update time of after the last run of the report? This way we'd only be…
