How to store QR code image in Fusion and fetch this image in BI report
Summary:
We have a requirement to store QR code images for ZATCA specific to the Saudi Arabia territory, which need to be retrieved for inclusion in BI reports.
We explored the following approach:
- Attached the QR code image in DOR.
- Created a SQL query to fetch the image link from the Content Server (the link enables downloading the QR code when accessed in a browser).
- Developed an RTF template utilizing the URL tag:
url:{image link}
.
However, after raising an Oracle Service Request, the engineer informed us that images from the content server cannot be displayed in BI reports.
We would greatly appreciate any suggestions or insights from the team regarding alternative methods to achieve this or similar solutions that may have been implemented previously.