APAR status
Closed as program error.
Error description
Problem Description When Reserved Items are issues through the Reservations tab of the "Manage Inventory" Work Center, there are problems with the records that are being inserted and/or updated including: 1) The GLDebitAccount on the MatUseTrans record inserted is being set to NULL if the GLAccount on the InvReserve has wildcards (e.g. - "?") in any component. This is a huge problem because the Resource component that indicates the type of expense is usually not set on a WO's GL Account. 2) The GLAccount and Location on the MatUseTrans record inserted on the WO is being overridden by the GLAccount and OpLocation on the InvReserve record although the AssetNum is set to the value on the WO regardless of what is on the InvReserve record. The GLAccount and Location from the WO should be used as well. (This is also a problem when issuing from the "Select Reserved Items" dialog in the "Issues and Transfers" application.) 3) The WPItemID on the MatUseTrans record inserted is not being set to the WPItemID of the WPMaterial that generated the InvReserve record. 4) The ActualQty on the InvReserve record is not being updated although the ReservedQty is being decremented by the quantity issued. The ActualQty should be updated as well. 5) When the remaining ReservedQty is issued, the ReservedQty is still being decremented by the quantity issued rather than deleting the record. It is updating the ReservedQty even if the resulting value is negative. There should not be any InvReserve records with a ReservedQty <= 0. STEPS TO REPRODUCE: 1) Create a new WO in the Bedford Site with Asset set to 12300, which should set the Location to SHIPPING and the GL Account to 6500-300-???, and set the Target Start Date to the System Date. 2) On the Plans / Materials sub-tab, add 2 rows for a Qty of 5 from the CENTRAL Storeroom and set the Item to 0-0048 and 0-0514. 3) Approve the WO. 4) Change the Asset to 11230 and let the Location and GL Account change to BR230 and 6210-327-??? respectively. 5) Go to the "Issues and Transfers" application, search for the Central Storeroom, click on the "Issues" tab, and then on the "Select Reserved Items" dialog. 6) Search for the WO# created in Step 1, select the row for Item 0-0048, and click "OK". 7) Change the Quantity to 3 and SAVE. 8) Go to the "Manage Inventory" Work Center. It should open to the "Reservations" tab and you should see the 2 rows for the WO# created in Step 1. 9) Select the row for Item 0-0514 and click "Issue selected" at the top. 10) Reduce the "Issue quantity" to 3 and click "Issue". 11) In a SQL tool (e.g. - SQLDeveloper), run "SELECT * FROM InvReserve WHERE WONum = '<WONumFromStep1>' ;". You should see that both rows show the ReservedQty as "2" but the row for Item 0-0048 shows "3" for ActualQty while the row for Item 0-0514 shows "0" for the ActualQty. 12) Issue another "3" of Item 0-0048 using the "Select Reserved Items" option. 13) Issue another "3" of Item 0-0514 using the "Manage Inventory" Work Center. 14) Repeat Step 11. You should now see that the row for Item 0-0048 was deleted but the one from 0-0514 is still there with the ReservedQty as "-1". 15) In the SQL tool, run "SELECT * FROM MatUseTrans WHERE RefWO = '<WONumFromStep1>' ;". You should see that all 4 rows show the AssetNum as "11230" (the Asset on the WO) and the Location as "SHIPPING" (the OpLocation on InvReserve) but that the 2 rows for Item 0-0514 show no value in the GLDebitAcct while the 2 rows for Item 0-0048 show the GLDebitAcct as "6210-327-200" (the 1st 2 components coming from the WO's GLAccount and the 3rd from the Inventory record's GLAccount). If between Step 1 and 2 you had changed the GL Account on the WO to specify the 3rd component, you would see that the MatUseTrans records for Item 0-0514 showed that value in the GLDebitAcct instead of the one showing on the records for Item 0-0048 which is the correct one. RESULTS: Negative reservation number and wrong GL account in the transaction table. EXPECTED RESULTS: User expects to see a positive reservation with the correct GL account in the work order record REPORTED IN VERSION: Tivoli's process automation engine 7.6.1.1 IBM Maximo Asset Management Work Centers 7.6.0.4
Local fix
N/A
Problem summary
**************************************************************** * PROBLEM DESCRIPTION: * * IJ32785 RESERVATIONS PROBLEMS WITH GENERATED TRANSACTIONS IN * * MANAGE INVENTORY WORK CENTER. * ****************************************************************
Problem conclusion
The fix for this APAR will be included in a future release
Temporary fix
Comments
APAR Information
APAR number
IJ32785
Reported component name
MAXIMO ASST MGM
Reported component ID
5724R46AM
Reported release
761
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2021-05-20
Closed date
2023-05-02
Last modified date
2023-05-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
MAXIMO ASST MGM
Fixed component ID
5724R46AM
Applicable component levels
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSLKT6","label":"Maximo Asset Management"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"761","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
Document Information
Modified date:
02 May 2023