Hi, My report has been encoded in UTF-8 BOM, and the customer wants UTF-8 not BOM.
Is there option to change the encoding method? how can I do it?
Thanks all!
Hi @TMR KRS,
Need to turn-off 'Add UTF-8 BOM Signature' from Runtime Property for that report.
Please take a look into the following Oracle note which might be useful and have the steps to follow.
https://support.oracle.com/knowledge/Oracle%20E-Business%20Suite/2612728_1.html
Hope this help.
Cheers,
Hi @Bhaskar Konar, Thanks for the quick response and the links, it helped me a lot!
But-
I turned it to be False:
But nothing changed - the output is still encoded in UTF-8 BOM.
I did something wrong?
Have you tried clearing the BI cache?
If not, please give it a try.
Please find below high level steps:
1. Clear BI Publisher cache: Administration > Manage Publisher > System Maintenance > Manage Cache > Click "Clear Object Cache" and "Clear Metadata Cache".
2. Reload Files and Metadata: Administration > Maintenance and Troubleshooting > Click "Reload Files and Metadata".
3. Logout > Clear browser Cache & Cookies > Close the browser.
4. Re-Login and Re-Test.
Hi @Bhaskar Konar, Thanks again for the long and detailed answer.
I'm sorry, I did all above, and it is still UTF-8 BOM :(
such obstinate…
Is there other thing I can try?
Sorry to hear that.
Let's see if anyone else has any solution for this.
If we're not getting any solution, please raise with Oracle Support.
Hi @Gianni Ceresa, @SteveF-Oracle,
Hope you're well.
Need your expert opinion. can you please suggest?
Thank You!
Hi @Bhaskar Konar and all,
Finally, the problem was solved.
Thanks everyone!
Can you please share the solution with community so that it will be helpful for anyone looking for a similar answer in future?
Thanks.
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…
Hi everyone, I'm using Oracle BI Publisher version 12c and recently I notice a strange error: when I schedule some reports that use excel templates (.xls), their output can not be opened without the error message "The file format and extension of <report_name> don't match. The file could be corrupted or unsafe. Unless you…
Hi everyone, We configured a SOAP connection in Oracle Integration Cloud (OIC) using OAuth authentication. However, when we run our integrations, the SOAP invocation fails intermittently. Some integration iterations fail. Most iterations succeed. Sometimes, all iterations complete successfully without any issues. When we…
OTM/GTM Product is currently using OAC for reporting. We wanted to know what is the limitation for oracle BI Publisher rtf template size. We already have verified the documentation : https://docs.oracle.com/en/cloud/paas/analytics-cloud/acpmr/top-faqs-design-publisher-reports.html But wanted to know if this generic figures…
Hi, We are trying to retrieve the complete history Bip report of assignment updates where the same assignment record has been modified multiple times with an unchanged Effective Start Date. We are currently using PER_ALL_ASSIGNMENTS_M and PER_ALL_ASSIGNMENTS_M_; however, the data returned does not consistently reflect all…