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: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

Table name of DocumentAttachment

edited Mar 19, 2019 11:10AM in HCM Integrations 4 comments

Summary

Documents of Records: Need to know the table name for Attachments

Content

Documents of Records: Need to know the table name for Attachments. Below table gives only for the Document of record and not the attachment sub-object.

SELECT A.* FROM HR_DOCUMENTS_OF_RECORD A, PER_aLL_PEOPLE_F B WHERE B.PERSON_NUMBER='11' AND A.PERSON_ID=B.PERSON_ID

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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