APAR status
Closed as program error.
Error description
The actual material cost attribute on the Work Order table is being calculated incorrectly when and inventory item is issued to a work order where the number of items issued spans across cost layers with the same price. STEPS TO REPLICATE: 1- Go to the Asset application. Create a new asset. Set the type to PRODUCTION. Set the location to a REPAIR location. Set the rotating item to a valid value. Set any other required values. Change the status to OPERATING and save the asset. 2- Go to Item Master and create a new item. Activate and save the item. 3- Add the item just created to a storeroom. The item will have a cost type of FIFO. Enter a default bin. Enter a unit cost of 1.00 and a current balance of 5. Click OK. 4- Go to inventory and bring up the item just added to the storeroom. In the More Actions section, select Inventory Adjustments,Current Balance. On the first window, Current Balance Adjustment dialog, enter a new balance of 10. On the second window, Specify Inventory Costs, enter the price of 1.00 on the 5 items we just adjusted for. Now our FIFO item has 2 cost layers. 5 items at 1.00 and another layer of 5 items at 1.00. 5- Go to Work Order Tracking and create a new work order. Enter the asset we created in the first step. Please note the Charge to Store flag is checked properly. Save and approve the work order. 6- Go to the actuals tab on the work order. On the Materials subtab, issue 1 of the inventory items we created previously. Save the work order. A transaction was created for the inventory layer it issued from properly. 7- Complete and close the work order. 8- In the More Actions section, select View Work Order Costs. The Material Cost on this is incorrect. We issued 1 items to the work order. With FIFO costing, those items were valued at 1.00. This is displaying 2.00. 9- Go to the asset record. This also displays an Inventory cost value of 2.00. This is also incorrect. It should be 1.00. 10- Now in the common actions on the asset, select Move Modify Assets. The value being moved back into the storeroom will be 2.00 which is incorrect. We have only issued 6.00 worth of material to the asset. Therefore, our Global Rotating Suspense account will be out of balance by 1.00. CURRENT ERRONEOUS RESULT: -With FIFO costing, those items were valued at 1.00. This is displaying 2.00. -Go to the asset record. This also displays an Inventory cost value of 2.00. EXPECTED RESULT: This values are incorrect. It should be 1.00. ENVIRONMENT: App Server IBM WebSphere Application Server 8.5.5.10 Version Tivolis process automation engine 7.6.0.5-IFIX20161207-1834 Build 20160611-0100 DB Build V7605-45 HFDB Build HF7605-04IBM TPAE Integration Framework 7.6.0.5 Build 20160610-2330 DB Build V7605-50IBM Maximo Enterprise Adapter for Oracle Applications 7.6.0.0-20160713-1111 Build 20150804-1717 DB Build V7600-05IBM Maximo Asset Management Work Centers 7.6.0.0 Build 20160610-1318 DB Build V7600-38IBM Maximo Asset Management 7.6.0.5 Build 20160611-0100 DB Build V7604-01 Server OS Windows Server 2012 R2 6.3 Server DB Microsoft SQL Server 12.0 12.00.5540 PRODUCT VERSION: Version Tivolis process automation engine 7.6.0.5-IFIX20161207-1834
Local fix
N/A
Problem summary
**************************************************************** * USERS AFFECTED: * * MAXIMO * **************************************************************** * PROBLEM DESCRIPTION: * * ACTUAL MATERIAL COST ATTRIBUTE ON WORK ORDER TABLE IS BEING * * CALCULATED INCORRECTLY FOR FIFO ITEM * **************************************************************** * RECOMMENDATION: * ****************************************************************
Problem conclusion
The fix for this APAR is contained in the following maintenance package: | Release 7.6.0.9 of Base Services
Temporary fix
Comments
APAR Information
APAR number
IV96188
Reported component name
WORK ORDERS
Reported component ID
5724R46WO
Reported release
760
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2017-05-12
Closed date
2017-06-14
Last modified date
2017-06-29
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
WORK ORDERS
Fixed component ID
5724R46WO
Applicable component levels
R760 PSY
UP
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCHPPU","label":"Work Order Tracking"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"760","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
29 June 2017