Oracle Asset Tracking

[hussainejaz]

I had heard that if we install Asset tracking.. it will tightly integrate with EAM/INV and Fixed Assets;

Like if we change any Inventory Organization of our Assets in inventory... it will automatically change the assets location in FA alongwith with new depreciation account...

Do anybody has idea that above statement is true; and we could have tight integration between eAM/INV/FA Cause of Asset Tracking..

Regards,
Hussain

[ooaam]

Solution
1) Define your item -
a) From: INVENTORY MASTER - Purchasing Tab
Assign an Asset Category - Asset Category: EQUIPMENT.TEST EQUIP
b) From: INVENTORY MASTER - Service Tab
Check 'Track in Install Base'
c) From: Organization Item Form/Sub-org
Query up your item
Navigate Tools -> Item Costs
Associate a Cost to the Item
2) Map the HZ Location to the FA Location
a) Navigate -> Oracle Install Base Admin -> Setups -> Asset Location Setup
b) Map the TCA location to the FA location
3) Setup a Transaction Type for EIB = EIB Issue to Asset (Whatever you would like to call it)
a) Navigate -> Depot repair Super User -> Inventory -> Setup -> Transactions
-> Navigate to USER Tab
b) Create a Transaction Type = EIB Issue to Asset, Source Type = Inventory,
Action = Issue from Stores
4) Set 'CSE: Miscellaneous Issue to HZ Location'. This profile needs to be
set to the transaction type that is created in inventory (so 'EIB Issue to Asset') for EIB to pick it up. If this profile is set to another transaction type or not set at all, the transaction will just expire the instance (as a Miscellaneous Issue) instead of updating as 'In Service'.
5) Perform Miscellaneous Issue to field Location
a) Navigate -> Transactions -> Miscellaneous Transaction
b) Type = EIB Issue to Asset
6) As soon as the Miscellaneous issue to field Location Transaction Occurs, the USAGE of the Item
Instance in Install Base changes to = IN SERVICE.
7) Reviewing the Transaction Status on the Transactions page of the Customer Product Instance
should show the transaction as COMPLETE
ENABLE the Following EIB Triggers:

CSE_FA_RETIREMENTS_ARI

CSE_MASS_ADDITIONS_ARU

This has to be enabled in order for the Item Instance Classification to change to ?ASSET? and
the Asset details to be displayed in the Assets Link on the install Base Instance.
a) The Triggers can be manually enabled from the back end using the following commands:
ALTER TRIGGER cse_fa_retirements_ari ENABLE;
ALTER TRIGGER cse_mass_additions_aru ENABLE;
b) User can also run script csetrg03.sql located under the directory $CSE_TOP/patch/115/sql.
sqlplus: @csetrg03.sql


9) Run Create Assets : Interface Inventory transactions to Fixed Asset
a) Navigate -> Oracle Enterprise Install Base -> Submit a new Concurrent Request
b) Run for All items

10) When this Program Completes Successfully, the Asset is created in the FA Interface tables.

11) Submit the FA Mass Additions Concurrent Program
a) Navigate -> Fixed Assets Manager -> Mass Additions -> Post Mass Additions
b) After the Program Completes Normally the Item becomes an Asset in FA.
c) Review the Asset - Navigate -> Fixed Asset Manager -> Assets -> Asset Workbench

12) To review completed transaction for the item in Install Base
a) From the Install Base User -> Query the Item Instance and navigate to the
Transactions Link the Screen