Sunday, November 02, 2014

Oracle Forms 11g Configuration / log Files




formsweb.cfg

DOMAIN_HOME/config/fmwconfig/servers/WLS_FORMS/applications/formsapp_11.1.2/config

default.env

DOMAIN_HOME/config/fmwconfig/servers/WLS_FORMS/applications/formsapp_11.1.2/config

base(jpi).htm

DOMAIN_HOME/config/fmwconfig/servers/WLS_FORMS/applications/formsapp_11.1.2/config

registry.dat

DOMAIN_HOME/config/FormsComponent/forms/registry/oracle/forms/registry

frmweb.res

UNIX:
ORACLE_INSTANCE/config/FormsComponent/forms/admin/resource/
Windows:
ORACLE_INSTANCE/config/FormsComponent/forms

jvmcontroller.cfg
ORACLE_INSTANCE/config/FRComponent/frcommon/tools/jvm/

forms_ohs.conf
ORACLE_INSTANCE/config/OHS/ohs1/moduleconf


WLS_FORMS.log

DOMAIN_HOME/servers/WLS_FORMS/logs

WLS_FORMS.out

DOMAIN_HOME/servers/WLS_FORMS/logs

Forms trace files

ORACLE_INSTANCE/FormsComponent/forms/trace

Listener Servlet logs

DOMAIN_HOME/servers/WLS_FORMS/logs



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');