Uninstall/Reinstall/Upgrades

Uninstallation from Server

The More4apps products consist of a central database package in the APPS schema used by all products, and a product-specific package for each product. For R12 there is also a mid-tier servlet.

Uninstall a Single Product

To uninstall a Product (e.g. Budget Wizard) but leave the framework installed, do the following in the APPS (or BOLINF) schema:

  • Drop the M4APS package(s) created by the product_install.sql script (e.g. BW_install.sql).

Uninstall All Products and Framework

To completely uninstall the More4apps Products including the XML framework and servlet do the following in the APPS (or BOLINF) schema:

  • Drop all packages beginning with M4APS% and the synonym M4APS_XMLQUERY

  • For 11i run the following in SQLplus as APPS:

delete from fnd_enabled_plsql where plsql_name='M4APS_XML';

  • For R12.1 remove the More4apps customization from the file $FND_TOP/admin/template/custom/orion_web_xml_1013.tmp and run Autoconfig. You can remove the servlet by deleting the m4aServlet.jar file from $JAVA_TOP.

  • For R12.2 remove the More4apps customizations from the files oacore_web_xml_FMW.tmp and ebs3rdpartyManifest_xml.tmp in the $FND_TOP/admin/template/custom/ directory and run Autoconfig. You can remove the servlet by removing the $JAVA_TOP/com/more4apps directory and then regenerate the customall.jar file by running adcgnjar.

Remove Profile Options

There is no supported mechanism in Oracle E-Business Suite for complete removal of Profile Options. To disable the Profile Options created by the More4apps products, query them up in the "Profile Options" screen of the "Application Developer" responsibility (they all start with "More4apps%") and disable them at all levels. When not used by More4apps products the Profile Options are benign and will not affect the standard functionality of your Oracle E-Business Suite.

Reinstallation and Upgrades

The installation scripts can all be re-run. If you mistakenly removed a package (e.g. the framework package M4APS_XML) or you want to upgrade to a newer version then run the m4aps_install.sql or productcode_install.sql in the APPS (or BOLINF) schema.

To upgrade the R12 servlet, refer to these links: 12.2 Servlet Upgrade or 12.1 Servlet Upgrade. There is no need to redo the Autoconfig steps.

Support

If you have any questions regarding the installation/de-installation steps you can inquire in the More4apps Community