Server-side Install for Oracle Managed Cloud Services (OMCS Only)
These instructions are only relevant if you are an Oracle Managed Cloud Services (OMCS) customer.
Note - Application Interface Wizard will only contain a product installation zip file if packages are required for installation of Specific Loaders supplied by More4apps. The product installation zip file will not be supplied when downloaded from the More4apps website.
These 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 for the Wizard to communicate with E-Business.
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 R12_install.sql script within the Shared Installation Zip File will need to be run once per Oracle Applications instance/database. 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 Step2 and Step3 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 for Oracle Managed Cloud Services (OMCS)
1. Copy the zip files to the Application Server as the applmgr user and unzip the Product and Infrastructure zip files into sub-directories.
You will need to be able to access the files (*.sql, *.pks, *.pkb, *.plbs and *.plbb) from SQL*Plus.
2. Run the script to generate grants for the BOLINF schema and extra synonyms for the APPS Schema.
Connect to SQL*Plus as the APPS user and run OOD_prepare.sql (from the Shared Installation Zip File). You will be prompted for the BOLINF password.
> sqlplus apps/appspw
SQL> @ood_prepare.sql
…
BOLINF password:
3. Connect to SQL*Plus as the BOLINF user and run R12_install.sql (from the Shared Installation Zip File). This installs the core XML communications and security framework within the package M4A_XML. This is shared across all More4apps products.
4. Connect to SQL*Plus as the BOLINF user and run productcode_install.sql e.g. IW_install.sql (from the Product Installation Zip File). (Refer to section: Wizard Product Codes List)
Repeat this step for each product you are installing e.g. Project Wizard, Budget Wizard, AP Invoice Wizard.
You now need to do the Servlet Install, then proceed with the ‘Configure the Workbook’ steps.
