1) How do I determine axact version of my oracle Apps Instance
SELECT substr(a.application_short_name, 1, 5) code, substr(t.application_name, 1, 50) application_name, p.product_version version FROM fnd_application a, fnd_application_tl t, fnd_product_installations p WHERE a.application_id = p.application_id AND a.application_id = t.application_id AND t.language = USERENV('LANG') /
2) How do I check and navigate among different TOPs in windows, cd %APPL_TOP% is not switching to the APPL_TOP
3) I want to install one more language to the existing instance, will the cold backup and then the language drive with adpatch will suffice
download-uk.oracle.com/docs/cd/B25284_01/current/acrobat/11iadproc.pdf
Regards, Dimitre