EAM About Asset Group

 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)