Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
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