Bring the power of Excel to Oracle EBS with Web ADI
- You don’t have to login to EBS or navigate/download the Excel every time. You download the Excel once; you can access it by just opening it from desktop. If EBS SSO (Single Sign On) is enabled it automatically understands who you are, if not, a pop from Excel, requests you to login.
- You have got all the features of Excel at your disposal – You can drag a cell, copy-paste data, use formulas to derive data, filter for certain values, have your own macros.
- You have the option to selectively upload only certain rows from the Excel.
- If the solution involves launching a concurrent program in the background, you can monitor the status from the excel itself, without having to login to EBS.
- Business validations can be built into the Excel to show any issues to the user in the Excel itself. The user can chose to correct it or not upload the error record and proceed with others.
- Can work with the Excel offline. Of course, the user needs to be connected to validate or upload the data
- The Excel can be configured for List of Values (LoV), double clicking on the Excel cell will open a HTML page that will give the capability search for valid values and select it.
- The excel sheet can also be configured to have drop down values.
- When a user wants a report in an Excel periodically, we can have the Web ADI configured for reporting only. The user just needs to open the Excel from desktop and refresh
- Where data needs to created/updated in bulk, where the data may already be there in Excel, etc.
- Where we need the capability to work with the data offline and sync it up with server when online.
- Where we may have to review a set of data and correct it – Web ADI can download the data that qualifies the condition into Excel. The user can make the changes and upload back.
- Existing concurrent programs based solutions where a flat file is shared with the IT support team and the support team uploads it and shares the error records back, on which corrections are made and shared again to the support team for upload.
- Reports that you want to refresh frequently.
Excel being Excel, most users will be comfortable with it and will not need any special training to use it. Web ADI being a technology module within EBS does not need any additional license. If you already have EBS, you can apply the required patches and start using it. If you look at it the other way, it is a module that the customer has already paid for, and not using it! Identifying the opportunities to implement the Web ADI based Excel solution can be a very good idea, that everyone on Oracle EBS should consider exploring for a better Return on Investment.