The two zip files contain scripts that will create More4apps packages in your Oracle database and set up the More4apps profile options. These packages and profile options are necessary in order for the Wizard to communicate with Oracle E-Business. Application Interface Wizard will only contain product packages if these are required for your installation relating to Specific Loaders.
The More4apps packages start with ‘M4APS_’ followed by the name of the Wizard. The packages are wrapped (i.e. encrypted). The More4apps Profile Options start with ‘More4apps:’ followed by a short description of the profile option.
The R12install.sql (or install.sql) script within the Shared Installation Zip File will need to be run once per E-Business instance. The package it creates (M4APS_XML) is shared across all More4apps products on that instance and is used for the core XML communication and security framework.
NOTE: For More4apps Loader specific install please perform Step1 and Step2 as mentioned below and then go to Loader Specific Installation page.
The productcode_install.sql script within the Product Installation Zip File is specific to a More4apps Wizard and will need to be run once per E-Business instance.
These scripts are not destructive and can be re-run if necessary.
Server-side Install Steps
1. Copy the zip files to your E-Business application server then Extract the two zip files into sub-directories.
You will need to be able to access the *.sql, *.pks, *.pkb, *.plbs and *.plbb files from SQL*Plus.
2. Connect to SQL*Plus as the APPS user and run R12_install.sql (or install.sql for Release 11i).
Example:
Start SQL*Plus
Enter the password for apps
Run install.sql
Press ‘Enter’
Type ‘N’ If you are an Oracle Managed Cloud Services site you should be following instructions in section below "Server-side Install for Oracle Managed Cloud Services”.
Press ‘Enter’
You have successfully installed the M4APS_XML package.
3. Connect to SQL*Plus as the APPS user
Example:
Start SQL*Plus
Enter the password for apps
Run productcode_install.sql (e.g. IW_install.sql)
Press ‘Enter’
Type ‘N’ If you are an Oracle Managed Cloud Services site you should be following instructions in section below "Server-side Install for Oracle Managed Cloud Services”.
Don’t worry about the “MESG not declared” message, they can be ignored.
Press ‘Enter’
You have successfully installed the Product-specific package.
You now need to do the Servlet Install (unless you are on 11i). Once this is complete proceed with the ‘Configure the Workbook’ steps.