You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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'

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!