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,
Learn how to deploy an AI Data Platform agent, register it to the AI Registry, and introduce it to business users through Agent Hub. This session covers how to prepare an agent for deployment, configure endpoint access and authentication, invoke a deployed agent, and monitor it after deployment. The session also introduces…
hi, We are in ebs R12.2.10 version using Oracle BI Publisher reports. Is support for BI publisher ending soon? what happens to Custom reports? Rgds, Shahnawaz
Hi , We are developing a BI Publisher report to retrieve only Learning Initiatives. We are currently using: WLF_EVENT_ASSIGNMENTS_F WLF_EVENT_ASSIGNMENTS_F_TL WLF_ALL_LEARNING_ITEMS_V WLF_ASSIGNMENT_DESTINATIONS_F We are filtering EVENT_TYPE = 'ORA_REQUIRE_ASSIGNMENT'; however, the results also include other assignment…
Hi Experts, I have a report with simple SQL but large output (140M). Its output file was ,xlsx base on an rtf templete. It always takes time to run. May I know is there any good way to reduce the ruing time of it ? Thanks in advence! Weutao
I have been tasked with creating a run book for ESS jobs. Whilst the queries are centred on the ESS_REQUEST_HISTORY table I would appreciate any suggestions/best practice for implementing a set of reports
Hi,😊 I have a technical issue that I am struggling to resolve. I created an RTF layout, and the preview works correctly when using the BI Publisher Add-in tool. However, when I upload the layout in eText format, the generated report displays only question marks (???) instead of the expected data. I have not been able to…
