Introduction to Web ADI:

What is Web-ADI?

It is a spreadsheet extension available in Release 12 of Oracle Applications, which can be used for Assets module. It can be used to perform the following tasks:

1. Creating Assets

How are the above tasks accomplished?

In responsibility “Assets, Vision Operations (USA)” in Release 12 GPI, the navigations for the above tasks are:

Mass Additions à Additions Integrator (for Creating Assets)

select responsibility as “Assets, Vision Operations (USA)” & navigate as Mass Additions à Additions Integrator.

In this page you need to select Corporate Asset Book as “OPS CORP” & click on “Continue”.

Now you need to select Viewer as “Excel 2003” [Depending on the version of Excel you are using] & click on “Next”.

Note: Here if you check “Reporting”, then the document you create will not allow you to upload data.

Now select Layout as “Add Assets Default” [Using this standard layout for now, in chapter 3 we will create our own layout] & click on “Next”.

You will get a file download window, here you need to click on “Save

You need to specify where you want to save this layout & click on “Save”.

You will see a message window that says “Your document has been created”, you need to click on “Close”.

This is the excel spreadsheet which contains the relevant Asset information columns. Here, first you need to double-click on the cell adjacent to “Queue Name”.

The following window will pop-up, from the list of values you need to check “New” & then click on “Select”.

Now you need to specify Asset Description by double-clicking the below cell & then select from the list of values as shown below.

Now you need to specify Major Category & Minor Category as shown below:

Now you need to enter the Units & Costs manually.

Similarly you need to specify Country, State/County, City, Building details.

Next you need to specify Expense Account.

You need to specify Clearing Account.

You need to enter the Date Placed in Service manually.

Note: The remaining columns in this spreadsheet are optional.

You need to go to the Oracle Menu & click on “Upload”, the following window will pop-up; here you need to select as shown below, & click on “Upload”.

Now you need to validate the above steps, which is to check if the asset data is loaded into the interface table.

For this you need to go to responsibility “Assets, Vision Operations (USA)”, and then navigate as Mass Additions à Prepare Mass Additions.

In this window you need to enter the below data [sample data that we had previously uploaded using the spreadsheet] & click on “Find”.

Now you can see the data that we had entered on the spreadsheet has been loaded into the Interface table.

Now you need to try the same process but this time move the data into Oracle Assets, which is post the data. (So you need to repeat steps up to 18 & modify step 19 as shown below by checking the box for “Create Assets Now (Post Mass Additions)”.