This appendix covers the following topics:
General issues are as follows:
Version 7.2 will be 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 a Oracle Web Applications Desktop Integrator form 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. Reference information regarding the Guest user account can be found in the Oracle E-Business Suite System Administrator's Guide.
No. Reference fields are not currently supported; however, there are plans to support this Oracle E-Business Suite flexfields feature. See enhancement 2809958 for the current status of this feature.
Yes, you can increase the number of rows to enter more records. See Adding Rows to a Spreadsheet.
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.
Spreadsheets can be copied between operating systems running different languages under the following conditions:
A spreadsheet generated on any language on Windows 98, NT, 2000, ME, XP, or Vista can be copied and used on a Windows NT, 2000, XP, or Vista machine running a different language. For example, you can copy spreadsheets from French Windows 98 to German Windows NT; however, you cannot copy spreadsheets from French Windows 98 to German Windows 98.
A spreadsheet that is copied onto a Windows 98 or ME machine must be generated on an operating system running the same language.
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.
Technical issues are as follows:
Microsoft Excel 2000, 2002, 2003, and 2007 are currently supported. These versions contain the VBA code that is capable of receiving OLE commands from the browser.
All browsers supported by Oracle E-Business Suite are supported.
Although not currently supported, work is currently underway to support Apple Macintosh.
ICA is a three-tiered framework with desktop, middle, 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 executed 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 middle tier. The Apache listener is required on the middle tier.
The desktop tier makes a direct connection to the HTTP server on the middle tier. It uses standard Web protocols such as HTTP, HTTPS, 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 middle tier.
The middle 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 middle 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.