Table link between Profile attachments and UCM file
Summary
Finding Profile Related attachment in UCMContent
When you upload an attachment in your profile that goes to UCM as a file attachment. But the name of the file needs to link back to the record. To do this run this query
SELECT
e.PERSON_NUMBER,
f.LAST_NAME,
f.FIRST_NAME,
d.FILE_NAME,
d.DM_VERSION_NUMBER DOCUMENT_ID
,d.DM_DOCUMENT_ID UCM_FILE
FROM
HRT_PROFILES_B a
JOIN HRT_PROFILES_TL b on a.PROFILE_ID=b.PROFILE_ID and b.LANGUAGE='US'
JOIN FND_ATTACHED_DOCUMENTS c on a.PROFILE_ID=c.PK1_VALUE and c.ENTITY_NAME='HRT_PROFILES_B'
Tagged:
8