Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 54 Oracle Analytics and AI Sharing Center
- 26 Oracle Analytics and AI Lounge
- 309 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.4K Oracle Analytics and AI Forums
- 6.6K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 118 Oracle Analytics and AI Trainings
- 23 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Fusion SR Attachments: Missing UCM Content ID (DM_DOCUMENT_ID) for UI-Uploaded Files in BI Publisher
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.
Answers
-
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:
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.
0
