Document Record Deep Link in SQL Query - use parameter regarding uploaded document record ID
Summary: There is a requirement for BI report to have direct / deep link to a document record for persons
I found the Deep Link URL and several of its associated parameters. This is what I have in the SQL thus far and it works:
https://POD.WHATEVER.MORESTUFF.oraclecloud.com/fscmUI/faces/deeplink?objType=DOCUMENT_RECORDS_ANY&action=NONE&objKey=pPersonNumber=' || PERSON_NUMBER || ';pDocumentTypeId=' || (select ID from DOCUMENTTYPE_ID_WITH) || ';pDocTypeReadOnly=Y;pMode=VIEW'
The thing is, we need a parameter that takes us right to the precise document record of interest. We prefer to pass in HR_DOCUMENTS_OF_RECORD.DOCUMENTS_OF_RECORD_ID as a parameter to the URL. Is that an option for this Deep Link URL? Thanks!