Wizard – Database Administrator Checklist

Infrastructure Package

Check that the infrastructure package M4APS_XML has been installed and is VALID under the APPS user  (or BOLINF user for Oracle On-Demand customers).

select owner, object_name, object_type, status
from all_objects
where object_name like ‘M4APS%’

If the M4APS_XML package is invalid or not installed, you need to go back to the Server-side Install Step in the Installation Instructions and make sure that the install.sql (or R12install.sql) has been run.  See below if you need assistance from the support team.

Product Package(s)

Check that the product package has been installed and is VALID under the APPS user (or BOLINF user for Oracle On-Demand customers).

select owner, object_name, object_type, status
from all_objects
where object_name like ‘M4APS%’

You will need to have at least one product package installed for each wizard. The product package name will be very similar to the wizard name that you are installing.  Our product packages are prefixed with M4APS_.

Examples:
M4APS_PROJECTWIZARD for Project WIzard
M4APS_PRICELISTWIZARD  for Price List Wizard
M4APS_PAYINVWIZARD for AP Invoice Wizard

If the product package is invalid or not installed, you need to go back to the Server-side Install Step in the Installation Instructions and make sure that the productcode_install.sql (e.g. pw_install.sql for Project Wizard) has been run.  See below if you need assistance from the support team.

Release 12 Servlet

If you are on Release 12 you must install our Servlet. This is often missed, particularly if you have just upgraded from Release 11i. Patches that affect Autoconfig templates can also remove the customizations in the custom templates.

To check that the R12 Servlet is installed, first of all on the mid-tier server navigate to $JAVA_TOP and type the following command:

cd $JAVA_TOP

For 12.0 and 12.1:
java -cp m4aServlet.jar:$CLASSPATH com/more4apps/r12/servlet/XmlServlet
For 12.2:
java -cp customall.jar:$CLASSPATH com/more4apps/r12/servlet/XmlServlet

This should show the version number of the servlet.

Secondly, ensure the Autoconfig custom template changes have been made.  If you have previously installed the More4Apps servlet and successfully used More4Apps products in the past and now can no longer connect to your instance as expected, please ensure the Autoconfig custom templates still contain the changes required for More4Apps products to operate. To check this, navigate to $FND_TOP/admin/template/custom and check the contents of the files:

For 12.0 and 12.1:
orion_web_xml_1013.tmp
orion_application_xml_1013.tmp

For 12.2:
oacore_web_xml_FMW.tmp
ebs3rdpartyManifest_xml.tmp

You should see entries in these files as per our installation instructions.

If you suspect that the Servlet has not been installed go back to the Servlet Install Step in the Installation Instructions.  If you are missing the m4aServlet.jar  file (12.0 and 12.1) or the customall.jar file does not contain the More4Apps classes (12.2) you must download the files from our website and follow the Installation Instructions.

Remember to do the Autoconfig steps and bounce Apache! If you have multiple mid tier servers in a load-balanced configuration, you need to do this for all of your servers.
Where to get help

If you need help with any installation questions, whether you are trialing a product or an existing client… Please log a case via our online Helpdesk or our Request Product Support page.