Michael Ferrante,
my customer is asking if we can continue to use the “workingDirectory” Parameter in formsweb.cfg in 12.2.1.19/14.1.2.
I am using the setting of “workingDirectory” in all of my projects since 2011. It is easy to define with this parameter a specific directory for Forms and Reports. (I read this setting during Runtime and use this path for a Reportscall too).
All I have to do is to comment “FORMS_MODULE_PATH” in default.env out and add the parameter “workingDirectory” in formsweb.cfg and the *saa.txt FSAL setting.
I have seen an Support entry that says:
WORKINGDIRECTORY IN FORMS 12C NOT RECOGNIZED this feature has been removed.
and another one that describes the functionality as we use it
Applies to:
Oracle Forms - Version 10.1.2.0.2 to 12.2.1.4.0 [Release Oracle10g to 12.2]
Information in this document applies to any platform.
Solution
When you run your application and specify the workingDirectory in the formsweb.cfg, this directory will be used first to find all Forms modules (*.fmx, *.mmx, *.plx). If the modules are not found, the directories listed in the FORMS_PATH are then searched. If you have not specified the working directory, its value will default to <ORACLE_HOME>/forms.
The Forms Search path order is
1. Formsweb.cfg : WorkingDirectory
2. envFile (default.env by default) : FORMS_PATH
3. envFile (default.env by default) : ORACLE_PATH (this environment variable is not typically used).
Oracle recommends using the FORMS_PATH only. Setting multiple environment variables to find Forms modules can lead to confusion.
Can you clearify if it will work in 12.2.1.19/14.1.2 before we continue to use it. The other solution would be to create a default.env for each different configuration in formsweb.cfg.
example formsweb.cfg today (this defines the runtime directory where we place our Forms and Reports)
[config1_prod]
# Containing Forms and Reports for Prod
WorkingDirectory=C:\oracle\app\prod
[config1_test]
# Containing Forms and Reports for Test
WorkingDirectory=C:\oracle\app\test
Example for Forms
==============
Call_form('xyz.fmx')
Example today for a Reports call:
========================
Application Start:
webutil_global.p_set_modul_verzeichnis(webutil_browser.getappletparameter('workingDirectory'));
Reportscall (Windows/Unix)
set_report_object_property(p_rep_id, report_filename, webutil_global.f_get_modul_verzeichnis || webutil_fileseparator ||vch_report_name || vch_rep_type);
Frank