Document Number is empty in FND_DOCUMENTS_VL table — Cloud Customer Connect
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

Document Number is empty in FND_DOCUMENTS_VL table

Summary:


Hi all,

I have an issue when I try to retrive a file loaded on a Document of Record.

I use this query because I need to retrieve DM_VERSION_NUMBER,DM_DOCUMENT_ID to create the link to retrieve the link from content server, but these fields are empty.

select


FDT.DM_VERSION_NUMBER,
FDT.DM_DOCUMENT_ID,
fad.CATEGORY_NAME ,
DOC_TYPE.DOCUMENT_TYPE,
fdt.file_name,
PN.FULL_NAME
from
HR_DOCUMENTS_OF_RECORD HDR
JOIN HR_DOCUMENT_TYPES_TL DOC_TYPE ON DOC_TYPE.DOCUMENT_TYPE_ID = HDR.DOCUMENT_TYPE_ID
JOIN FND_ATTACHED_DOCUMENTS FAD ON HDR.DOCUMENTS_OF_RECORD_ID = FAD.PK1_VALUE

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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