EAM Conversion - Install Base Trackable Cannot Be Updated Since Onhand Trackable Exists

(Doc ID 1308965.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Enterprise Asset Management - Version 12.1.2 and later
Information in this document applies to any platform.
***Checked for relevance on 03-Sep-2012***
***Checked for currency on 01-Aug-2014***


When attempting to update the Track Install Base attribute on an exisiting item, from an earlier conversion,  the following error message is received:

Install Base Trackable cannot be updated since Onhand trackable exists.

Inventory Maintain Items > Items > Master Items > Service  Tab.

The attempt is being made to update this flag via a conversion program (XOPS_GLB_ITEM_ATTR_UPD_PB.pkb ).   Procedure "import_items" performs the insertion of records into interface table. The EAM items were converted in 2008 into a 12.0.1 instance and user is currently trying to update the flags in a 12.1.2 instance.
When a new item is created, this is not an issue.

Created new item from scratch. The test used following sequence:
-Created Item with EAM_ITEM_TYPE = Rebuildable
-Checked Track Install Base flag and saved (no error)
-Unchecked Track Install Base Flag and saved (no error)
-Added onhand quantity to item
-Attempted to check Track Install Base flag -> Error message
-Removed onhand quantity from item
-Checked Track Install Base flag and saved (no error)
-Unchecked Track Install Base Flag and saved (no error)

To reproduce the issue, follow the below steps
1) Create eAM Item and set EAM Item Type = Rebuildable
2) Add Onhand Quantity
3) Set "Track Install Base" = "YES"


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms