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!!!