The storeroom Material Status gets updated with wrong status

Diagnosing The Problem

The following steps have been used to reproduce the problem in maxdemo TPAE 7609.

AFFECTED FIELD In Maximo
Field: Work Package Material Status
Table.Column: WORKORDER.WORKPACKMTLSTATUS

1- Go To Administration -> Organisation Application
- Select your Organisation - EAGLENA
- Under More Action - Inventory Option -> Inventory Default
- Update cost/currency variances on inventory costs? Checked
- Automatically create usage documents for new reservations? Checked
Under Negative Balance Options
Disallow Negative Balance (Selected)
Disallow Negative Available Balance (Selected)

2- Go To Inventory -> Item Master
- Create a new non rotating Item - ex: TEST01
- Under More Action -> Add Item to Storeroom
- CENTRAL
- BIN: 01
- ISSUE UNIT: EACH
- ORDER UNIT: EACH
- Click OK
- Save Record
- Change Status to ACTIVE
- Roll New Status to Organizations and Inventory? Checked

3- Go To Inventory -> Inventory Application
- Filter and select Item created in step 2
- Check all availability should be Zero which is ok.

4- Go To -> Work Order -> Work Order Tracking Application
- Create a new Work Order
- Click on Plans Tab -> Materials tab
- Click on New row button and insert Line Type: Item
- Item: TEST01 (created in step 3)
- Quantity: 2
- Save the Record
- Change Status tp Approved - APPR

RESULT: Status of Work Order is automaically changed to WMATL  which is  OK
Stroreoom Material Status: NONE which is  OK

5- Go To Inventory -> Inventory Application
- Filter and select Item created in step 2
- Under More Action -> Add/Modidfiy Reservations

RESULT: The reservation type is now set to “BACKORDER”. which  is OK With Allow Negative Available Balance in Inventory Option -> Inventory Default the reservation type is always set to APHARD.

6- Still in Inventory
- On Inventory tab - Under Inventory Balances
- Click New Row button
- In Current Balance field add 3
- Click Save Record

NOTE: You get the same result by creating PR/PO and receiving the Item.

7- Go To System Configuration -> Platform Configuration -> Cron Task Setup
- Select the Cron Task “WOMaterialStatusUpdateCronTask” and make it active (if not already so)
- Set the schedule to run every 2 minutes. Reload the request and wait till the cron task has run.

8 - Go To -> Work Order -> Work Order Tracking Application
- Bring Work Order previously created in step 4 and check
- Status is now WMATL  which is OK
- Storeroom Material Status is now NONE which is WRONG
- Next Storeroom Material Status click on Detail Menu Icon (double arrow) -> Current Work Order Storeroom Material
- Required Quantity: 2 which is OK
- Available Quantity: 3 which is OK

WRONG RESULT: Item is not being issued to the Work Order and the storeroom Material Status gets updated with wrong status.

EXPECTED RESULT: There is enough material in the storeroom to fufill the Item requested on the Work Order.