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 Guide and make sure that the install.sql (or R12install.sql) has been run.

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 product 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 go back to the Server-side Install step in the Installation Guide and make sure that the productcode_install.sql (e.g. pw_install.sql for Project Wizard) has been run.

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

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 Guide.
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 Guide.

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.

Connect with an expert

connect with your excel experts