Blog dedicated to Oracle Applications (E-Business Suite) Technology; covers Apps Architecture, Administration and third party bolt-ons to Apps

Thursday, September 13, 2007

Forms doesn't launch from self service

I am sure you must have faced this so many times and spent frustating hours debugging it. I'll update this thread with all the possible solutions I have found:

Solution I

Do a ping -s
It should return the correct hostname.domainname
Check whether the hostname.domainname is the value of the context file variable "s_oacore_trusted_oproc_nodes"

grep s_oacore_trusted_oproc_nodes $CONTEXT_FILE

If it is not present, add it in the variable value as ,hostname

Run autoconfig.

Check for the string Allow in Apache configuration files:

grep Allow $IAS_ORACLE_HOME/Apache/Apache/conf/*.conf

Look for the phrase Allow from hostname.domainname

If its not present, add it in all the files.

Bounce Apache

Retest issue

Solution II

vi $IAS_ORACLE_HOME/Apache/Apache/conf/security.conf
Go to end of the file with the vi command: Shift+G
Comment these two lines which begin with SecFilterSelective by placing # before them:

SecFilterSelective "REQUEST_URI" !^/pls/[-a-z0-9_]+/!?[a-z](([a-z0-9_\$#]){0,29})(\.[a-z](([a-z0-9_\$#]){0,29})){0,2}(\?.*
){0,1}$

# Make sure the parameter names contains only valid subset of 7-bit ascii
SecFilterSelective "ARGS_NAMES" !^(([a-z0-9_]){1,30})((\.[a-z0-9_]{1,30}){0,1})$

These lines appear in security.conf after applying ATG_PF.H RUP4 or TXK Rollup O.

Save the file security.conf with vi command :wq

Bounce Apache

Retest issue.

Solution III

14 comments:

fhasweh said...

hi vikram,
i am facing the following and i followd your steps but its not helping so i was worndering if you have any other hint;
"I have the following setup.
Apps tier (web+forms) on srv1 and cm+admin+db on srv2
We are accessing the application using service name (virtual hostname) What we are trying to is incase of srv1 failed it will failover srv2 and we managed to do that. I am able to access the application after fail over but not able to open any forms. Accessing the forms directly from dev60cgi/f60cgi works fine. But access it normally http://host.domain:port doesn’t work. It access the page I open responsibility and when click on the form to open nothing happened. I don’t receive any errors. I enabled the logging at the web server level but there were no errors at all. (error_log, access_log, jserv, ..etc) were all clear

I feel it might be related to dbc file or some profile option. I will appreciation any hint
P.S if I returned the apps tire back to srv2 it will work fine
" i would like to inform you that this is a clone system and i will apply it first on clone then in prod.

thanks
fadi

Vikram Das said...

Hi Fadi,

We faced this recently. Even though you have virtual hostname, some of the processes in Apps check for the hostname by internally issuing hostname command on unix. If you give hostname command on the unix box, it will return the physical name and not the virtual name. As a result, the services do not allow traffic from physical hostname as they are not configured to do so.
My post http://oracleappstechnology.blogspot.com/2007/09/appslocallogin-shows-blank-page-or-http.html has the solution. To be on the safe side, follow these steps also:

grep Allow $IAS_ORACLE_HOME/Apache/Apache/conf/*
grep Allow $IAS_ORACLE_HOME/Apache/Jserv/conf/*

If the files have lines like this one

Allow from virtualservername.com

and do not have a line like this one:

Allow from physicalservername.com

Add it.

Let me know the results after applying the above suggestions. I'll update this post also with the information I have just given you.

- Vikram

fhasweh said...

thank you vikram, i already checked your post and it helped me to resolve the http error before, but for forms still i am facing the same issue. plz if you have any thing in mide let me know

fadi

Vikram Das said...

Hi Fadi,

Do you have the virtual name present in FND_NODES ? Can you mail me your access_log on vikramdas@yahoo.com ?

- Vikram

Anonymous said...

Hi vikram,

I am facing a similar as above...

I did a database upgrade to iig from 9i and ...and after logging to the front end...when i click on any responsability...forms are not loading...no java console...nothing is happening...no error showing anywhere...

do you have any idea what could be wrong?

Vikram Das said...

Hi Praveen,

What appears in your apache access_log when you click on the responsibility ? Do you see anything out of ordinary in the $IAS_ORACLE_HOME/Apache/Jserv/logs/mod_jserv.log or $IAS_ORACLE_HOME/Apache/Jserv/logs/jvm/*

- Vikram

Anonymous said...

Hi Vikram,
I am facing an issue where in one user is not able to open any forms session.
He is able to login,can see all the responsibilities,but if he click on any of those resp. new window opens but hangs there.

we checked with dev60cgi/f60cgi and its working fine....
Any clues to fix this is highly appreciated.

Thnx,
Gireesh

Vikram Das said...

Hi Gireesh,

This seems like a Jinitiator/JRE issue to me. Please uninstall all Jinitiator clients from this user's PC, clear browser cache and the JAR cache and try again. Let me know if the issue still occurs after these steps

- Vikram

Ramakrishna said...

Hi vikram,

In my application frontend open but forms are not open and i searched every logfile of Apache means access.log,error.log

Plese give me the suggestions about this .......

thanks

ramakrishna

samba said...

what types of backups you performed and how will you do a recovery of datafile if we lost permanantely?

samba said...

what types of backups you performed and how will you do a recovery of datafile if we lost permanantely?

B L Krishna Rao said...

Hi Vikram,

Thanks a lot for your blog. We resolved our issue vis this blog. :)

B L Krishna Rao said...

Thanks We solved our issue via this blog . :)

Unknown said...

Hi Vikram,
We just implemented R 12.2.4 , we are running into an issue where we can't launch the oracle form thru HTML.
The problem is that we are not seeing a consistent behavior, at time the form launches at times it does not. For some users it has worked consistently just fine, for some users it works 1 out of 10 times and never at all.

Do you have any suggestions on how to proceed with this issue?