Database Administrator ChecklistBy Excella September 7, 2020
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.
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
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_.
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.
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:
For 12.0 and 12.1:
java -cp m4aServlet.jar:$CLASSPATH com/more4apps/r12/servlet/XmlServlet
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:
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.