IV69601: CANNOT APPROVE INVOICE WITH ERROR BMXAA0868E

APAR status

• Closed as program error.

Error description

• The problem : cannot approve invoice with error BMXAA0868E - The
  exchange rate was not found
  
  Env : 7502
  
  Replication steps.
  1. Go To Financial > Exchange Rates
  Select the EAGLENA Organization
  Filter Exchange Rates from currency USD to Currency IDR
  Delete any rows for these Exchange Rates
  
  Add new row for an exchange rate from currency USD to currency
  MNT.
  
  
  2. Go To Administration > Sets
  Click New Row to add a new COMPANY Set COMPSET2 (Company set 2)
  Save the Set
  
  3. Go To Administration > Organizations
  Add New Organization
  Organization = LALORG
  Description = TEST ORG
  Base Currency 1 = IDR
  Item Set = SET1
  Company Set = COMPSET2
  Save the Organization
  
  Go To Financial > Chart of Accounts
  Select LALORG
  Click Select Action > GL Component Maintenance
  Select COST CENTER
  Click New Row
  GL Component Value = 0000 and 0001
  
  
  Select ACTIVITY
  Click New Row
  GL Component Value = 000 and 100 and 200
  Select RESOURCE
  Click New Row
  GL Component Value = 000 and 100 and 200
  Click OK
  
  Click New Row in the GL Accounts table
  GL Account = 0000-000-000 and 0001-000-000 and 0001-100-100 and
  0001-200-200.
  Save the Chart of Accounts
  
  4. Go To Administration > Organizations
  Search for and display LALORG
  Set Clearing Account to 0000-000-000
  Check the Active box
  Save the Organization
  Click the Sites tab
  Click New Row in the Sites table
  Site = 301SITE
  Description = 301SITE
  Save the Organization
  
  5. Click Profile > Default Information
  Change Default Insert Site to 301SITE
  Click OK
  
  Go To Purchasing > Company Master
  Add New Company Master
  Company = MEK004
  Description = MEK004
  Currency = IDR
  Save the Company Master
  Click Select Action > Add Company Master to Organization
  Add to LALORG
  
  Go to Purchasing > Companies App
  Open MEK004
  Set AP Control Account : 0001-000-000
  Set RBNI Account : 0001-100-100
  Set Suspense Account : 0001-200-200
  
  Save
  
  6. Click Profile > Default Information
  Change Default Insert Site to BEDFORD
  Click OK
  
  Go To Purchasing > Company Master
  Add New Company Master
  Company = MEK004
  Description = MEK004
  Currency = MNT
  Save the Company Master
  Click Select Action > Add Company Master to Organization
  Add to EAGLENA
  
  Go to Purchasing > Companies App
  Open MEK004
  Set AP Control Account : 6800-910-600
  Set RBNI Account : 6800-930-600
  Set Suspense Account : 6800-920-600
  
  Save
  
  7. Go to Inventory > Item Master
  - Create a ITEM ( eg. TZITEM01)
  - select action / Add item to storerrom
    add this item to CENTRAL storeroom
  - Change status to ACTIVE with orginfo/inventory.
  
  
  8. Go To Purchasing > Purchase Orders
  Add New Purchase Order
  Make note of the PO Number for future use (e.g. 1373 )
  Set Company to MEK004
  Click PO Lines tab
  Click New Row
  Leave Line Type = Item
  Item : TZITEM01
  Add all other required information
  Save the Purchase Order
  Approve the Purchase Order
  
  9. Go To Purchasing > Receiving
  Search for and display Purchase Order that was created in
  previous
  steps ( e.g. 1373)
  On the Material Receipts tab click Select Ordered Items
  Select PO Line 1
  Click OK
  Save the Receipt
  
  10.Go To Purchasing > Invoices
  Add a new Invoice ( 1189)
  PO = Purchase Order created in previous steps ( e.g. 1373 )
  Click the Invoice Lines tab
  Click Copy PO Lines
  Select the PO Line 1
  Click OK
  Open the line details and change the Unit Cost to some new value
  Save the Invoice
  Approve the Invoice
  Got error "BMXAA2013E - Could not change invoice 1189 status to
  APPR.
  BMXAA0868E - The exchange rate was not found."
  
  
  cf. in systemout.log,
   (COMPANIES) : select * from companies where company= 'MEK004'
  09 Feb 2015 10:47:31:563 [INFO] [MXServer] [CID-UIASYNC-7579]
  BMXAA6719I - USER = (MAXADMIN) SPID = (132) app (null) object
  (EXCHANGE) : select * from exchange where currencycode = 'IDR'
  and
  currencycodeto = 'USD' and { ts '2015-02-09 10:47:31.250' } >=
  activedate and { ts '2015-02-09 10:47:31.250' } < expiredate
  and orgid=
  'EAGLENA'
  09 Feb 2015 10:47:31:563 [INFO] [MXServer] [CID-UIASYNC-7579]
  BMXAA6719I - USER = (MAXADMIN) SPID = (141) app (null) object
  (EXCHANGE) : select * from exchange where currencycode = 'USD'
  and
  currencycodeto = 'IDR' and { ts '2015-02-09 10:47:31.250' } >=
  activedate and { ts '2015-02-09 10:47:31.250' } < expiredate
  and orgid=
  'EAGLENA'
  09 Feb 2015 10:47:31:563 [INFO] [MXServer] [CID-UIASYNC-7579]
  BMXAA6719I - USER = (MAXADMIN) SPID = (158) app (null) object
  (EXCHANGE) : select * from exchange where currencycode = 'IDR'
  and
  currencycodeto = 'USD' and { ts '2015-02-09 10:47:31.250' } >=
  activedate and { ts '2015-02-09 10:47:31.250' } < expiredate
  and orgid=
  'EAGLENA'
  09 Feb 2015 10:47:31:563 [INFO] [MXServer] [CID-UIASYNC-7579]
  BMXAA6719I - USER = (MAXADMIN) SPID = (147) app (null) object
  (EXCHANGE) : select * from exchange where currencycode = 'USD'
  and
  currencycodeto = 'IDR' and { ts '2015-02-09 10:47:31.250' } >=
  activedate and { ts '2015-02-09 10:47:31.250' } < expiredate
  and orgid=
  'EAGLENA'
  
  
  found that query for companies is not using orgid.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Maximo users using Invoice Application                   *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * CANNOT APPROVE INVOICE WITH ERROR BMXAA0868E                 *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply Release 7.5.0.8 of Base Services or request an Interim *
  * Fix                                                          *
  ****************************************************************
  

Problem conclusion

• Orgid was mising in the whereclause to get the correct company
  from the companies table.
  

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

  FINANCIAL

• Fixed component ID

  5724R46FI

Applicable component levels