How to directly launch the forms in R12.
Check the profile option : ICX: Forms Launcher
Query to find out the value of that profile option :
set wrap off
set verify off
set pagesize 1000
set lines 1000
col profile format a30
col v_profile format a100
col scope format a11
col value_scope format a20
col level_value noprint
undefine profile
spool profiles
select p.user_profile_option_name profile
, '1 - Site' Scope
, 'Site' Value_scope
, v.level_value
, v.profile_option_value v_profile
from fnd_profile_option_values v
, fnd_profile_options_vl p
where v.profile_option_id = p.profile_option_id
and (v.level_id = 10001)
and p.user_profile_option_name like '%&&profile%'
Union
select p.user_profile_option_name
, '2 - Appli.'
, a.application_short_name
, v.level_value
, v.profile_option_value
from fnd_profile_option_values v
, fnd_profile_options_vl p
, fnd_application a
where v.profile_option_id = p.profile_option_id
and (v.level_id = 10002 and a.application_id = v.level_value)
and p.user_profile_option_name like '%&&profile%'
Union
select p.user_profile_option_name
, '3 - Respon.'
, r.responsibility_name
, v.level_value
, v.profile_option_value
from fnd_profile_option_values v
, fnd_profile_options_vl p
, fnd_responsibility_vl r
where v.profile_option_id = p.profile_option_id
and (v.level_id = 10003 and r.responsibility_id = v.level_value)
and p.user_profile_option_name like '%&&profile%'
Union
select p.user_profile_option_name
, '3 - User'
, u.user_name
, v.level_value
, v.profile_option_value
from fnd_profile_option_values v
, fnd_profile_options_vl p
, fnd_user u
where v.profile_option_id = p.profile_option_id
and (v.level_id = 10004 and u.user_id = v.level_value)
and p.user_profile_option_name='&a'
order by 1,2,3;
#########################################################
select user_profile_option_name,
decode(level_id,10001,'Site',
10002,'Appl',
10003,'Resp',
10004,'User',
10005,'Server',
10006,'Organization',
level_id) "Level",
profile_option_value, level_value lvl_val
from fnd_profile_option_values, fnd_profile_options_vl
where user_profile_option_name like ('%'||'&profile'||'%')
AND fnd_profile_option_values.profile_option_id =
fnd_profile_options_vl.profile_option_id;
####################################################
It will ask for 2 Inputs... %ICX%
Output :
for 11i
ICX: Forms Launcher 1 - Site Site https://erpwebapps.test.com:443/dev60cgi/f60cgi
for R12
ICX: Forms Launcher 1 - Site Site http://erpwebapps.test.com:443/OA_HTML/frmservlet
we can directly launch with this URL.. but authentication for secure mode should be off..before u can launch it.
##########################################
For Doing secure server off in 11.5.10
1. Backup and open $APPL_TOP/admin/_.xml context file
2. Update the context variable:
s_appserverid_authentication
By default in 11.5.10, this is set to SECURE.
In previous 11i versions, this was set to OFF.
For debug purposes, you can use ON or OFF.
Modes:
- ON : Partial
- SECURE : activates full server security (SECURE mode)
- OFF : deactivates server security
3. Run Autoconfig to instantiate the change.
You should now be able to access forms directly again using the f60cgi call.
4. After you have finished your Forms debugging, please reset s_appserverid_authentication to SECURE and re-run Autoconfig.
Alternative option
Running Autoconfig is the preferred method of updating s_appserverid_authentication.
If you are unable to run Autoconfig during troubleshooting, you can run the the following commands instead from $FND_TOP/secure
Disable:
java oracle.apps.fnd.security.AdminAppServer apps/apps AUTHENTICATION OFF DBC=host_visdemo1.dbc
Enable:
To activate basic server security, from the command line,enter:
jre oracle.apps.fnd.security.AdminAppServer apps/apps AUTHENTICATION ON DBC=
To activate full server security (SECURE mode), from the command line, enter:
jre oracle.apps.fnd.security.AdminAppServer apps/apps AUTHENTICATION SECURE DBC=
Check the status:
java oracle.apps.fnd.security.AdminAppServer apps/apps STATUS DBC=host_visdemo1.dbc
For doing secure mode off in R12
Application Server Security can be in one of three states:
1)OFF: Server security and Code ID’s are not checked which means any application server machine can access the database. This option is usually used on test instances or if you have full control over the software all machines to physically access your database.
2)ON: This is a case where some level of trust is required to access the database. In this setup either the application server must be registered with the database or the code must pass a module and version ID known to be trusted. Use this option only if you wish to maintain compatibility with application servers that you cannot yet patch to the code level required for best security.
3)SECURE: This setup is used when ever full trust is required for access to the database. Only registered application server machines and only trusted code modules may connect to the database. This is the default setting for Release 12.
Server Security Status
To check the Server Security status for a particular database use the STATUS command in the AdminAppServer utility and pass the dbc file corresponding to the database.The STATUS command will display whether server security is turned on and whether the server ID
in the dbc file is currently valid.
java oracle.apps.fnd.security.AdminAppServer apps/apps STATUS DBC=
Adding, Updating, or Deleting Server Ids
Application servers can be registered as trusted machines with a database server by generating a large random ID number and storing it in both the application server and the database. When the application server attempts to connect to the database it supplies its server ID. The database will then verify that it matches to that of a trusted machine. The server ID is stored as a parameter in the DBC file for each application server, which can also be defined as an environment variable. The AdminAppServer utility is used to generate server IDs and then register them with a database server.
1. Add server ID as:
Server ID’s are added to the database automatically when AdminAppServer
is ran to create a dbc file.
java oracle.apps.fnd.security.AdminAppServer apps/apps \
ADD [SECURE_PATH=$FND_TOP/secure] \
DB_HOST= \
DB_PORT= \
DB_NAME=
2. Update server ID.
Update an application server's server ID from the command line as:
java oracle.apps.fnd.security.AdminAppServer apps/apps UPDATE DBC= APPL_SERVER_ID
Note: By providing the APPL_SERVER_ID argument, you will force a new server ID to be
generated and added to your DBC file. If the APPL_SERVER_ID argument is not provided,
AdminAppServer will take care of syncing up the server ID's of your dbc file and your
database automatically, if required.
3. Delete server ID
AdminAppServer utility is used to delete server ID’s follows:
java oracle.apps.fnd.security.AdminAppServer apps/apps DELETE DBC= APPL_SERVER_ID
Activating and Deactivating Server Security
Server security feature can be turned to OFF, ON, or SECURE mode using the AdminAppServer utility. When the server security is turned off the server ID’s are not changed or deleted.Server security can be re-enabled without having to recreate server IDs for existing registered application servers.
On UNIX:
A. Enter the following command to activate basic server security:
java oracle.apps.fnd.security.AdminAppServer apps/apps AUTHENTICATION ON DBC=
B. Enter the following command to activate full server security (SECURE mode):
java oracle.apps.fnd.security.AdminAppServer apps/apps AUTHENTICATION SECURE DBC=
C. Enter the following command to deactivate server security:
java oracle.apps.fnd.security.AdminAppServer apps/apps AUTHENTICATION OFF DBC=
