How the get the Candidate Resume from SQL Query
How the get the Candidate Resume from SQL Query
dm_version_number column value is not populating in fnd_documents_tl table
SELECT
fdt.file_name,
fdt.dm_version_number document_id,
fdt.dm_document_id UCM_file,
'https://<YOUR POD NAME>/cs/idcplg?IdcService=GET_FILE&dID='
|| fdt.dm_version_number
||'&dDocName='
|| fdt.dm_document_id
|| '&allowInterrupt=1' UCM_file_link
from fnd_documents_tl fdt
where fdt.DOCUMENT_ID= 300002915713877 and language='US'
Tagged:
0