This appendix covers the following topics:
General issues are as follows:
Version 7.2 was supported for Release 11 and 11i only; not for Release 12 and higher.
No. You need only a Web browser supported by Oracle E-Business Suite and Microsoft Excel.
New seeded integrators will be added as separate patches. These patches will be shipped with the products related to the integrators. You can also use Oracle E-Business Suite Desktop Integration Framework to define custom integrators. See: Oracle E-Business Suite Desktop Integration Framework Developer's Guide.
The GUEST user name defined in the .dbc file cannot be the same as your Oracle E-Business Suite user name. When you select an Oracle Web Applications Desktop Integrator function, a guest login to the database is performed based on the .dbc setting. The Oracle Web Applications Desktop Integrator application requires login to the database before it can attempt to take any action, such as validating your login name and password or getting the profile option to see that Single Sign-On (SSO) server support is enabled. For more information about the Guest user account, see: Guest User Account, Oracle E-Business Suite Security Guide.
No. Reference fields are not currently supported.
Yes, you can increase the number of rows to enter more records. See Adding Rows to a Spreadsheet.
Oracle Web Applications Desktop Integrator is designed for transactional worksheet uploads and is not meant to be used for mass data uploads. If you need to perform a mass batch upload, you should review the documentation for the relevant product to evaluate the open interface tables exposed by that product for such uploads. The Oracle Web Applications Desktop Integrator framework has been tested with up to 100,000 rows, though results may vary depending on the number of columns in the spreadsheet, which determines the total number of data cells to upload, as well as the processor speed and amount of memory (RAM) on the desktop. If your site uses OOXML, then the document is automatically uploaded as a ZIP compressed OOXML file. Otherwise, compressing the data using WinZip or 7Zip can help increase the number of records you can upload; see: Compressing Data for Upload. For data sets larger than approximately 100,000 rows, you should evaluate other upload and download alternatives.
You cannot copy an entire worksheet to a different workbook; however, you can copy row and column values from one worksheet to another Oracle Web Applications Desktop Integrator worksheet and then upload the data. Oracle Web Applications Desktop Integrator does not support copying the entire worksheet because Excel copies only the rows and columns. If you copy entire worksheets, the macro code behind the Oracle Web Applications Desktop Integrator worksheet is not copied over to the new sheet.
Yes. Spreadsheets can be copied between PCs on Windows Vista or higher running different languages.
The Web versions of Analysis Wizard, Budget Wizard, Journal Wizard, Report Wizard, and Account Hierarchy Manager are available within the Oracle General Ledger product. The Web versions of Physical Inventory and Asset Wizard functionality can be found within the Oracle Assets product. Submitting and publishing standard, variable, and FSG reports can be found in Oracle Report Manager.
No. Oracle Web Applications Desktop Integrator uses a secure document ID and instance URL while uploading a document. The document ID is stored in the database during document creation and is later used during upload. Additionally, the upload process uses the instance URL from the macro code that is downloaded during document creation. Consequently, it is not possible to upload a document to a separate instance.
Yes, if the cloned instance has the same URL as the original URL for the source instance, then you can upload a document to the cloned instance. To ensure that the cloned instance has the same URL as the source instance, you must perform host aliasing on the target instance after cloning.
Technical issues are as follows:
For the most current list of supported Microsoft Excel versions, see My Oracle Support Knowledge Document 1077728.1, Using Microsoft 365 and Microsoft Office with Oracle E-Business Suite Releases 12 and 11i.
See My Oracle Support Knowledge Document 389422.1, Recommended Browsers for Oracle E-Business Suite, for the list of supported browsers and My Oracle Support Knowledge Document 1077728.1, Using Microsoft 365 and Microsoft Office with Oracle E-Business Suite Releases 12 and 11i for specific browser requirements for Oracle Web Applications Desktop Integrator.
Although not currently supported, work is currently underway to support Apple Macintosh.
ICA is a three-tiered framework with desktop, application, and database tiers. For Oracle Web Applications Desktop Integrator, the desktop tier will make a direct connection to the HTTP server. The business logic is controlled through Java components, which are run by an appropriate module. The modules connect to the data server as necessary to complete their assigned instructions. Oracle Web Applications Desktop Integrator business logic and properties will be installed on the application tier. The Apache listener is required on the application tier.
The desktop tier makes a direct connection to the HTTP server on the application tier. It uses standard Web protocols such as HTTP, HTTPS, TLS, or SSL.
Oracle E-Business Suite software and tools are deployed and managed on this tier. This tier eliminates the need to install and maintain application software on each desktop client. The software also has the potential to scale with load by moving components to separate hosts. Network traffic is kept low by passing only data, instead of passing graphical information like some screen scraping technologies. Oracle Web Applications Desktop Integrator business logic is installed on the application tier.
The application and database tiers communicate via SQL*Net, Net8, or JDBC.
The database tier holds all data and data-intensive programs, and processes all SQL requests for data. Machines in this tier do not communicate directly with applications users, but rather with machines on the application tier that mediate these communications, or with other servers on the database tier.
If you use a multi-byte environment, you must save the text file with UTF-8 encoding before importing the text file.
Yes. Oracle Web Applications Desktop Integrator is SSO capable when used in an Oracle E-Business Suite environment. No extra configuration of Oracle Web Applications Desktop Integrator with SSO is required.