Oracle Access Manager installations include a directory named \lang, which includes a named subdirectory for each installed language. For example, \lang\ en-us contains English-specific directories and files that are included with every installation.
One easy way is this:
System Administrator --> Oracle Applications Manager --> Patching and Utilities --> Search with Language or Days
Hope this helps..
You can also check from
select bug_number,language from ad_bugs where language='US'
select bug_number,language from ad_bugs where language='RU'
Try this query:
select patch_name, patch_type, driver_file_name, platform, pdl.creation_date, language
from ad_applied_patches ap, ad_patch_drivers pd, ad_patch_driver_langs pdl
where ap.applied_patch_id = pd.applied_patch_id
and pd.patch_driver_id = pdl.patch_driver_id
order by 1,5;
Thanks for the reply Bashar,
The query fetched approx 2500 rows giving list of patches and its languages installed.
Still i could not get how to check the MLS patches.
Are you suggesting the list of patches are all includes MLS patches ?
The language column means the NLS version of the patch.
If you have 100 US patches that are available for other languages then you should have 1500 patches for non-US languages.
15 langs x 100 = 1500