My Oracle Support Banner

Oracle Assets Troubleshooting Guide for Web ADI (Doc ID 884175.1)

Last updated on FEBRUARY 23, 2020

Applies to:

Oracle Assets - Version to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.


Troubleshooting Guide for WEB ADI


Troubleshooting Steps

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Troubleshooting Steps
 1. Getting the error message "You do not have permission to access this functionality" while trying to access Web ADI. Why?
 2. How to configure the applications to trace Web ADI for Fixed Assets?
 3. When attempting to select a Major Category from the LOV while creating assets using Web ADI, the following error occurs: ERROR 'Exception Name: java.lang.ArrayIndexOutOfBoundsException - 19'?
 4. Unable to locate the Oracle menu item to upload in Excel 2007?
 5. Uploading data via web adi with Descriptive Flexfield (DFF) errors with  'oracle.apps.bne.exception.BneSQLException: Cannot execute SQL Statement'
 6. WEB ADI Upload fails with: Error:Major Category: for the flexfield segment Major Category does not exist in the value set Asset Major Category
 7. When attempting to upload assets via WEB ADI erros with: 'CANNOT EXECUTE SQL STATEMENT - A LOW LEVEL API CALL FAILED. NO ROWS WERE UPLOADED'
 8. WEB ADI upload errors with 'Visual Basic Error: Compile error:Ambiguous name detected: CreatePopList_PopCache_FA_MASS_ADDITIONS_ASSET_TYPE'
 9. While trying to create assets from ADI, no corporate book is available in the LOV in ADI to select . There is a security profile attached to the responsibility ?
 10. When attempting to upload assets through ADI client, the following error occurs: "The YTD Depreciation Value must be less than or the same as the Depreciation Reserve."
 11. The WEB ADI template for fixed assets upload does not show the 'Upload' function in the 'Tools' menu in Excel when "Reporting" option was flagged? 
 12. Unable to open or save spreadsheet for Physical Inventory Integrator?
 13. While uploading assets via WEB ADI Several lines error with: You can only enter a life for life-based methods.
 14. Using the Web-ADI interface, user is unable to generate a spreadsheet to upload the assets. The spreadsheet indicates that the function is not available to the user?
 15. When creating assets via ADI there is no value defaulted for Asset Type, Depreciate, and In Physical Inventory and there is no value returned via the LOV?
 16. Trying to create worksheet through WEB ADI errors with oracle.apps.bne.exception.BneTokenException
 17. How to set the Validate Before Upload parameter always to Yes ?
 18. In WEB ADI, after selecting all information,at step to open the WEB ADI Excel file, the file is not downloaded
 19. Web Adi upload erros with 'Cannot Execute SQL statement'
 20. Uploading data with DFF values via web adi errors with "'The descriptive flexfield is not valid'
 21. While trying to set Profile Option ‘FADI: reate Assets Privileges’ errors with APP-FND-01436 System Profile Option ‘FADI: Create Assets Privileges’
 22. WebADI errors with 'An exception occurred trying to map a column'
 23. Web adi upload errors with oracle.apps.bne.exception.BneSQLException - Cannot execute SQL Statement.
 24. Web adi upload errors with 'Required upload column was not in upload and no default value was generated Column: Posting Status'
 25. Uploading assets via web adi errors with 'You must specify a rate for this Depreciation Method'
 26.  Why FA_MASSADD_DISTRIBUTIONS table is not updated when uploading the data via web adi?
 27. When Uploading huge number of assets, web adi errors with 'Cannot execute SQL Statement'
 28.Why upload asset is not happening by invoking the WebADI integrator?
 29. Why do the WEB ADI accessing steps change each time we log it, they should be sequencial?
 30. Web adi upload errors with 'Fatal Error: Please have your system administrator view the bne.log file'.
 31.WEBADI: Uploading assets errors with 'This Asset Number is already in use. Please enter another'.
 32. Uploading asset lines with life in months erros with 'You can only enter a life for life-based methods'.
 33. Web Adi upload errors with 'Exception Name: oracle.apps.bne.exception.BneInvalidException - Program '.
 34. Web Adi upload error with 'Error: -2146828279 SystemId'.
 35. Unable to upload assets through Web ADI. Getting error 'Cannot execute SQL statements'.
 36. Web ADI upload of asset additions failed with 'Cannot Execute SQL Statement' why ?
 37. While trying to submit items for Physical Inventory via ADI, the following error is received 'oracle.apps.bne.exception.BneInvalidException:'
 38. When trying to create document by Web ADI errors with 'Fatal error: Please have your system administrator view the bne.log file'.
 39. Web adi upload process errors with  'Enter a valid Queue Name' why ?

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.