Wednesday, August 06, 2014

cauprefs.ora 11g

Two Changes to do in 64 bit environmet in:
C:\Oracle\MW\FRinst\config\FRComponent\frcommon\tools\admin\cauprefs.ora

1. Change the values of the attributes to:
  • Reports.root_x = 0
  • Reports.root_y = 0

2. Change the attribute:
  • Reports.PluggableDataSourceFactories = ()

Open reports job - excel, delimeted ...

web.show_document(v_server_url || '/reports/rwservlet/getjobid' || v_jobid || '?server=' || :GLOBAL.rp2rroReportServer || '&mimetype=application/vnd.ms-excel', '_blank');