REP-0180: Report has been cancelled from the Report Server.

When calling reports from Forms in Oracle 10g Application server (Forms and Report server), we got

REP-0180: Report has been cancelled from the Report Server.

The issue was with the Report server configuration file. The Report server has been authenticated through the Portal. We have not configured portal.

Just commented the security block in the configuration file (report server Path: (FORMS_SERVER_PATH\report\conf\rep-hostname.conf)

Original block was:

security id="rwSec" class="oracle.reports.server.RWSecurity"

!--property name="securityUserid" value="%PORTAL_DB_USERNAME%/%PORTAL_DB_PASSWORD%@%PORTAL_DB_TNSNAME%" confidential="yes" encrypted="no"/-->

property name="oidEntity" value="reportsApp_chainsysindia_85C49001C04D11DE8F660BF187F8822B"/>

/security>

destination destype="oraclePortal" class="oracle.reports.server.DesOraclePortal">

!--property name="portalUserid" value="%PORTAL_DB_USERNAME%/%PORTAL_DB_PASSWORD%@%PORTAL_DB_TNSNAME%" confidential="yes" encrypted="no"/-->

/destination>

Changed Block:

!--security id="rwSec" class="oracle.reports.server.RWSecurity">

/security-->

!--destination destype="oraclePortal" class="oracle.reports.server.DesOraclePortal">

/destination-->

Bounce the report server.

It should work!!! Cheers!!!

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.

oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_NO_REGION_DATA. Tokens: REGIONCODE = /oracle/apps/fnd/framework/navigate/we

Today, I need to blog out the experience with the issue