Reporting and Analytics for ERP

Get Involved. Join the Conversation.

Topic

    Caio Zioli
    Table name that stores purchase order attacmentsAnswered
    Topic posted November 7, 2019 by Caio ZioliGold Trophy: 10,000+ Points, tagged BI Publisher, Fusion Procurement reporting, Reports 
    43 Views, 1 Comment
    Title:
    Table name that stores purchase order attacments
    Content:

    Hi all, please, we are developing a report that should retrieve the purchase order's attachment name. Do you know the table name where attachments are registered ?

     

    kind Rgds

    Best Comment

    Nishanth B Jain

    Base tables for attachment related information is FND_ATTACHED_DOCUMENTS.
    There are basically 3 types of attachments:

    • URL
    • Text
    • File

    The basic details of all these will be stores in FND_ATTACHED_DOCUMENTS, 
    However, the content of Text and File will not be available in Database. 
    Instead these will be stored in Universal Content Manager (UCM).

    Comment

     

    • Nishanth B Jain

      Base tables for attachment related information is FND_ATTACHED_DOCUMENTS.
      There are basically 3 types of attachments:

      • URL
      • Text
      • File

      The basic details of all these will be stores in FND_ATTACHED_DOCUMENTS, 
      However, the content of Text and File will not be available in Database. 
      Instead these will be stored in Universal Content Manager (UCM).