Custom ESS job output is in different format for Excel template. That is not in readable format and it is not in ANSI. I have recreated excel template many times but still same issue. However it is working fine with RTF template. Kindly suggest.
Hello Lakshmi,
Even we are facing this issue post-23D upgrade and, Oracle is investigating this which I found in the below Support document,
Excel output is generated with Junk characters when downloaded from the Report Job History page (Doc ID 2990643.1)
As an alternate, when you click on republish it downloads the correct file without any junk characters.
Regards,
Guru
Hi @ Lakshmi Bandlamudi ,
What version of Excel template are you using? can you refer below MOS and let me know if its help for your case.
E-BI/XMLP: Opening A BI/XML Publisher Output File Throws Error: "The file you are trying to open, is in a different format than specified by the file extension." (Doc ID 1267445.1)
Regards
Arjun
Hi @Mallikarjuna Kuppauru-Oracle - Excel Version 2309 Build 16.0.16827.20278.
Thanks for the sharing the link. However the issue is not resolved. Kindly suggest.
Hi @Lakshmi Bandlamudi
Are you seeing this issue for all the ESS jobs or specific to any one job?
As of now I have created only one custom job for Excel template type
Are you seeing any Error/warning during ESS job execution or did you get the chance to review the logs ?
Hi @Mallikarjuna Kuppauru-Oracle
Program is in completed status. Log file also normal,no specific information mentioned. Excel file output is coming in this format.
HI Team,
I am facing issue with Excel Template report output generating Junk Characters in Fusion.
Issue :-> Excel output is generated with Junk characters when downloaded from the Report Job History from BI Console page and this happened After 23D Upgrade. Kindly help me any one resolve the issue
Hi ,
It is a known issue post-23D upgrade and, Oracle is investigating this which I found in the below Support document,
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…
