We are obtaingin from the invoice the URL attached, but we have an error in the extraction where the excel hyperlink allways point to the first line despite has another value.
Is there a way to show the correct hyperlink in BI?
Hello, Thanks for the quick answers.
We finally find the root cause. Some day we activate the compatibility mode, because after an upgrade some users can't download the reports correctly, and this is the root cause of the issue.
After disbaling this option, the Hyperlink generated by the excel points to the correct cell and the users can use the URLs normally.
Regards,
Ferran
Hi,
It sounds like there is a lot of implicit information in your post.
Because Publisher, as a technical solution, doesn't come with any data, but your post is all about data, it would be helpful if you take a step back and start by describing what product you are using (is that a Fusion application?), what you are doing, where, how.
This will increase the chances to get a helpful reply.
Can you verify your source query? Are you pulling the correct data? If possible share the piece of code to get this url to verify.
Thanks.
Thanks for sharing the resolution with community. Appreciated !!
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…
