Hi Everyone,
In this post , we will see how to download an attachment from UCM Server. And this link can be provided in BI Report for users / client to see the attachments uploaded.
First let us know about UCM Server
UCM - Universal Content Management
Access link: https://<host>/cs
It can be used to upload FBDI Files
Can be used in OIC
Any attachment added in Fusion, will get saved in this server
To add link bi report to download:
'https://<host>/cs/idcplg?IdcService=GET_FILE&dID='|| dm_version_number|| '&dDocName='
||TITLE_column
Example for Receipts (GRN):
SELECT rti.interface_transaction_id,
rti.header_interface_id,
nvl(fdv.DM_VERSION_NUMBER,FFUT.DM_VERSION_NUMBER) version1,
fdv.TITLE,
fdv.file_name,
'https://'
|| (
SELECT
external_virtual_host
FROM
ask_deployed_domains
WHERE
upper(admin_host) LIKE 'FA%'
)
|| '/cs/idcplg?IdcService=GET_FILE&dID='
|| nvl(fdv.DM_VERSION_NUMBER,FFUT.DM_VERSION_NUMBER)
|| '&dDocName='
|| fdv.TITLE
|| '&allowInterrupt=1' AS attach_url
FROM
FND_aTTACHED_DOCUMENTS FAD
, Rcv_transactions_interface rti
,FND_FILE_UPLOAD_TRACKERS FFUT
,fnd_documents_vl fdv
WHERE 1=1
and pk1_value(+)=rti.interface_transaction_id
and ffut.document_id(+)=fad.document_id
and fdv.document_id(+)=fad.document_id
and fad.ENTITY_NAME='RCV_TRANSACTIONS'
