4 Replies Latest reply on Oct 9, 2007 6:42 AM by 591060

    Deleteing Old Purchasing Attachments

    591060
      Hello All,

      We currently have A LOT of old purchase order attachments in our purchasing system. These are all kinds of files (.xls, .doc, .jpg, .pdf, etc. etc.) attached to requisitions and purchase orders. They are taking up a lot of space in our database (we think.) I can't find any documentation about managing these attachments

      My questions are:
      - How are these files stored? I think think they are large chunkc of ORABLOB data (or somthing) in the database somewhere... is there a table where these are?
      - What is an effective way to delete old attachments?

      Another question: Everytime a buyer runs a 'Print PO' program, it generates a .pdf output file. I think all these .pdfs are saved with the PO... is this so? And, if so, is there an effective way to manage those? Can I delete those somehow?

      Any information or insight in hopw to effectively manage and maintain the Purchasing attamnets is much appreciated.

      Thanks,
      Mark
        • 1. Re: Deleteing Old Purchasing Attachments
          gareth.roberts
          Hi Mark,

          1. Attachments. Check out:
          http://garethroberts.blogspot.com/2007/08/document-attachments-private-stuff.html
          for some info on attachments.
          The tables that are hit by a given attachment is there.
          Plus potentially use fnd_documents_pkg.delete_row to remove your attachments.

          2. Standard functionality for Print PO does not store the .pdf with the PO, but .pdf is not standard functionality. The .pdf is usually stored in the filesystem $APPLCSF/$APPLOUT which can be purged using O/S methods, plus the Purge Concurrrent Requests to remove the database request information.

          Gareth
          • 2. Re: Deleteing Old Purchasing Attachments
            591060
            Thank Gareth.

            Using fnd_documents_pkg.delete_row seems a bit scary. Have you thought of posting an example on your blog on how the fnd_documents_pkg.delete_row might look? It would have to clean it out from fnd_lobs as well.

            Anyway...thank for your input.
            --M.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           
            • 3. Re: Deleteing Old Purchasing Attachments
              gareth.roberts
              Hi,
              Scary? Maybe ... that was what you asked for !
              Yes ... think I'll have to try the delete and update the blog. On my list of things todo amongst many more ;-)

              Gareth
              • 4. Re: Deleteing Old Purchasing Attachments
                591060
                Hi Gareth,

                Just an FYI, we found a package called fnd_attached_documents2_pkg that contains an API for deleting attachments. We're not really sure how it to use it yet, but we'll let you know if we figure it out.

                Meanwhile, any additional advice is much appreciated!

                Cheers,
                Mark