Install Database Packages

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 m4aps_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 communication and security framework.
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.

For More4apps Loader installation please perform the steps below and then go to the Loader Installation page.

For 12.2 instances these scripts can be run in the run edition, there is no need to start an adop cycle.

1. Copy Files to Server

Copy the zip files to your E-Business application server then extract the zip files into sub-directories.

2. BOLINF Grants and Synonyms (OMCS Installation only)

If you are an OMCS (Oracle Managed Cloud Service) installation then run the OOD_prepare.sql script in SQLPlus as the APPS user, otherwise skip this step and go to Step 3 below. This script generates grants for the BOLINF schema and synonyms for the APPS Schema. You will be prompted for the BOLINF password.

sqlplus apps

SQL*Plus: Release 10.1.0.5.0 - Production on Sat Apr 13 08:32:19 2024

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Enter password: ******

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> @OOD_prepare
================================================================

More4Apps - ood_prepare.sql

This script generates the APPS and BOLINF privileges and synonyms required by
the More4Apps spreadsheet wizards in an Oracle Managed Cloud Service (OMCS, OOD) site. It is re-runnable.


Press Ctrl-C to quit, or Return to continue:

Is this an OMCS site? (Y/N) [Y]:

BOLINF password: ******
Generating the required GRANT and SYNONYM statements for the APPS schema

Please wait...

Connected.

Synonyms and grants created.

Press ENTER to continue...

3. M4APS_XML package

Connect to SQLPlus as the APPS user and run m4aps_install.sql.

If you are an OMCS installation then connect to BOLINF instead of APPS and answer "Y" to the OMCS prompt. The example shows APPS.

run> sqlplus APPS

SQL*Plus: Release 10.1.0.5.0 - Production on Fri Apr 12 15:11:58 2024

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Enter password: ******

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> @m4aps_install
================================================================

More4apps - m4aps_install.sql

This script installs or upgrades the connectivity framework
for the More4apps Wizards for Oracle E-Business. It is re-runnable
and is non-destructive.

Press Ctrl-C to quit, or Return to continue:

Is this an Oracle On Demand site? (Y/N) [N]:

M4APS_XML_R12

Creating synonym to XSU.....

Synonym created.

Creating packages.....

No errors.
No errors.

Done.

Please use the following URL in the More4apps Wizards to connect to this instance:

  http://zappa.more4apps.com:8000/OA_HTML

Installation complete. Press ENTER to continue...

Make a note of the connection URL.

4. Product Packages

Connect to SQLPlus as the APPS user and run productcode_install.sql for each of the Wizards you are installing e.g. iw_install.sql for Item Wizard.

Some Products have an Extension package that allows you to put your own custom PL/SQL code into the Wizard processing. If you have already made use of this feature and you do not want the installation script to overwrite your custom package then answer N to "Update Extension Package".

If you are an Oracle Managed Cloud Services (OMCS) customer then connect to BOLINF instead of APPS, and answer "Y" to the OMCS prompt. The example shows APPS.

sqlplus APPS

SQL*Plus: Release 10.1.0.5.0 - Production on Sat Apr 13 07:31:52 2024

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Enter password: ******

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> @iw_install
================================================================

More4Apps - iw_install.sql

This script installs or upgrades the M4APS_ITEMWIZARD package
for the More4Apps Item Wizard product. It is re-runnable
however you must backup your copy of M4APS_ITEMWIZARDCUSTOM
package body if you have modified it.

Press Ctrl-C to quit or Return to continue:

Is this an Oracle On Demand site? (Y/N) [N]:

Creating Item Wizard packages.....

No errors.
No errors.
M4APS_ITEMWIZARD package created

Update Extension Package? (Y/N) [N]:

M4APS_ITEMWIZARDCUSTOM Package created

Creating incompatibility between item and catalog interface concurrent programs
Press ENTER to continue...

Repeat this for each Product.

You now need to do the Servlet Install (unless you are on 11i). Once this is complete proceed with the ‘Configure the Workbook’ steps.