Location of apps.conf and mod_wl_ohs,conf

Location : $IAS_ORACLE_HOME/instances/EBS_web_<SID>_OHS1/config/OHS/EBS_web_<SID>/ 

Internet Explorer Has Modified This Page To Prevent Cross-site Scripting

Internet Explorer Has Modified This Page To Prevent Cross-site Scripting

Some time Oracle EBS users will get below errors on IE 9 or IE8 while opening oracle forms.

==> Error

Internet Explorer Has Modified This Page To Prevent Cross-site Scripting

==> Steps to Re-produce

The issue can be reproduced at will with the following steps:

1. Login to E-Business Suite
2. Select any Forms based responsibility
3. Select any Form function to launch Forms

==> Cause

MSIE 8 has implemented a new filter named "Cross Site Scripting [XSS] Filter"

==> Solution

Above issue can be solved by using below options

Click on internet options,

Go to the security section,

Click on the custom level button,

Scroll down to the bottom and disable, XSS filter, and save,

You can see if that is the only setting that needs to be changed,

If it still pops up, go back and disable these three as well,

1) Allow scriptlets

2) Automatic prompting for active x controls

3) Allow status bar updates via script


[Menu Bar ] >Tools > Internet Options >
[Tab] Security > [Button] Custom Level >
Scroll down to entry "Enable XSS Filter" > Select Disable XSS Filter >
Click OK
For permanent solution follow Note ID #  1059574.1]

Send unix text to your email

mail -s "FILE XFER Script" first.lastname@artesyn.com <file_xfer.sh

QUERY TO FIND RESPONSIBILITIES ATTACHED TO A USER IN ORACLE R12

select fu.user_id,
       fu.user_name,
       furg.RESPONSIBILITY_APPLICATION_ID,
       frv.RESPONSIBILITY_NAME
  from FND_USER fu, FND_USER_RESP_GROUPS furg, FND_RESPONSIBILITY_VL frv
 where fu.user_id = furg.user_id
   and furg.responsibility_id = frv.responsibility_id
   and fu.user_name like 'DAV4635'

How to stop a stubborn concurrent request

select ORACLE_PROCESS_ID from apps.fnd_concurrent_requests where REQUEST_ID='137716679';

137716679

update apps.fnd_concurrent_requests set phase_code='C' , status_code='X' where request_id='&REQUEST_ID';

select ORACLE_PROCESS_ID,phase_code,status_code from apps.fnd_concurrent_requests where REQUEST_ID='137716679';

update apps.fnd_concurrent_requests set phase_code='C' , status_code='X' where request_id='137716679';

ADOP phase=fs_clone fails with validation error: the value of s_apps_jdbc_connect_descriptor in PATCH Context File is NULL

1. echo $CONTEXT_FILE
2. cat /upgrade/R12_R12D2/fs1/inst/apps/R12D2_lich/appl/admin/R12D2_lich.xml | grep s_jdbc_connect_descriptor
3. go to fs2
4. vi R12D2_lich.xml
5. replace <jdbc_url oa_var="s_apps_jdbc_connect_descriptor/"> with <jdbc_url oa_var="s_apps_jdbc_connect_descriptor">jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS=(PROTOCOL=tcp)(HOST=ghoul.ecp.priv)(PORT=1531)))(CONNECT_DATA=(SERVICE_NAME=R12D2)))</jdbc_url>