Maximo Open Forum

 View Only
  • 1.  WHERE USED TAB IN INVENTORY SHOWS ASSETS IN ALL SITES

    Posted 13 days ago
    Hello everyone,

    In Inventory application,  Go to the "Where Used" tab. Here we could see that all spare parts assets are displayed from all the sites.


    But the requirement is based on Users default login site, spare parts assets should be displayed.

    When i checked there is a relationship between Inventory and Spare parts 
    itemnum=:itemnum and itemsetid=:itemsetid and assetnum in ( select assetnum from asset where ( moved=:no or status not in
    (select value from synonymdomain where maxvalue in ('DECOMMISSIONED') and domainid='LOCASSETSTATUS') ) and siteid=sparepart.siteid ) and :sitefiltering

    I have modified the above relationship as
    itemnum=:itemnum and itemsetid=:itemsetid and assetnum in ( select assetnum from asset where ( moved=:no or status not in
    (select value from synonymdomain where maxvalue in ('DECOMMISSIONED') and domainid='LOCASSETSTATUS') ) and siteid= (select defsite from maxuser where userid=:userid) ) and :sitefiltering

    but its not working as expected. All the sites related to spare parts assets are visible.
    Maximo is not taking the site into consideration when displaying the assets.

    Kindly help on this requirement. Thanks in Advance.
    #Customizations
    #EverythingMaximo
    #Inventory

    ------------------------------
    Sowndarya Seshadri
    TCS
    ------------------------------


  • 2.  RE: WHERE USED TAB IN INVENTORY SHOWS ASSETS IN ALL SITES

    Posted 12 days ago
    Can anyone please help me on this

    ------------------------------
    Sowndarya Seshadri
    TCS
    ------------------------------



  • 3.  RE: WHERE USED TAB IN INVENTORY SHOWS ASSETS IN ALL SITES

    Posted 12 days ago
    Hi Sowndarya:  I think the problem here is that the relationship does not have a site join specified between the parent object (INVENTORY), and the child object (SPAREPART).  If you add another SITEID join on the end, that should restrict it so it only shows spare parts for the same site as the Inventory record.  So the new relationship Where Clause would be:

    itemnum=:itemnum and itemsetid=:itemsetid and assetnum in ( select assetnum from asset where ( moved=:no or status not in
    (select value from synonymdomain where maxvalue in ('DECOMMISSIONED') and domainid='LOCASSETSTATUS') ) and siteid=sparepart.siteid ) and :sitefiltering AND SITEID=:SITEID

    Note:  I also prefer to add a Where Used tab to the Item Master, using the original relationship, because I think it's occasionally useful for a user in a multi-site setup to be able to see what's happening with other sites.  But that belongs at the Item Master level, not the Inventory level.


    ------------------------------
    Shannon Rotz
    InComm Solutions Inc.
    ------------------------------



  • 4.  RE: WHERE USED TAB IN INVENTORY SHOWS ASSETS IN ALL SITES

    Posted 11 days ago
    Hi  Shannon, Thank you for the reply. I have modified the relationship where clause, Inventory (parent) and Sparepart (child)

    itemnum=:itemnum and itemsetid=:itemsetid and assetnum in ( select assetnum from asset where ( moved=:no or status not in (select value from synonymdomain where maxvalue in ('DECOMMISSIONED') and domainid='LOCASSETSTATUS') ) and siteid=sparepart.siteid ) and :sitefiltering and siteid=:siteid

    But its not working as expected, i am still able to see the spare parts for all the sites.



    Issue is, In Inventory application 'where used' display tab, this tab displays all spare parts for all the sites and not for the user's default login site.
    I want the requirement to be display all the spare parts according to user's default login site.

    I have modified the relationship between INVENTORY (parent) and SPAREPART (child), but its not working as expected.
    Should i need to modify any other relationship? Am i missing anything here?

    Kindly help on this. Thanks in Advance

    ------------------------------
    Sowndarya Seshadri
    TCS
    ------------------------------



  • 5.  RE: WHERE USED TAB IN INVENTORY SHOWS ASSETS IN ALL SITES

    Posted 11 days ago
    Hi Sowndarya:  that should have worked, IMO.  A couple of things:
    1.  Try removing the :sitefiltering variable and see what happens.  I suspect that may be the problem.  (Note:  removing it may have other consequences)
    2.  If you check in Application Designer, is this the relationship that's actually being used on the screen?  



    ------------------------------
    Shannon Rotz
    InComm Solutions Inc.
    ------------------------------



  • 6.  RE: WHERE USED TAB IN INVENTORY SHOWS ASSETS IN ALL SITES

    Posted 3 days ago
    Hi Shannon, This works after the modification of new relationship. 

    Thanks for your help

    ------------------------------
    Sowndarya Seshadri
    Accenture
    ------------------------------