IV97788: "BMXAA0314E- COMPNAY CONTACT IS NOT VALID" WHEN VENDOR IS ON MULTIPLE ORGS

APAR status

• Closed as program error.

Error description

• Two Organizations   Org A is USD currency and Org B is CAD
  currency.  One Vendor added to the two Orgs with the matching
  currency of the Org. When create Desktop Req and add Vendor -
  when trying to approve/submit received error:
  "BMXAA0314E- compnay contact is not valid"
  
  Compnay does not use Exchange Rates
  
  1)Two Orgs >  Org A  currency = USD - site A ,  Org B currency
  = CAD - site B
  2)Company Master > created new Vendor = TESTER1 > currency = CAD
  3)Save
  4)Select Action> Add Company Master to Organization
  5)From Add Company Master to Organization pop up > select Org B
  (CAD currency) first
  6)click ok
  7)Select Action > Add Company Master to Organization
  8) From Add Company Master to Organization pop up > select Org
  A (USD currency) and be sure to change Vendor currency to USD.
  9)click ok
  **Companies table - check   Vendor =TESTER1 for Org B currency
  CAD will be the first record found in the table for this
  vendor.
  Select  company, type, orgid, currencycode from companies where
  company= 'TESTER1'
  Company     Type    OrgID     Currencycode
  1.TESTER1   V   ORG  B     CAD
  2.TESTER1   V   ORG  A     USD
  10)Profile Default SiteA  = USD site
  11)Item Master> create  item  TEST12
  12)Vendor tab> click new row > Add Vendor = TESTER1 (USD)
  currency
  13)save activate Item at inventory and org level
  14) Profile Default SiteB = CAD site
  15)Item Master >select Item TEST12
  16)Vendor tab> click new row > Add Vendor = TESTER1(CAD)
  currency
  17)Profile Default SiteA= USD site
  18)Desktop Requisitions > create requisition > click continue
  button
  19)Requistiion Line Items > click new row > enter item = TEST12
  created in step #11
  20) qty 1 > line cost = 10.00 > Vendor = TESTER1 (from step #2)
  receive error: "BMXAA0314E- Company Contact is not Valid" (
  this is a false message the error in the logs will indicate
  missing exchange rate)
  The problem only existis if Item / INVVENDOR record is updated
  for the particular vendor.  When the Desktop Requisition is
  created for the USD site , and the vendor field is populated
  the vendor record is validated against the companies object and
  finds the first company record in the companies object in this
  case it is the CAD vendor and it then issues the error message
  "BMXAA0314E- compnay contact is not valid"   this is not
  correct :The query that checks/validates the vendor from the
  companies object should include the Organization in the query.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * MAXIMO                                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * "BMXAA0314E- COMPANY CONTACT IS NOT VALID" WHEN VENDOR IS ON *
  * MULTIPLE ORGS                                                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• Needed to include the org in the query when getting the company
  using the vendor
  
  The fix for this APAR is contained in the following maintenance
  package:
  	 | release\fix pack | Interim Fix for Release 7.6.0.9 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

  SELF SERVICE

• Fixed component ID

  5724R46SS

Applicable component levels

• R760 PSY

     UP