如何查看Oracle Apps的版本信息以及模块信息

1.如何查询EBS系统的版本信息
Query:

select release_name from apps.fnd_product_groups;

Table FND_PRODUCT_GROUPS
FND_PRODUCT_GROUPS stores information about what release, language and type of product group (for example, Standard or Demonstration) you have installed at your site. FND_PRODUCT_GROUPS also stores supplementary information about the product group type in the ARGUMENT1 column. FND_PRODUCT_GROUPS is used mainly by AutoInstall. Oracle Application Object Library uses this information to provide you with release information when you do \ Help Version. You should never modify this table. The CODESET column is no longer used and may contain the value 'Not Used'.

2.如何查看EBS安装了哪些模块，以及这些模块的Level
Query:

select fpi.application_id
,fpi.status
,fpi.patch_level
from fnd_product_installations fpi

Table FND_PRODUCT_INSTALLATIONS
FND_PRODUCT_INSTALLATIONS stores information about Oracle Applications products at your site. Each row includes a value identifying the application (APPLICATION_ID), a value identifying the database account (ORACLE_ID), the product's version number (PRODUCT_VERSION), the product's status at your site (STATUS, where I means installed, L means custom, N means not installed, and S means installed as shared product), and the product's industry (INDUSTRY, where C means for commercial or for-profit use, G means for educational or not-for-profit use, B means Project Billing, and P means Project Costing). Each row also includes the names of the tablespace in which the application tables, indexes, and temporary objects reside (TABLESPACE, INDEX_TABLESPACE, and TEMPORARY_TABLESPACE), and the sizing factor for the product (SIZING_FACTOR). Oracle Applications uses this information to display product version numbers when you choose \ Help Version, when installing and upgrading your database, and for other purposes.

Status Field

 

Value Meaning

L	Custom
N	Not installed
S	Shared
I	Installed