Image file display using OAC

Amrita Gupta-Oracle

Summary:

We have a requirement to display image files in OAC. The files will be downloaded from Fusion using an API calls. We have the option to store it as a BLOB in DB Tables.

Or, the files could be written to object storage.

What would be the best approach to use, to display images through OAC (without requiring users to re-authenticate).

Content (required):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

Subhakara Netala-Oracle

Hi Amrita,

What would be the size of the image? are these dynamic with data or standard images? BLOB/CLOB datatype may not work in OAC/BI. Distinct function can not be applied on these but BI Server always forms query with distinct. If your images are standard then you can save those in OAC Custom image folder in Web Catalog from there you can provide path on reports.

Amrita Gupta-Oracle

Hi Subhakara,

Thanks for your response. The images are of invoices. Therefore, since the number of invoices are very large, the number of images are also very high in number. Based on the invoice number, the image should be displayed, by clicking on a link available in a detail report.

Yes, CLOB/BLOB is not supported in OAC. In OBIEE there seems to be a work around by using Java script, which is not supported by Oracle. Not sure if it is supported in OAC. Wanted to find out what the best approach would be?

Jahnavi-Oracle

Hi Amrita,

I recently saw a webinar (https://www.youtube.com/watch?v=wtbUzh2Wq1M) in which the image files are stored in object storage bucket for OAC visualization. you can check it out the video from 32.02 for reference. Not sure if it is the best apprach but yes its one way to use.

ALOK SH-Oracle

Hi Amrita,

If BI Publisher is available in the project then you can create parameterized BI publisher report , BIP reports support BLOB data type then you can pass parameter from OAC to view the respective image.

Amrita Gupta-Oracle

Thanks Alok, will test this approach.