APAR status
Closed as program error.
Error description
If Inventory Options have been configured to not allow negative balances or negative available balances, a negative balance can still be generated by using a Workflow. When a Workflow is configured for the INVUSE object with an action that changes the status of an Inventory Usage record to STAGED, the Inventory Options set to prevent negative balances will be ignored. STEPS TO REPRODUCE: 1) Log in as maxadmin. 2) Go To --> Administration --> Organizations. 3) Choose the EAGLENA organization. 4) Select Action Menu --> Inventory Options --> Inventory Defaults. 5) Ensure that "Automatically create usage documents for new reservations" is checked. 6) Ensure that both "Disallow Negative Balance" and "Disallow Negative Available Balance" are selected. 7) Go to --> System Configuration --> Platform Configuration --> Database Configuration. 8) Filter for the INVUSE object and ensure that "Main Object" is checked. If "Main Object" is not checked for the INVUSE object, do the following: - Check "Main Object" - Save the object - Return to the list view - Select Action --> Manage Admin Mode - Click "Turn Admin Mode ON" - After Admin Mode is confirmed to be on, click OK - Select Action --> Apply Configuration Changes - Click "Start Configuring the Database" - Once that has completed, click OK - Select Action --> Manage Admin Mode - Click "Turn Admin Mode OFF" - Log out of Maximo and log back in as maxadmin once again 9) Go To --> System Configuration --> Platform Configuration --> Workflow Designer. 10) Click the "New Process" icon. 11) Input "INVUSEWF" into the Process field. 12) Input "INVUSE" into the Object field. If multiple objects return, manually choose INVUSE as the object. 13) Click and Drag a "Manual Input Node" in between the default START 1 and STOP 2 nodes. 14) Click on the "Connect Nodes" pencil icon. 15) Click and Drag from START 1 to INPUT 3 and release. 16) Click and Drag from INPUT 3 to STOP 2 and release. 17) The Workflow should appear as START 1 --> INPUT 3 --> STOP 2 18) Right click on the newly added INPUT 3 node and click Properties. 19) Click on the >> "Detail Menu" arrows to the right of the "Action" field and choose "Go To Actions" 20) Click on the "New Action" icon 21) Input "INVUSE" into the Object field. If multiple objects return, manually choose INVUSE as the object. 22) Set "Change Status" as the Type. 23) Input STAGED into the Value field. 24) Save the Action. 25) Click "Return with Value" 26) Click "OK" on the Manual Input Node Properties window. 27) Select Action --> Add Workflow Support To Applications. 28) Place a check in the "Add Support?" checkbox on the INVUSAGE row and click OK. 29) Select Action --> "Validate Process". 30) Select Action --> "Enable Process". 31) Select Action --> "Activate Process". 32) Log Out of Maximo. 33) Log In again as maxadmin. 34)Go To --> Self Service --> Desktop Requisitions --> Create Requisition 35)Click "Continue" to get to Step 2 of the Requisition. 36)Click "New Row" under Requisition Line Items. 37)Input an Item such as IKLEEN in the Item field. 38)Click the >> "Detail Menu" arrows next to the Item field and click "View Item Availability" to determine how many of the Item you have. 39)Click OK 40)In the Quantity field, input a value higher than the actual balance of the Item that you have. 41)Change the Reservation Type to "SOFT" 42)Click the "CONTINUE" button at the bottom of the screen. 43)Click the "SUBMIT" button at the bottom of the screen. 44)Go To --> Inventory --> Inventory Usage 45)Locate your Usage record that was generated by the Desktop Requisition. You can either: - Press ENTER with your cursor in the Usage field and manually navigate to the Usage record with the highest number. OR - Click "Advanced Search" and input IKLEEN in the Item field and then click find. 46) Once you are sure that you are on the correct Usage record, click on the "Route Workflow" icon right next to the Print icon. 47) Once the Workflow has completed, click on the >> "Detail Menu" icon and choose "View Item Availability" 48) There is now a value of -2.00 which the Inventory Options would have otherwise prevented without the Workflow. CURRENT ERRONEOUS RESULT: The Workflow process will result in a Negative Inventory Balance despite the Inventory Options being set to prevent it. EXPECTED RESULT: To verify the expected behavior manually, you can create another Desktop Requisition against another item for a quantity higher than is available, submit the Requisition and locate the Inventory Usage record which it generated. Try and manually change the status to "Staged" and click OK. You will receive the following errors: BMXAA7691E - The status of inventory usage (#) cannot be changed to STAGED. BMXAA7693E - The current requested quantity will cause a negative available balance for inventory usage line 1. Change the requested quantity before continuing with the transaction. ENVIRONMENT: This behavior has been reproduced in: - TPAE 7508 - TPAE 7509 - TPAE 7603
Local fix
N/A
Problem summary
**************************************************************** * USERS AFFECTED: * * Users who automate the status change of an Inventory Usage * * document via Workflow, when Negative Available Balance and * * Negative Current Balance are Disallowed. * **************************************************************** * PROBLEM DESCRIPTION: * * Even if Negative Available Balance and Negative Current * * Balance are Disallowed in Organization options, an Inventory * * Usage document which issues more than the available or * * current balance of an item can still be changed to status * * Staged or Completed via Workflow. This causes the balance of * * the item in Inventory to drop below zero. * **************************************************************** * RECOMMENDATION: * * Apply Fix Pack Release 7.5.0.11 or later. * ****************************************************************
Problem conclusion
Now, if Negative Available Balance and Negative Current Balance are Disallowed in Organization options, an error is thrown when a Workflow attempts to change the status of an Inventory Usage document to Staged or Completed, if issuing the item(s) would cause the available balance or current balance to drop below zero. The fix for this APAR is contained in the following maintenance package: Fixpack Release TPAE 7.5.0.11.
Temporary fix
Comments
APAR Information
APAR number
IV83297
Reported component name
INVENTORY
Reported component ID
5724R46IN
Reported release
750
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2016-04-01
Closed date
2016-05-04
Last modified date
2016-05-04
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
INVENTORY
Fixed component ID
5724R46IN
Applicable component levels
R750 PSY
UP
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCHPMA","label":"Inventory"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"750","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
04 May 2016