Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Possibility to retrieve URL of an attachment stored in SaaS through BI Publisher — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Possibility to retrieve URL of an attachment stored in SaaS through BI Publisher

Received Response
36
Views
7
Comments
edited Apr 6, 2020 12:31PM in Reporting and Analytics for SCM 7 comments

Summary

URL of attachments stored in UCM

Content

Hi,

I am trying to find a way to extract via BI Publisher the URL of an attachment stored in the UCM.

I have checked in the following tables:

  • FND_ATTACHED_DOCUMENTS
  • FND_DOCUMENTS_VL
  • FND_DOCUMENT_ENTITIES_VL
  • FND_DOCUMENT_CATEGORIES_VL

but I could only find the information related to the attachment. No details of where it is stored and no direct URL to access the file. Does anyone know if there is a possibility to retrieve the URL?

Version

Oracle Cloud Rel. 20A

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!