We developed this tool in response to demand from Oracle Asset users for a user friendly and robust spreadsheet tool to add and manipulate assets within the Oracle Assets module.
The Wizard is a VBA program embedded in a Microsoft Excel workbook. It is a close cousin to our other ‘Wizard’ products and shares the same look and feel. Asset Wizard uses a public API to interface to Oracle Assets.
Features
All options are available on a ribbon.
Simply type, import, or paste the values directly into the spreadsheet. You can also double-click in the spreadsheet to load the form for data-entry. The data-entry form is optional.
You can upload one transaction at a time, select a range of transactions or upload all transactions on the worksheet.
The program is flexible about the spreadsheet layout. You can move, delete, or hide unwanted columns. You can also use multiple sheets or a separate workbook.
A download function is available to extract existing assets to create new assets. You can also download existing asset information to create new transactions such as Classifications or Retirements (within the Wizard) and load it into Oracle.
The spreadsheet contains a status column, enabling you to accurately track and correct your records as they interface into Oracle Assets.
This product is supported on most versions of E-Business suite from 11.5.10.2 onwards. Please reference our compatibility section for further details: https://more4apps.com/support/what-we-support.
This Wizard allows for the creation of Asset Categories. This function inserts directly into the tables FA_category_books and FA_Category_book_defaults. It also uses a private API (FA_CATEGORIES_PKG.INSERT_ROW) which inserts into fa_categories_b and fa_categories_tl.
