Maximo Open Forum

 View Only
  • 1.  Display PR Work Log Entries on other Maximo Forms

    Posted 03-16-2023 11:06
    Edited by Shannon Stommel 03-16-2023 16:31

    We are wanting to display PR Log entries on the PO form so users can see the history or notes added by the tech before approving the PO.

    I tried using the steps in the following document, but this is only for when you want to add a work log to a new app that doesn't already have the Log Tab.  The PR and PO form already have the Log tab, and new entries can be added to the WORKLOG object having the class of PR or PO.

    Add Work Log Functionality to other Maximo Objects – A3J Group

    I added a new relationship on the PO object to the WORKLOG object, even though I don't think that is needed as there are 3 relationships with WORKLOG having the where clause null.

    I added a new Log Tab named PR Log on the PO form with the relationship being the new relationship created above, however the PR log is still not showing on the PO.

    Any ideas for how to accomplish this?

    Create a new system property like psdi.worklog.workorder.useWOrelationship?


    #MaximoApplicationSuite

    ------------------------------
    Shannon Stommel
    Insteel Wire Products
    ------------------------------



  • 2.  RE: Display PR Work Log Entries on other Maximo Forms

    Posted 03-18-2023 11:23

    If you use this in Relationship, you can get WORKLOG associated with PR related to PO.

    class ='PR' AND SITEID =:SITEID and RECORDKEY IN

    (

    SELECT PRNUM FROM maximo.PRLINE WHERE PONUM IN

    (

    SELECT ponum FROM maximo.POLINE WHERE (ponum=:PONUM and polinenum=:POLINENUM and REVISIONNUM=:POREVISIONNUM AND siteid=:SITEID)

    )

    )



    ------------------------------
    Prashant Sharma
    Sedin Technologies
    Connect with me @ https://www.linkedin.com/in/psharmamaximo/

    #IBM Champion 2022
    #IBM Champion 2023
    ------------------------------



  • 3.  RE: Display PR Work Log Entries on other Maximo Forms

    Posted 03-20-2023 09:17

    Shannon,

    Unfortunately there don't seem to be hooks in the psdi.app.ticket.WorkLogSet class that support custom relationships for PO or PR related work logs. Not sure why this is supported from WO/Ticket but not PO/PR.

    There aren't many good options for implementing it yourself either, without sacrificing functionality or writing custom Java code. You can create a custom relationship from PO -> WORKLOG and copy the XML from the library.xml... but at that point you'd be digging into quite a bit of existing capability to get this to work.

    Sorry I won't have a better answer for you.

     



    ------------------------------
    Alex Walter
    A3J Group, LLC
    ------------------------------



  • 4.  RE: Display PR Work Log Entries on other Maximo Forms

    Posted 03-20-2023 09:33

    Thank you for your feedback!

    I created the relationship in the PO object to WORKLOG but the PR logs are still not showing in the PO form even though in PLSQL there is data returned confirming the relationship is correct.  I used the code from the library.xml file also changing the relationship to be the new one I created in the PO (removed the beanclass) without any luck.

    Hoping IBM can add this in the future, as it would be helpful to see the logs from PR-PO-Receiving.

    Thank you for your help!!!



    ------------------------------
    Shannon Stommel
    Insteel Wire Products
    ------------------------------



  • 5.  RE: Display PR Work Log Entries on other Maximo Forms

    Posted 03-20-2023 09:41

    The problem is that the bean class on the table will override your custom relationship. If you remove the bean class, it should use your custom relationship assuming you swap out the default WORKLOG relationship for your own.

    Removing the bean class though will come with its own set of potential troubles. I haven't tested it to know exactly what you'll find. I suspect that it will mostly still work for creating new work logs, but there will be a few things that don't. You'll have to test it and weigh the decision based on those results.

    Hope this helps,



    ------------------------------
    Alex Walter
    A3J Group, LLC
    ------------------------------