IV83297: WORKFLOW ALLOWS GENERATION OF NEGATIVE INVENTORY BALANCE WHEN INVENTORY OPTIONS HAVE BEEN SET TO PREVENT NEGATIVE BALANCES.

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 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