查看oracle ebs系统的系统版本号以及oracle ebs各个模块的版本号,可以通过下面的SQL来实现:
(1)查看oracle ebs系统版本
SELECT fpg.applications_system_name,
fpg.release_name,
fpg.aru_release_name
FROM fnd_product_groups fpg;
(2)查看oracle ebs各个模块的版本信息
SELECT fa.application_id,
fa.application_short_name,
fpi.oracle_id,
fa.basepath,
fa.product_code,
fpi.product_version,
fpi.status,
fpi.tablespace,
fpi.index_tablespace,
fpi.temporary_tablespace,
fpi.db_status,
fpi.patch_level
FROM fnd_product_installations fpi,
fnd_application fa
WHERE fpi.application_id = fa.application_id
ORDER BY fa.application_short_name;
主要就是从系统表中查询,查询系统信息可以关注下以fnd_为前缀的表。