How to un-link a FND_USER from from SSO in EBS R12

No comments
If we want to unlink any Oracle application user from SSO then we can use below script.


Run the EBS  script

$FND_TOP/patch/115/sql/fndssouu.sql USER_NAME

Apart from setting the FND_USER.USER_GUID value to NULL, this script also flushes the workflow entity cache for the user.

No comments :

Post a Comment

Understanding and Creating Custom Template file for Autoconfig in Oracle Apps R12

No comments


When Autoconfig is executed in EBS/Oracle Apps it creates various configuration files which are created from the template files.
Some time we might need to find the template file associated with these conf file to customize these templates and avoid autoconfig to use the default ones.

Below are the few important points to be remembered.


  • The AutoConfig template file cannot be customized if the "LOCK" keyword appears in the template file.
  • AutoConfig ignores custom template files that are marked with "LOCK”.
  • Customization of Template File must be done on both Patch & Run File system.

How to Determine the Auto Config template file which you want to customize.


Apps Tier: /bin/adtmplreport.sh contextfile=target=

DB Tier: /appsutil/bin/adtmplreport.sh contextfile= target=

Example:

$AD_TOP/bin/adtmplreport.sh contextfile=/u01/TEST/fs1/inst/apps/TEST_funoracleapps/appl/admin/TEST_funoracleapps.xml target=/u01/TEST/fs1/FMW_Home/webtier/instances/EBS_web_TEST_OHS1/config/OHS/EBS_web_TEST/security2.conf

It will generate a log file with required information on configuration file and template file like below


TEMPLATE FILE   : /u01/TEST/fs1/EBSapps/appl/fnd/12.0.0/admin/template/security2_conf_FMW.tmp
TARGET FILE     : /u01/TEST/fs1/FMW_Home/webtier/instances/EBS_web_TEST_OHS1/config/OHS/EBS_web_TEST/security2.conf


Create Custom Template file

  • Create folder custom in location where template file resides.
  • Copy template file in custom folder and make the required changes. 
  • Verify using adchkcfg script that custom template will change files as you expect them to be.
  • Now whenever Autoconfig will run it will pick custom template file only.

No comments :

Post a Comment

Query to check session details in Oracle Database

No comments
We can use below query to check the session details.

Query:


select s.ECID ,s.inst_id, s.SID,s.SERIAL#,p.spid,s.status,s.machine, s.ACTION, s.MODULE, s.TERMINAL,s.sql_id,s.last_call_et,s.event, s.client_info,s.PLSQL_SUBPROGRAM_ID,s.PROGRAM,s.client_identifier
, ( SELECT max( substr( sql_text , 1, 40 )) FROM gv$sql sq WHERE sq.sql_id = s.sql_id ) AS sql_text
, ( SELECT object_name FROM dba_procedures WHERE object_id = plsql_entry_object_id AND subprogram_id = 0) AS plsql_entry_object
, ( SELECT procedure_name FROM dba_procedures WHERE object_id = plsql_entry_object_id AND subprogram_id = plsql_entry_subprogram_id) AS plsql_entry_subprogram
, ( SELECT object_name FROM dba_procedures WHERE object_id = plsql_object_id AND subprogram_id = 0) AS plsql_entry_object
, ( SELECT procedure_name FROM dba_procedures WHERE object_id = plsql_object_id AND subprogram_id = PLSQL_SUBPROGRAM_ID) AS plsql_entry_subprogram
, 'alter system kill session ' || '''' || s.SID || ',' || s.serial# ||',@'|| s.inst_id||''''|| ' immediate;' kill_session
from gv$session s ,gv$process p
where
--client_identifier like '%HIMANSHU.SINGH%'
--s.ecid like '%ZnHWOPoUDWbG%'
-- sid=4361
--p.spid='1196'
--s.program like '%ICM%'
and p.addr=s.paddr
and p.inst_id = s.inst_id
;


Note: Un-comment the condition which ever is required.

No comments :

Post a Comment