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 Record Deep Link in SQL Query - use parameter regarding uploaded document record ID

Accepted answer
1
Views
2
Comments

Summary: There is a requirement for BI report to have direct / deep link to a document record for persons


Content (required):

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!

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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