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.

To check that the R12 Servlet is installed…  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.

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!

 

Where to get help… “Free Installation Support”

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.