How to track EAM Assets in Oracle Installed Base

Track EAM asset in Installed Base

In order to track EAM assets in Oracle Installed base:

1. Enable the Inventory item(EAM Asset) to be Installed Base trackable by checking the flag under service tab in Item Master UI.
2. Enable the Transactable flag in the Inventory tab of Item Master UI.

The above two are key setups required to track an EAM asset in IB.
Verify this by following use case:

1.       With above two setups in place for the Inventory Item Create Asset in EAM module

2.       As the asset is created in EAM a new record for the item will be created in IB as a new item instance.

3.       Now Update the Asset in eAM  and a new transaction record will be inserted in IB

R12 Using Install Base Web ADI - Run-time error'1004' Method 'VBProject' of object '_Workbook' failed

R12 Using Install Base Web ADI  

In order to know about “How To Use Install Base WebADI Mass Update Feature In Release 12.1.3” please check the metalink DOC ID 1536498.1.

Here we will explain how to resolve the error Run-time error'1004' Method 'VBProject' of object '_Workbook' failed.

After you download the WEB ADI for IB most of the users receives the below error

 In Excel 2003:
go to "Tools" > "Macro" > "Security" and select the "Trusted Sources" tab.  Check the box next to "Trust access to Visual Basic Project".
(Note: The box for "Trust all installed add-ins and templates" should also be checked.)

For Excel 2007

Step1: Go to excel and click on office button. Click on Excel Options

Step2: Go To Trust Center Tab. Click on Trust Centre Settings

 

Step3: Go To Macro Settings Tab. Enable Check Box Trust Access to the VBA project object model

Step4: Click on OK

Step4: Restart the machine and open the WebADI

For Excel 2010: You will find the option under the File menu