x

To install the iWay Oracle wrapper:

1. Log into the Windows or UNIX environment where the Oracle E Business suite software is installed.
2. Locate the *.pks, *.pkb, and *.sql files in the following directory:

   iWaySMHome\etc\setup

   where:

   iWaySMHome

   Is the location where iWay 7.0 SM is installed.

3. Copy the *.pks, *.pkb, and *.sql files into the $IWAY_TOP/admin/sql directory.

   If this directory is not available, you can copy the files to any other custom directory in the Oracle E-Business Suite environment.

4. Change directory to $IWAY_TOP/admin/sql (or to the directory where you copied the wrapper code files), so that it is the current working directory.
5. Log into SQL*Plus as iWay database user.
6. Run the following scripts to create the IWAY_API_PARAMETERS table, IWAY_DECLARATIONS table, and the IWAY_OUTPUT_STRINGS temporary table:

   SQL> SPOOL IWAY_DECL_TABLE_INSTALL_LOG.txt
   SQL> @create_iway_tables.sql
   SQL> spool off

   Note: This script drops existing tables with the target name "iway_api_parameters", "iway_declarations", and "iway_output_strings", creates the tables, and grants access to apps. If this is a new install, the first part of the script will fail (drops the object) but the table creation and the grant should succeed. This is expected behavior.

7. For New Installations Only. This step is not required for upgrades because the output directory is already set. If you are performing an upgrade, continue to Step 8.

   Log into SQL*Plus as APPS user.

   Note: If APPS user does not exist in non-Oracle application environments, you must create a user called APPS with a DBA role and privileges to create, alter, delete, drop, grant, update tables, synonyms, and procedures.

   Verify the following:

   select num, name, value
   from v$parameter
   where name = 'utl_file_dir';

   If the result of the query is not '/usr/tmp', then change the following declaration line in the file IWAY_ORA_API_WRAPPER.pks to point to a valid directory as shown in the value column from the above query result, and save the file.

   gv_log_file_dir VARCHAR2 (100) := '/usr/tmp';

   The current value '/usr/tmp' can be left unchanged if the directory path is configured in the utl_file_directory database parameter. This is the location where the debug file will be created if debugging is enabled.

   If the utl_file_dir parameter is not configured on the database system, run the following command:

   alter system set utl_file_dir=value scope=spfile;

   where:

   value

   Is the full path you want to configure (for example, D:\oracle\visdb\).

   This command configures the utl_file_dir parameter, which is what you need to enter in the gv_log_file_dir parameter. This is where the wrapper log will be written.

8. Log into SQL*Plus as APPS user and run the following scripts and commands as follows to create PL/SQL wrapper packages.
   1. SQL> SPOOL IWAY_WRAPPER_INSTALL_LOG.txt
   2. SQL> start IWAY_WRAPPER_DECL.pks
   3. For New Installations Only. SQL> start IWAY_ORA_API_WRAPPER.pks
   4. For New Installations and Upgrades. SQL> start IWAY_ORA_API_DECL.pks
   5. Run one of the following:

      If you are installing in a database where the Oracle E-Business Suite (for example, Oracle Apps) is installed, run the following command:

      SQL> start IWAY_ORA_API_WRAPPER.pkb

      If you are installing in a database where the Oracle E-Business Suite (for example, Oracle Apps) is not installed, then run the following command:

      SQL> start IWAY_ORA_API_WRAPPER_NO_APPS.pkb

      Troubleshooting Notes: All of the scripts should complete successfully. If the scripts fail, ensure that the files are copied into the correct directory and they are available in your current working directory. If there are compilation issues, contact iWay Software Customer Support Services and provide the spool file, IWAY_WRAPPER_INSTALL_LOG.txt, that is generated during the installation for troubleshooting.

   6. GRANT EXECUTE ON iway_ora_api_wrapper TO IWAY WITH GRANT OPTION;
   7. GRANT EXECUTE ON iway_wrapper_decl TO IWAY WITH GRANT OPTION;
   8. CONNECT iway (This changes accounts from APPS to IWAY.)
   9. When prompted, enter the password for the iWay account.
   10. DROP SYNONYM iway_ora_api_wrapper;

       Note: This will fail if the synonym does not exist. This is the expected behavior.

   11. CREATE SYNONYM iway_ora_api_wrapper FOR APPS.iway_ora_api_wrapper;
   12. SQL> SPOOL off.
9. If this is not a fresh install, log into SQL*Plus as APPS and issue the following:

   SQL> set heading off
   SQL> set echo off
   SQL> set termout off
   SQL> spool drop_decl.sql
   SQL> SELECT 'DROP PACKAGE ' || OBJECT_NAME || ';' FROM DBA_OBJECTS WHERE OBJECT_NAME LIKE 'IWAY2%';
   SQL> spool off
   SQL> @drop_decl.sql

10. Log off from SQL*Plus to complete the installation process.