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
Get Started with Redwood for Oracle Cloud HCM   Begin Now

How to read content of the DOR attahment

Content (required):

Hi,

How can we read the content from DOR attachment?

We would like to get the content of DOR attachment in report.

below query gives me UCM id and file name. How to read the content?


SELECT documents_of_record_id,

hdr.document_code,

hdt.document_type,

hdr.dei_attribute_category,

fdv.datatype_code,

fdv.dm_document_id,

ppf.person_number,

fdv.FILE_NAME,

hdr.LAST_UPDATE_DATE,

hdr.LAST_UPDATED_BY,

--hdr.CREATE_DATE,

hdr.CREATED_BY,

FROM hr_documents_of_record hdr,

hr_document_types_vl hdt,

per_all_people_f ppf,

fnd_attached_documents fad,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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