Oracle Communities

Oracle Analytics and AI

Child Item

To show person image in oracle HCM BI report

Hi Mates,

I want to build a report showing employee image with his/her record. Actually when I am just writing SQL like below:

SELECT A.PERSON_NUMBER,

B.DISPLAY_NAME,

C.IMAGE

FROM PER_ALL_PEOPLE_F A,

PER_PERSON_NAMES_F B,

PER_IMAGES C

WHERE A.PERSON_ID = B.PERSON_ID

AND B.NAME_TYPE='GLOBAL'

AND A.PERSON_ID = C.PERSON_ID

and A.person_id = <person_id>

this query is working fine but when I am using this sub query or PER_IMAGES table in my main query which is basically showing the succession plan it is showing this error: ORA-00932: inconsistent datatypes: expected - got BLOB. Please help in this regard.

Find more posts tagged with

Accepted answers

All comments

Hi,

Below should help:

Thanks.

https://community.oracle.com/products/oracleanalytics/discussion/comment/48222#Comment_48222

what below?

SiddharthDang-Oracle

Hi @KashifRaza,

Check this support links.

1> How To Expose Files Stored In An Oracle Database BLOB Column Within Analyses and Dashboards (Doc ID 2106746.1)

2>

https://docs.oracle.com/en/middleware/bi/analytics-server/metadata-oas/model-binary-large-object-blob-data-and-character-large-object-clob-data.html#GUID-BB2F6E28-6B6D-468A-AE2D-B58C19DD122B

Check your data type defined and see if it helps.

Regards,

Siddharth Dang

https://community.oracle.com/products/oracleanalytics/discussion/comment/48223#Comment_48223

Looks like link was not posted:

https://fusionhcmknowledgebase.com/2020/05/adding-person-images-to-bi-report/

Thanks.

Chaitanya Mishra

Thanks @MandeepGupta