Fusion SR Attachments: Missing UCM Content ID (DM_DOCUMENT_ID) for UI-Uploaded Files in BI Publisher

Kavi-IOTX

I am working on an Oracle Fusion (Service/CRM) requirement where I need to display Service Request attachments in a BI Publisher report along with their UCM details, specifically the content ID (dm_document_id / dDocName) and version ID (dm_version_number) to construct GET_FILE URLs. I am querying FND_ATTACHED_DOCUMENTS and FND_DOCUMENTS_VL and can successfully retrieve these values for attachments uploaded via REST API; however, for attachments uploaded directly through the Fusion UI, the DM_DOCUMENT_ID is coming as NULL while other metadata is available. I would like to understand whether this is expected behavior, where the UCM content ID is stored for UI-uploaded attachments, and if there is any alternative table, view, or supported approach in BI Publisher to retrieve the content ID for all attachments (both UI and API uploaded). Any clarification or documentation reference would be very helpful.

Gianni Ceresa

Welcome to the Oracle Analytics and AI community and forum.

Your question is about Fusion and it's features (Publisher is the technical tool you where you report is, but your question is about Fusion data and features).

Fusion is covered in a parallel, fully independent, forum: https://community.oracle.com/customerconnect

You will see it has lot of categories, including some about analytics and reporting in Fusion, which is the right place where to ask Fusion data questions.