How to fetch employee signature added as image into RTF template using data model.

Question

we are trying to fetch salesperson image from person table which was added as employee images attachments.

there is no fields in SQl data model to fetch the employee attachments.

how to fetch the employee objects attachments in tables/SQL Queries.

We are working in oracle sales cloud module.

MandeepGupta · Answer

Hi @Manjunath_0707 ,

Welcome to Oracle Analytics community.

PER_IMAGES table capture the images stored for workers in Fusion HCM. You can use person_id to connect to this table.

If the images is uploaded as DOR, then you can use document record tables.

Below notes will be useful:

Fusion Applications - OTBI - BI Publisher - How To Display The Employee Image Stored In The Database OR XML Pulled into The Report ? (Doc ID 1940036.1)

Display Person Image on BI Report

Need to display Employee Image in the BIP report output — Cloud Customer Connect

Thanks.