IJ24829: BMXAA4211E - DATABASE ERROR NUMBER -803 HAS OCCURRED WHEN OPERATING ON INVVENDOR RECEIVING ROTATING ITEM

APAR status

• Closed as program error.

Error description

• Problem
  
  You receive BMXAA4211E - Database error number -803 has occurred
   when operating on INVVENDOR : Item=NEWITEM Vendor=GMC
  Manufacturer= Model= Condition Code=NEW Catalog #= Item Set=SET1
   Organization=EAGLENA Site=BEDFORD. Report the error to the
  owner of the deployment. error when trying to receive 2 PO lines
   for same condition enabled rotating item going 2 different
  storerooms.
  
  Steps to Reproduce
  
  Go the Item Master application
  Create a new rotating item XXXXX
  Check the Condition Enabled field
  Click New Row in the Condition Codes section
  add 2 conditions New and Used
  Save the changes
  DO NOT add it to a storeroom
  Change status to Active and check Roll New Status to
  Organizations and Inventory? field
  
  Go to Purchase Order application
  Create a new record
  Populate the Vendor field = BEX
  Click on PO Lines
  Click new row add item XXXXX
  Storeroom= Central
  Order Unit = each
  Unit Cost = 500.00
  Click New Row add item XXXXX
  Storeroom= Garage
  Order Unit= Each
  Unit Cost= 500.00
  Save the record and change status to approve
  Take note of the ponum
  
  Go the Receiving application
  Bring up purchase order
  Click on Select Order Items
  Select both PO Lines
  Save the Record
  More Actions> Receive Rotating Items and Click Autonumber >
  Click OK
  
  
  Results
  You receive BMXAA4211E - Database error number -803 has occurred
   when operating on INVVENDOR : Item=NEWITEM Vendor=GMC
  Manufacturer= Model= Condition Code=NEW Catalog #= Item Set=SET1
   Organization=EAGLENA Site=BEDFORD. Report the error to the
  owner of the deployment.
  
  Expected Results
  You should be able to receive both rotating assets into
  different storerooms
  
  
  Reported Version
  7.6.0.8
  

Local fix

• no work around
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users if Purchasing condition enabled items                  *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * BMXAA4211E - Database error number -803 has occurred         *
  * when operating on INVVENDOR                                  *
  ****************************************************************
  The fix ensures you can not save / approve a PO that has
  condition enabled items in PO Lines, and no condition is
  specified. This was the root cause of the problem, which
  resulted on Unique Index violation in receiving.
  

Problem conclusion

• The fix for this APAR is contained in the following maintenance
  package: release\fix pack for Release 7.6.1.3 Product
  

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:

Fix information

• Fixed component name

  MAXIMO ASST MGM

• Fixed component ID

  5724R46AM

Applicable component levels