Oracle Documents of Records link

Content

Hi Guys,

Is there a OBIEE BIP SQL CODE code that can turn the column value into a clickable link, please see image for reference. Here's my current sql code. thanks!

--------------------------------------------------------------------

select 

PAPF.PERSON_NUMBER

,PAPF.PERSON_ID

, PPNF.FULL_NAME

----oracle documents----

, ODM.DOCUMENT_NAME

, ODMT.DOCUMENT_TYPE

, ODMT.FILE_NAME

, ODMT.TITLE

 

----Document Link Test------

,'https://companyportal.com/hcmUI/faces/FndOverview?pEffectiveDate=';

|| TRUNC(SYSDATE)

|| '&pAssignmentId='

|| PAAM.ASSIGNMENT_ID

|| '&fndGlobalItemNodeId=itemNode_workforce_management_person_management&'

|| 'pPersonId='

|| PAPF.PERSON_ID

|| '&fnd=%252FWEB-INF%252Foracle%252Fapps%252Fhcm%252Femployment%252Fmanage%252Fui%252Fflow%252FManageEmploymentTF.xml%2523ManageEmploymentTF%'