Maximo

Maximo

Come for answers, stay for best practices. All we're missing is you.

 View Only
  • 1.  Disable: Asset attachment automatically applied to WO

    Posted Thu August 26, 2021 12:37 PM
    Edited by System Admin Wed March 22, 2023 11:53 AM
    MAM 7.6.1.2:

    Work Order Tracking:


    If I add an asset that has an attachment to a WO, the asset's attachment gets automatically applied to the WO.

    Questions:
    1. What mechanism is responsible for that behavior?
    2. How can I disable it?

    Thanks.
    #AssetandFacilitiesManagement
    #Maximo


  • 2.  RE: Disable: Asset attachment automatically applied to WO

    Posted Fri August 27, 2021 05:37 AM
    Hi,

    The links are controlled by a relationship from the WORKORDER object to DOCLINKS called DOCLINKS.

    If you go to the Database Configuration app you will be able to see this complex relationship and all the associated objects that it will display the document for e.g. Asset, Location, Safety Plan etc

    Make sure you test any updates to the sql first using your favourite SQL tool e.g. I use SQLDeveloper as it is easy to mess these up if you get the brackets in the wrong place :-)

    ------------------------------
    Steve Lee
    Maximo Technical Sales Specialist
    IBM
    Leeds
    ------------------------------



  • 3.  RE: Disable: Asset attachment automatically applied to WO

    Posted Fri August 27, 2021 09:25 AM
    It's not actually "added" (or copied) to the Work Order.  It is referencing the asset's attachment.  As Steve has already mentioned, you could also end up with attached documents referenced from several other sources, which you can see in Database Configuration by fetching the WORKORDER table and looking for its relationships to the DOCLINKS child table.

    To disable it, you could:
    1) Rewrite the existing relationship (I don't recommend that)
    2) Create your own custom relationship then change WOTRACK's design.  Clicking on the Attachments icon and choosing View Attachments. . .that stuff is all coming from other sources such as LIBRARY.XML, so you'd have to find all the components that make that work and copy them into the WOTRACK.XML file.  When calling out to an event like that Maximo looks locally first within the application XML, then goes out to the system XML files.  Anyways, once you have a local copy, you could modify that one (so the rest of Maximo wouldn't be affected). Change it so that it uses your custom relationship.
    3) Much like option #2 above, get the XML pieces locally in WOTRACK, and set a default value filter on the table.​  This way, the referenced files are still there, they're just not seen by default.

    FWIW: On ALL applications that have Attachments, I took that "View Attachments" code and put that as a child table on the main tab of the application.  This was helpful for when a record had attachments and someone duplicated the record, because the Attachments would duplicate too.  For things like PO's and Invoices, many times we didn't want those Attachments duplicated -- like a PO from 5 months ago would have a shipping document attached that was entered in Receiving.  So we duplicate that in a new PO now -- that shipping document doesn't make sense with the new PO.  Anyways, with it on the main tab, it's very easy to use approach #3 above.​

    ------------------------------
    Travis Herron
    ------------------------------



  • 4.  RE: Disable: Asset attachment automatically applied to WO

    Posted Fri August 27, 2021 09:51 AM
    Steve & Travis are probably correct in your scenario that the attachments are being shown on the WO but are only associated to the ASSET. When you view the attachments it will show you what object they are associated with which should help you determine if that is what is happening.

    There is, however, functionality that a lot of people aren't aware of that will actually copy the attachment to the WO as a direct attachment. On the DOCLINKS record itself there is a "COPYLINKTOWO" flag that can be set. When this is set to 1, and a system setting is enabled, Maximo will actually create an attachment reference directly on the WO. The system setting is found by going to the Organizations application and opening the System Settings dialog. Scroll down to the Work Order settings and you'll see the option. If you disable this, even if the flag is set on the attachment, it should no longer create a doclink record for the WO.



    ------------------------------
    Steven Shull
    ------------------------------