Maximo Open Forum

 View Only
  • 1.  Work Order Tracking WMATL Status Update

    Posted 06-06-2024 08:32

    Hello More Maximo Community,

    I need to update the status of a work order to WMATL if the planned material (reserved) quantity is less than the current balance in inventory, specifically when the work order status is one of the following: APPR, PLANNING, INPROG, or WSCH.

    Current Setup:

    Maximo change the status from PLANNING to WMATL when planned material is less that current in hand quantity in inventory.

    However the balance is not get updated after increasing the quantity in inventory.

    Thank you in advance for your support and suggestions.


    #WorkManagement

    ------------------------------
    Anna Max
    QG
    ------------------------------


  • 2.  RE: Work Order Tracking WMATL Status Update

    Posted 06-07-2024 12:50

    What do you mean that the "balance is not get updated after increasing the quantity in inventory"?

    Did you mean to say that the WO Status isn't changing back to the Status it was in before WMATL?  That change is done by a Cron Task with very complex and somewhat convoluted logic and whether or not a WO's Status is changed depends to some extent on how may other WOs require the same Item, when they are needed for the other WOs, and whether your WO has it as a Hard or Soft Reservation.



    ------------------------------
    Julio Hernandez
    Ergonare, Inc.
    ------------------------------



  • 3.  RE: Work Order Tracking WMATL Status Update

    Posted 06-09-2024 02:48

    @Julio Hernandez,

    WOMaterialStatusUpdateCronTask" to run every 1 min but unfortunately it is not working
    Material Status Last Updated) manually system gives the below error.

    "BMXAA4025E - No external default value was found for the internal value APPR in domain WOSTATUS, siteid=, orgid=. Define the appropriate value in the Domains application."

    Moreover, as previously asked, i would like to know, where this status change is configured and defined in Maximo? so i can define the the WO status to be updated to WMATL when you add material with insufficient balance at (APPR, PLANNING, INPROG, or WSCH) status.

    Thanks.
    #workorder #Inventory #WMATL   #WOMaterialStatusUpdateCronTask #crontask



    ------------------------------
    Anna Max
    QG
    ------------------------------



  • 4.  RE: Work Order Tracking WMATL Status Update

    Posted 06-09-2024 07:01

    Hi Anna,

    I'm going to point out firstly for those who don't know that the statuses PLANNING and INPROG are non-standard and therefore I can only guess what internal Maximo status they equate with.  With that said the API doc that Bruno has post does mention INPRG, yet that status of one for a Ticket based application.

    Specifically, from the API doc, it states "This cron task does not change the value of the workorder status."

    Now to paraphrase - you are looking for the work order status to change to WMATL provided that:

    a) the status is in APPR, PLANNING, INPROG, or WSCH

    b) the current balance of any item as noted on the Planned Materials is insufficient i.e. reduced since the work order was approved.

    So, if you want the work order status to be changed to WMATL, you would need to create either an automation script or escalation that monitors the WORKORDER.STOREROOMMTLSTATUS as that changes when the cron task or the manual update is executed on the work order from COMP to NONE.

    I think there is a small chance that you're confusing matters when if at the time of changing the work order to the status of APPR and there are insufficient materials in the storeroom, the work order status actually goes to WMATL, then once there is sufficient materials (usually via a restock from the reorder process), the work order status reverts to APPR.

    WOSTATUS

    Now for that error message (which should not be possible), can you please go and check the WOSTATUS domain and ensure that there is a default selected against one of the internal values for APPR.  That should solve that issue.



    ------------------------------
    Craig Kokay
    Principal Consultant
    COSOL

    email: craig.kokay@cosol.global
    #IBMChampion
    ------------------------------



  • 5.  RE: Work Order Tracking WMATL Status Update

    Posted 07-01-2024 14:29

    Hi @Craig Kokay

    Thank you so much for the insightful explanation, I have tested the status change from WMATL to APPR and it works fine with the reorder process as you mentioned.
    Also, default value error has been resolved by customizing the WOSTATUS domain.
    Your response is much appreciated!



    ------------------------------
    Anna Max
    QG
    ------------------------------