Attachments

Reports

BIP – Query to find attachment details
ByMandeep Gupta 10 June 202110 June 2021

There are multiple objects in Oracle HCM Cloud which support attachments. Often, there is a need to extract the attachment details stored at the object level. All the uploaded attachments are stored in fnd_attached_documents table. Below query is used to extract the attachment details stored at Service Request level in HR Helpdesk. You can replace…

Read More BIP – Query to find attachment details
Security

Security – Role to view document of record attachments on UCM
ByMandeep Gupta 4 March 20214 March 2021

Document of record attachments uploaded by workers in the Fusion HCM resides on UCM server. If there is a requirement to download or view the uploaded attachment on UCM, none of the standard roles like HR Analyst, HR Specialist have the privilege to view the DOR attachments on UCM. To achieve this, a custom role…

Read More Security – Role to view document of record attachments on UCM