IBM Support

IZ98721: MAXIMO 6.2.3 TVA -SYSTEM IS DELETING RESERVATIONS ON SCHEDULE DATE CHANGES FOR MATERIALS

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • 1) Execute this update statement to update MAXVAR variable
    "UPDATEWPMATREQDATE" to 1 which triggers required date change on
    planned material if schedule start or target start date changes
    on WO header.
    update maxvars set varvalue=1 where
    varname='UPDATEWPMATREQDATE';
    Restart MAXIMO since MAXVAR values are cached in memory.
    Note: if Maximo is not restarted after executing update
    statement, latest MAXVAR value will not be available.
    
    2) Go to Organizations app'Enter Central'select action "Work
    Order Options"'"Edit Rules"' Enable WP Materials to edit on APPR
    status. Click OK.
    
    
    3) Create new Work Order; specify schedule start date as
    04/09/2011 on WO header. Add new task to WORKORDER. Add stock
    item in planned material for quantity of 1 to task  and approve
    WORKORDER.
    Note: use whatever date but key is schedule start date needs to
    be greater than system date.
    a. Verify required date on planned material is same as schedule
    start date.
    b. Verify enough balances exist in inventory for item selected
    on plan.
    c. Verify reservations got created for task workorder.
    
    
    4) Go to Actual tab on WO, "select reserved items" to select
    reservations for WO. Issue full quantity.
    
    5) Go to WO Plans Tab, Add same stock item in planned material
    for quantity of 1 to task work order and save WORKORDER.
    a. After save, Verify new reservation got created for material
    added.
    
    
    6) On WO Plans tab, now change schedule start date on task WORK
    ORDER. In this test case, I moved schedule start date from
    04/09/2011 5:03 PM to 05/09/2011 5:03 PM and saved WORKORDER.
    a. Verify required date on planned material and it should be
    modified with schedule start date on task WO.
    b. Verify if system has reserved quantity added on this task
    work order in STEP 5.
    
    
    7) Expected result is that System should reserve quantity for
    material added in step 5.
    Actual result is SYSTEM deleted reservation and we lost
    reservation for material planned on task work order.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Maximo users                                 *
    ****************************************************************
    * PROBLEM DESCRIPTION: In the Work Order Tracking application, *
    *                      planned material reservations are       *
    *                      deleted and not recreated when a work   *
    *                      order's scheduled start date is         *
    *                      modified, and the modification is       *
    *                      propagated to planned materials (when   *
    *                      maxvar UPDATEWPMATREQDATE is set to     *
    *                      true).                                  *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    *                      1) Execute this update statement to     *
    *                      update MAXVAR variable                  *
    *                      "UPDATEWPMATREQDATE" to 1 which         *
    *                      triggers required date change on        *
    *                                                              *
    *                      planned material if schedule start or   *
    *                      target start date changes on WO header. *
    *                                                              *
    *                      update maxvars set varvalue=1 where     *
    *                                                              *
    *                      varname='UPDATEWPMATREQDATE';           *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    *                      2) Go to Organizations app'Enter        *
    *                      Central'select action "Work Order       *
    *                      Options"'"Edit Rules"' Enable WP        *
    *                      Materials to edit on APPR status. Click *
    *                      OK.                                     *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    *                      3) Create new Work Order; specify       *
    *                      schedule start date as 04/09/2011 on WO *
    *                      header. Add new task to WORKORDER. Add  *
    *                      stock item in planned material for      *
    *                      quantity of 1 to task  and approve      *
    *                      WORKORDER.                              *
    *                                                              *
    *                      Note: use whatever date but key is      *
    *                      schedule start date needs to            *
    *                                                              *
    *                      be greater than system date.            *
    *                                                              *
    *                      a. Verify required date on planned      *
    *                      material is same as schedule start      *
    *                      date.                                   *
    *                                                              *
    *                      b. Verify enough balances exist in      *
    *                      inventory for item selected on plan.    *
    *                                                              *
    *                      c. Verify reservations got created for  *
    *                      task workorder.                         *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    *                      4) Go to Actual tab on WO, "select      *
    *                      reserved items" to select reservations  *
    *                      for WO. Issue full quantity.            *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    *                      5) Go to WO Plans Tab, Add same stock   *
    *                      item in planned material for quantity   *
    *                      of 1 to task work order and save        *
    *                      WORKORDER.                              *
    *                                                              *
    *                      a. After save, Verify new reservation   *
    *                      got created for material added.         *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    *                      6) On WO Plans tab, now change schedule *
    *                      start date on task WORKORDER. In this   *
    *                      test case, I moved schedule start date  *
    *                      from 04/09/2011 5:03 PM to 05/09/2011   *
    *                      5:03 PM and saved WORKORDER.            *
    *                                                              *
    *                      a. Verify required date on planned      *
    *                      material and it should be modified with *
    *                      schedule start date on task WO.         *
    *                                                              *
    *                      b. Verify if system has reserved        *
    *                      quantity added on this task work order  *
    *                      in STEP 5.                              *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    *                      7) Expected result is that System       *
    *                      should reserve quantity for material    *
    *                      added in step 5. Actual result is       *
    *                      SYSTEM deleted reservation and we lost  *
    *                      reservation for material planned on     *
    *                      task work order.                        *
    *                                                              *
    ****************************************************************
    * RECOMMENDATION:                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    ****************************************************************
    In the Work Order Tracking application, planned material
    reservations are deleted and not recreated when a work order's
    scheduled start date is modified.
    

Problem conclusion

  • In the Work Order Tracking application, planned material
    reservations are correctly updated when a work order's
    scheduled start date is modified.
    
    
    
    
    
    The fix for this APAR is contained in the following maintenance
    package:
    
      | release\fix pack | REL 6.2.8
    

Temporary fix

Comments

APAR Information

  • APAR number

    IZ98721

  • Reported component name

    ASSETS

  • Reported component ID

    5724R46AS

  • Reported release

    620

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2011-04-12

  • Closed date

    2011-05-18

  • Last modified date

    2011-05-18

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Modules/Macros

  • MAXIMO
    

Fix information

  • Fixed component name

    ASSETS

  • Fixed component ID

    5724R46AS

Applicable component levels

  • R620 PSY

       UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"620","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
09 April 2023