Issue with Upgrade 11.5.10.2

Today I need to blog out my experience with the issue I faced while upgrading an instance from 11.5.9 to 11.5.10.2

While login to the applications we got the message as
oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_NO_REGION_DATA. Tokens: REGIONCODE = /oracle/apps/fnd/framework/navigate/webui/HomePG; (Could not lookup message because there is no database connection)
at oracle.apps.fnd.framework.webui. JRAD2AKMapper.getRootMElement(JRAD2AKMapper.java:527)
at oracle.apps.fnd.framework.webui.OAWebBeanFactoryImpl.getWebBeanTypeDataFromJRAD(OAWebBeanFactoryImpl.java:3783)
at oracle.apps.fnd.framework.webui.OAWebBeanFactoryImpl.getRootApplicationModuleClass(OAWebBeanFactoryImpl.java:3460)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:988)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:497)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:418)
at _oa__html._OA._jspService(_OA.java:107)
## Detail 0 ##oracle.adf.mds.exception.MDSRuntimeException: Unable to load metamodel definition because the mmd file file:/oracle/erppcomn/html/jrad/JRADElementList.xml is invalid. '=' missing in attribute.

The Fix
1. Locate the $OA_HTML/marlin_html.zip file
When we test unzip the file using unzip -t file namegrep 'CRC' (We got CRC error in JRADElementList.xml)
We downloaded the patch part again and
2. Unzip this file.
3. Clear the _pages cache directory.
4. Shutdown and restart Apache.
5. Re-test to see that the error no longer occurs.


Hope this will help you.