Oracle Transactional Business Intelligence

Products Banner

Display photographs in OAC Analysis



Display photographs in OAC Analysis


Facing a strange issue in OAC while displaying photos.

Customer is capturing photographs of readings.  These photos are being stored as a BLOB in ATP.  Customer is looking for a report with all the transactions and the corresponding photographs in a report.  We can see the data in OAC Analysis, but strangely only a part of the photograph is visible in the report.

As per Oracle Support this feature is not supported.  Is there any workaround that can be implement?  Is there a possibility that we convert the BLOB to some other datatype?

Any suggestions?


  • Hi Saurabh,

    can you please let me know how you have loaded images into ATP.




  • Nathan CCC
    Nathan CCC ✭✭✭✭✭


    1. "As per Oracle Support this feature is not supported"

    Please reference the thing you reference here. As per what support? Are you getting this from a certification matrix? Which sheet, tab, row, cell? Or an artilce we can read on Which feature exactly? If you can see the data in an analysis then you are selecting from a presentation table and column in a metadata repository database (RPD)? Did you build the RPD? How is the BLOB mapped to the physical layer?

    2. What version of OBI are you using?

    This question is not about the usual technology on this forum. You state "OAC Analysis". So you have built an analysis using "Classic" home using menu "New" "Analysis" in legacy Oracle Business Intelligence (OBI) in Oracle Analytics Cloud (OAC)? With some sort of data source query a binary large object (BLOB) from autonomous transaction processing (ATP) database. The reason I ask is that is a different version of OBI from the much much older Oracle Business Intelligence (OBI) product in Oracle Transactional Business Intelligence (OTBI) in Oralce Cloud Applications such as Financials, Procurement, Projects etc. which is traditionally the topic of this forum. This forum is for Software as a service (SaaS). Other than Analytics for Applications OAC is not SaaS but PaaS. Maybe you should post on that forum for OAC?