Method1:
Query to get Application Top in Oracle applications
SELECT VALUE
FROM fnd_env_context
WHERE variable_name LIKE '%_TOP'
AND concurrent_process_id =
(SELECT MAX (concurrent_process_id) FROM fnd_env_context)
AND variable_name IN
(SELECT B.BASEPATH
FROM FND_APPLICATION_TL T, FND_APPLICATION B
WHERE B.APPLICATION_ID = T.APPLICATION_ID
AND T.APPLICATION_NAME = 'your Application Name');
Method2:
1. Find Basepath from front end with application name
2. Find Application Top in server by using basepath
1. Find Basepath from front end with application name
Find Application Top from front end Oracle applications
Navigation >System Administrator >Application>Register
You can find following details as below screenshot
Application Short Name
Application Basepath
Application Description
2. Find Application Top in server by using basepath
You need to connect sever and give following command as show below
>cd $CUST_AP_TOP
>pwd
Salama Aleikum,
ReplyDeleteI’ve often thought about this #topic. Nice to have it laid out so clearly. Great eye opener.
Our project DBA Team is planning to migrate Oracle DB from version 11.2.0.4 to 12.2.0.1.
Could you please let mw know what the ares which gets impacted from
DB Development Team prospective.
Our DBA Team will take care of up gradation.
But I want to know any deprecated concepts/impacted ares in Higher version?
Current Version :Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
Thanks a lot. This was a perfect step-by-step guide. Don’t think it could have been done better.
Obrigado,
Generally there are a few different alternatives that you could consider deciding on here to the extent assembling a remarkable Phone application is concerned. website to app
ReplyDeleteHello,
ReplyDelete11/10!! Your blog is such a complete read. I like your approach with How to find Application Top in Oracle Applications R12. Clearly, you wrote it to make learning a cake walk for me.
how to find first nonspace character from end of the string
ex: 'abc def g '
I should get 4 in this case. (the first nonspace character from backwards in the above example is g and the position is 4 from backwards.
Could you help me in getting this?
I am so grateful for your blog. Really looking forward to read more.
Best Regards,
Radhey
Oracle apps and Fusion Self Paced Training Videos by Industry Experts. Please Check oracleappstechnical.com
ReplyDelete