IV93784: MAXIMO CRIATED DUPLICATED INVOICES FOR CONSIGNMENT ITEM ISSUES

APAR status

• Closed as program error.

Error description

• ----------------------------------------------------------------
  PROBLEM DESCRIPTION:
  ----------------------------------------------------------------
  Product or Service: Maximo Asset Management 7.6.0.0
  in consignment process. Consignment invoices are auto created
  upon issue.
  Maximo created duplicate invoices for consignment item issues.
  ----------------------------------------------------------------
  ACTION TAKEN:
  ----------------------------------------------------------------
  (L 2) Performed tests in Maximo 7.6.0.0 - Maximo Asset
  Management 7.6.0.0 - and could replicate the client problem
  reported in this PMR
  Steps to reproduce error:
  Create a FIFO Inventory / Consignment item.
  1- Go to Item Master
  2- Create a new item CONS2
  Order Unit=EACH. Issue Unit=EACH.
  3- Add item to Storeroom.
  4- Fill the Fields:
  Site = BEDFORD
  Storeroom = CENTRAL
  Consignment = y
  Issue cost type = FIFO
  Consignment Vendor = VOLVO
  Invoice generation Type = CONSUMPTION
  5- Click OK.
  6- Change item Status to Active (In Change Status Window markt
  he
  Option Roll new Status to organizations and Inventory?)
  Click Ok.
  7- Go to PO. Create the 1st PO.
  PO Vendor=VOLVO
  POLine 1, Item=CONS2. Storeroom=CENTRAL. Quantity=1. UnitC
  ost=10.
  Approve the PO.
  Create the PO.
  PO Vendor=VOLVO
  POLine 1, Item=CONS2. Storeroom=CENTRAL. Quantity=1. UnitC
  ost=15.
  Approve the PO.
  8- Go to Receiving. Received both PO in Step 7.
  9- Go to Inventory Application. Find CONS2 item and check thed
  ata.
  At point, your screen would be In Inventory LIFO / FIFO Costss
  ession,
  The first one Unit Cost=10, Quantity=1
  The second one Unit Cost=15, Quantity=1
  In Inventory balances session
  Would be one line with the value 2,00 in Current balance field.
  **** Steps to do it in Work Order Tracking Application:
  Proper Invoices will be created.
  10- Go to Work Order Tracking Application. Create a newW
  orkorder.
  Asset = 11430
  Change workorder status to APPR.
  Go to Actuals Tab / Materials Sub Tab.
  Insert a New row.
  TRansaction Type = ISSUE
  Line type = Item
  Item = CONS2
  Storeroom = CENTRAL
  Site = BEDFORD
  Quantity = 2
  Save the record.
  12 - Go to Invoices Application.
  13 - Click in Advanced Search / More Search fields.
  14 - IN the field TYPE, select the value CONSIGNMENT.
  15 - In ITEM Field Select the value CONS2
  16 - Click in the button Find.
  Result - 4 invoices will be created, and you can see duplicated
  records. Wrong behavior.
  Expected Result - A list of Invoice records without duplicated
  lines.
  ----------------------------------------------------------------
  Environment:
  ----------------------------------------------------------------
  IBM Maximo Asset Management 7.6.0.0 Build 20141117-2230 DB Build
      V7600-00
  ----------------------------------------------------------------
  Client system information:
  ----------------------------------------------------------------
  App Server - IBM WebSphere Application Server 8.5.5.3
  Version - IBM Maximo for Oil and Gas 7.5.1.0 Build
  20130227-1708 DB Build V7510-67
  Tivoli's process automation engine 7.6.0.0 Build 20141117-2230
  DB Build V7600-218
  IBM TPAE Integration Framework 7.6.0.0 Build 20141117-1800 DB
  Build V7600-15
  IBM Maximo Asset Management 7.6.0.0 Build 20141117-2230 DB Build
  V7600-00
  Server OS - Windows 6.3
  Server DB - Oracle 11.2 (Oracle Databae 11g Enterprise Edition
  Release 11.2.0.4.0 - 64bit Production With the Partitioning,
  OLAP, Data Mining and Real Application Testing options)
  

Local fix

• Because FIFO/LIFO Issue Cost type and CONSUMPTION are Release
  7.5 new
  functionality, users need to use Inventory Usage Applicatoin to
  Issue FIFO Items to get proper
  Invoices created.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * MAXIMO                                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * MAXIMO CREATED DUPLICATED INVOICES FOR CONSIGNMENT ITEM      *
  * ISSUE                                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• The fix for this APAR is contained in the following maintenance
  package:
  		 | Release 7.6.0.8 of Base Services
  

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

  INVENTORY

• Fixed component ID

  5724R46IN

Applicable component levels

• R760 PSY

     UP