3 Replies Latest reply on Oct 23, 2009 9:55 AM by S.PDASH

    PO attachments

    608027
      How can I view the contents of an attachment in a PO report?Obviously,if there is a file attached, I cannot view it; but in case we have short text or long text as attachments, is there any way we can view that in a report? Our requirement is that a hard copy of the PO needs to go to the vendor.If the attachments are missing, then there is no point in sending the PO.Any suggestions?

      Thanks.
        • 1. Re: PO attachments
          578444
          Hello,

          There are few tables where these informtions are being stored.

          fnd_documents
          fnd_document_datatypes
          fnd_document_categories_tl
          fnd_attached_documents

          As per your requirement you can join these tables & get the exact details.

          Rgds,
          Jyoti
          • 2. Re: PO attachments
            S.PDASH
            Method-1
            =====
            Define Standard Attachments
            Navigation: Setup > Attachments

            Category          To Supplier
            Description          General Attachment

            Source
            Date Type          File
            File          GENERAL TERMS AND CONDITIONS.doc

            PO: Terms and Conditions File Name_

            For e-mailed of purchase orders this profile identifies the name of the optional terms and conditions file. This text file needs to be placed in one of the directories specified in the UTL_FILE parameter in the INIT.ORA file and the file path indicated by the profile PO: In File Path.
            PO: Terms and Conditions filename

            Create a PO and generate the standard report (Printed Purchase Order Report)... Let us know if it is working for you or not..

            Regards,
            S.P DASH
            • 3. Re: PO attachments
              S.PDASH
              Hi,
              You can refer Doc ID: 554507.1 for details.

              Regards,
              S.P DASH