Asset Groups – Oracle eAM
-----------------------------------
*)What is Asset Group?
Asset groups represent groups of assets that are virtually identical. Generally,
an asset group is defined for each Manufacturer and Model Number combination (Make, Model, and Year).
*)What is the Maximum length of the Asset Group Code and Description?
Asset Group Code: Generally the length of the Asset Group is the length of the Item Segment defined
in the -Inventory System Items KFF. (Per segment Maximum 40).
Asset Group Description: 240 Characters
*)Some Important Pre-required setups and Profile Options for Asset Groups:-
Asset Group Template and their attribute Controls with default values
INV: Default Primary Unit of Measure
INV: Updateable item name à Yes / No
Default Category Sets (Category Sets)
Enable Service Fulfillment Manager (SFM) Event Manager Queue Service
Defining and Freezing the Oracle Install Base Parameters
*)What is the Name of the Template used by EAM Asset Groups?
@Asset Group
*)Asset Group – Naming Conventions and its Components?
Function ---- Washing Machine
Make ---- LG
Model ---- S11-P02
Model Year ---- 2014
eAM Asset Group Template and their default values:
---------------------------------------------------
User Item Type ----- Asset Group
Item Status ----- Active
Primary Unit of Measure ----- Each
Inventory Item ------ Enabled
Transactable ------- Disabled
Serial Number Generation ----- Predefined / At Receipt
Effectively Control ----- Model / Unit Number
EAM Item Type ------- Asset Group
BOM Allowed ------- Yes
Track in Installed Base -------- Yes
*)What is the relationship between Asset Group and Inventory Item?
Basically every Asset Group is an Inventory Item. Its item type is Asset Group.
*)In how many ways an Asset Group can be created?
Asset Groups Form in Oracle eAM
Inventory Master Items (Apply Asset Group Template)
Importing Inventory Items
*)What is the name of the Table / View Name of the Asset Groups?
View Name – MTL_SYSTEM_ITEMS_VL
*)In which COLUMN_NAME the Asset Group / Item Code is stored?
SEGMENT1 or
CONCATENATED_SEGMENTS of MTL_SYSTEM_ITEMS_B_KFV
What is the actual name of the Database Table in which the Asset Group Details are stored?
MTL_SYSTEM_ITEMS_B_KFV
What is the Name of the Interface Table that is used for Mass upload of Asset Groups?
New Asset Groups ---- MTL_SYSTEM_ITEMS_INTERFACE
Revision Details ---- MTL_ITEM_REVISIONS_INTERFACE
Item Categories ---- MTL_ITEM_CATEGORIES_INTERFACE
*)In case of Centralized Maintenance architecture, where all the Assets of INV Organizations are maintained by EAM Organization,
how the Asset Groups are created and organizational assignment is done?
Asset Groups created should be first assigned to INV organization followed by EAM Organization.
Also the INV organization should be given EAM Responsibility (for Organizational Access).
*)Can we change the Asset Group Starting Prefix, once the Assets are created in the eAM Asset Numbers Form?
One cannot change the Asset Group Starting Prefix (subject to Uniqueness) and Starting serial Number from the EAM Asset Group Form Functionality.
Whereas the same can be changed from the Inventory Master Items.
*)Can we change the Asset Group Starting Number, once the Assets are created in the eAM Asset Numbers Form?
Yes, one change the Starting Prefix (subject to Uniqueness) and Starting Serial Number even after creation of Asset Numbers from EAM.
But one can change the same from Inventory Master Items form but not from EAM Asset Groups Form.
*)Can we change the Asset Group Code and Description?
One can change the Asset Group Description, but not the Asset Group Code. The profile options that needs to be setup is INV: Updateable item name.
*)What are the functions available from Asset Group Form?
View Item Details (Tools a Item Details)
View Failure Analysis and Maintain Failure Codes and sets (Tools a Maintain Failure Set)
Various Functions available for an Asset Group from Master Items Form:-
Categories (Tools a Categories)
Items Costs
Cross References
Item Subinventories
Item Relationships
Revisions
Catalog
Export the Asset Groups to Excel (File à Export)
*)Can we change the Asset Group associated with an Asset Number?
No we cannot Change the Asset Group Associated with an Asset Number.
However one can change the Asset Group Description subject to profile setting up (INV: Updateable item name)
*)What are the automation features available in eAM that can be automated / associated or attached at the Asset Group Level?
Activity Association Template
Meter Templates
Failure Codes and Sets
Asset Attribute Groups
Collection Plans
PM Schedule Template
Bills of Materials
Budget Forecasting
Activity Suppression Templates
*)What are the Serial Generation Options available for an eAM Asset Group?
At Receipt
Pre-defined
No Control
*)How to Export all the Asset Groups to Excel?
Change the Organization
Open the Master Item Window
Open the Search Window
Search for Asset Item Type a Asset Groups
Search Results are Displayed
File a Export (to export the search results to Excel Sheet).
*)SQL Query used to extract the Asset Groups from Database?
SELECT inventory_item_id, accounting_rule_id, invoicing_rule_id,
segment1 asset_group, segment2, segment3, segment4, segment5
FROM mtl_system_items
WHERE eam_item_type = 1
What are the Setups that need to be completed for automatic generation of EAM Asset Number in while creating Asset Number?
At the Asset Group Level setup the following:-
Serial Generation -- Predefined OR At Receipt
Starting Prefix
Starting Serial Number
In the EAM Parameters set the following:-
CHECK Ã Asset Serial Number Auto Generation
*)What are the uses of (a) Starting Prefix Number and (b) Starting Number in the Asset Group Definition Form?
When EAM Asset Numbers are generated automatically,the system will use tie Starting Prefix and Starting Number
to automatically generate the Asset Number when defining in the EAM Asset Numbers Form.
*)In order to Move an Asset, what the Main Attribute that should be CHECKED or made ACTIVE for the Asset Group?
Transactable as Yes (CHECKED)
*)For all the Asset Groups, which will be considered as Fixed Assets, for which Purchase Requisitions
and POs will be created, How the Costing Parameters are setup?
Costing should be disabled when they are receiving into Asset Sub Inventory.
If costing is enabled, then they should be received into an Expense Sub inventory.
*)What are pre-requisite to create an Asset Group with No Serial Controls?
Asset Groups cannot be created with No Serial Control option.
*)How to create and use an Asset Group without a Serial Control? What is the Best Scenario?
Ans: No. An Asset Groups Cannot be created with Serial Generation – No Control.
Whereas Rebuildables can be created with Serial Generation – No Control Option.
*)When trying to create An Asset Group with No Serial Control, then the following errors are encountered:-
If an item is under “Model/Unit Number Effectively” control then Serial Number Generation Must be “At Receipt” or “Predefined”.
Asset Group must be Serial Controlled Item with “Predefined” or “At Receipt”.
*)What is the profile option with which the Asset Group Attribute can be updated?
INV: Updateable item name
*)Is it necessary to compulsorily use the System Generated Auto Numbers for EAM Asset Numbers?
No, It is not necessary to use the system generated / suggested EAM Asset Number.
The same cane be changed manually to any desired number or a number suggested
by the users (subject to Uniqueness of EAM Asset Number and EAM Asset Serial Number).
*)What is the API for Creation of Items?
Item Creation and Updation
EGO_ITEM_PUB.PROCESS_ITEM(S)
This API provide functionality to create and update an item(s).
*)What is the API for Item Category Code Creation?
Category Code Creation Public API
INV_ITEM_CATEGORY_PUB.CREATE_CATEGORY
This API provide functionality to create a category
*)What is the API for Item Category Assignment?
Item Category Assignment Public API
EGO_ITEM_PUB.PROCESS_ITEM_CAT_ASSIGNMENT
This API provide functionality for the user to assign/remove a catalog to/from
an item and will verify whether user has edit item privilege on item.
*)What is the API for Item Catalog Descriptive Element?
Item Catalog Descriptive Element Public API
EGO_ITEM_PUB.PROCESS_ITEM_DESCR_ELEMENTS
This API provide functionality for the user to give the values of item catalog category descriptive
elements and will verify whether user has edit item privilege on item.
*)What is the API for Item Revision Creation and Updation?
Item Revision Creation and Updation Public API.
EGO_ITEM_PUB.PROCESS_ITEM_REVISION
This API provide functionality to create and update Item Revision
What is the API for Implement Item Pending Changes?
Implement Item Pending Changes Public API.
EGO_ITEM_PUB.IMPLEMENT_ITEM_PENDING_CHANGES
This API provide functionality to implement pending changes (phase and/or status) for an item/item revision.
What is the API for Item Lifecycle?
Item Lifecycle Public API
EGO_ITEM_PUB.PROCESS_ITEM_PHASE_AND_STATUS
This API provide functionality for changing the status of an item or promote/demote the lifecycle of an item/item revision
What is the API for The Item Grant?
Item Grant public API
EGO_ITEM_PUB.PROCESS_ITEM_ROLE
This API provide functionality to create/updation/deletion one role grant on one item
What is the API for Item User-Defined Attributes Data?
Item User-Defined Attributes Data Public API
EGO_ITEM_PUB.Process_User_Attrs_For_Item
This API provide functionality to create/updation/deletion on
one or more rows of user-defined attributes data for an item.
What is the API for Item Assignment to an Organization?
Item Assignment to an Organization Public API
EGO_ITEM_PUB.ASSIGN_ITEM_TO_ORG
This API provide functionality to assign one item to an organization
EGO_ITEM_PUB.PROCESS_ITEM_ORG_ASSIGNMENTS
This API provide functionality to assign one/more items to an organization(s)
What are Logical Asset Groups?
Sometimes for the purpose of maintaining proper Asset Hierarchy,
we need to map the assets with the locations, areas or departments which are not physical assets,
for which a Non Maintainable, Non Transactable Assets with costing disabled can be created.
To achieve this purpose, it is better to create a separate Item Template with required attributes and default values.
Asset Groups – Some Important Oracle Support Documents
Asset Group Must Be Unit Effective When Defining Asset Groups (Doc ID 297959.1)
Error = ‘Insert procedure failed with the following error message 22’ When Creating Asset Group in EAMITMDF (Doc ID 1352238.1)
Asset Groups Created On The Master Item Screen Shows ‘X’ As The Asset Group In EAM Self Service Pages (Doc ID 859832.1)
EAMITMDF – Error ‘Expense Account Is Required’ Is Received When Creating EAM Asset Group (Doc ID 1113173.1)
Asset Group Can Be Seen In The Material Select List For Work Order (Doc ID 1218093.1)
Primary Unit Of Measure Is Invalid Error When Defining Asset Group (Doc ID 813563.1)
How To Transfer A Whole Asset Group Between Org’S With Rebuildables & Components (Doc ID 601389.1)
When trying to create an Asset Group Using the Item Master Form Get Message
‘Tracking Install Base Flag must be set for Asset Group or Rebuildable Serial controlled item’ (Doc ID 560461.1)
Assign One Asset Group to Multiple Failure Sets (Doc ID 1567721.1)
How To Change Asset Group For Existing Asset Numbers (Doc ID 1573422.1)
Asset Group Must Be Unit Effective When Defining Asset Groups (Doc ID 297959.1)
Is an Asset Number Possible to be Moved to Another Asset Group (Doc ID
1542361.1)
How To Update Asset Group In Asset Number Form After It Is Saved And Used (Doc ID 1588183.1)
How to Assign an Asset Category To an Asset Group (Doc ID 884811.1)
EAMFANDF:Asset Group Not Defaulting From Asset Number In Asset Route Form (Doc ID 1350169.1)
When trying to create an Asset Group Using the Item Master Form Get Message ‘Tracking Install Base Flag must be set for Asset Group or Rebuildable Serial controlled item’ (Doc ID 560461.1)
Can I Mass Assign Asset Groups? (Doc ID 1942653.1)
