This installation method supports Oracle 11.5.10 to 11.5.10.2 on a 9i database or higher.

The process involves copying the java class files to the correct location on the server and modifying an Oracle configuration file so that the java class files are accessible. The process in managed using the Oracle AutoConfig utility and follows the standards prescribed by Oracle. For additional information refer to metalink document 270519.1 - Customizing an AutoConfig Environment.

NB – Please refer to this metalink note for details regarding future upgrades of this customisation.

1.    Locate the GL Wand server install zip file that is included in the download or download it separately from here.

2.    Unzip the file into a folder on your PC.

3.    The unzip will create multiple folders, the files required for this installation are can be found in the “Java Servlet R11” folder.

4.    Create the target folder for the GL Wand java class files in the JAVA_TOP. The path is as follows JAVA_TOP/com/excel4apps/servlet.

5.    Copy the class files from the source folder to JAVA_TOP/com/excel4apps/servlet.

6.    Identify the Oracle template file that needs to be modified. The file is located in FND_TOP/admin/template and is called zone_ias1022.properties.

7.    Create a new folder in FND_TOP/admin/template called custom.

8.    Copy zone_ias1022.properties from FND_TOP/admin/template into FND_TOP/admin/template/custom.

9.    Edit the zone_ias1022.properties file in the FND_TOP/admin/template/custom folder adding the following lines at the end of the file (You can copy these lines from Template.txt in the source folder).

#------- Excel4apps ---------------------

servlet.glwandproc350.code=com.excel4apps.servlet.glwandproc350

servlet.glwandtest.code=com.excel4apps.servlet.glwandtest

servlet.glwandusers.code=com.excel4apps.servlet.glwandusers

#--------------------------------------------

10. Run AutoConfig on the applications tier.

11. Continue with the Connection URL step here.