Total Pageviews

Tuesday, February 26, 2019

How to get profile Images in OTBI Report


How to get profile Images in OTBI Report:

1.Take Person Real Time Subject Area in analysis.
2. Take two columns i.e one Person Number and other Person Id.
3. In person Id column click in options (settings button) and click on edit formula.

In the formula paste the below one:

'<img src="https://dtyoot.fa.ap1.oraclecloud.com/hcmUI/personImage?personId='||CAST("Worker"."Person ID" AS char)||'">'

Note: In the formula which is in red color there replace with your instance.

After that save the report and open the report then we will get the images of the employees.

Follow the below screenshots while doing this:








Disadvantage: When we export the report the we won't get the images in the export files.

It may helpful for you. please visit blog for more information and share your ideas.

Thanks,
Sainath

2 comments:

  1. Hello Sainath,

    We are not getting image in OTBI report instead it is showing the hyperlink, it will not show any image in results tab.

    ReplyDelete
  2. Hi Sainath

    Thanks for this. I have perform additional steps to get the photo displayed. Otherwise, I'm getting html markup only.

    Go to Column Properties > Data Format
    - Check Override Default Data Format
    - Treat Text As "HTML"

    Thanks
    Aslam

    ReplyDelete

Enable Advanced Edit in HCM Extracts- After 24A update

 Enable Advanced Edit in HCM Extracts- After 24A update After 24A update Oracle deprecated the advanced edit in HCM Extracts. To Enable the ...