Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
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
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!
Tagged:
1