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 |
转载请注明出处:http://blog.csdn.net/pan_tian/article/details/7834973
===EOF===
分享到:
相关推荐
破解Oracle apps 密碼破解Oracle apps 密碼
检查版本信息的一种方法就是选择动态性能查看表V$VERSION。它输出一组标题似的文字,指明Oracle的版本和各种组件的发布级别。但是,要解析这个输出是非常繁琐的。本文将为大家介绍查找Oracle版本信息的简便方法。
oracle apps seminer,Apps 中间层产品技术介绍,应用服务器的 配置及调整
oracle erp gl模块oracle erp gl模块oracle erp gl模块oracle erp gl模块oracle erp gl模块oracle erp gl模块oracle erp gl模块oracle erp gl模块oracle erp gl模块
oracle修改版本工具 很方便,亲测可用,支持oracle10g,11g oracle修改版本工具 很方便,亲测可用,支持oracle10g,11g
Oracle EBS 视频教程 AR模块 一共21讲
主要内容是oracle EBS财务模块,就学习ERP挺好的材料,分为五个部分 Oracle EBS财务模块(一)基本功能 Oracle EBS财务模块(二)基本组成模块 Oracle EBS财务模块(三)总账功能 Oracle EBS财务模块(四)账套 ...
oracleERP分销om模块ppt文档oracleERP分销om模块ppt文档oracleERP分销om模块ppt文档oracleERP分销om模块ppt文档oracleERP分销om模块ppt文档oracleERP分销om模块ppt文档oracleERP分销om模块ppt文档
oracle ebs 财务各模块介绍 doc文档
oracle更改版本软件,可以通过此软件更改oracle的版本进行降级
oracleebs库存模块中文版手册.pdf
Oracle EBS 各模块详解 01采购培训 02库存培训 03销售培训 04应付培训 05总帐培训 06应收培训
ORACLE电子商务套件产品部分模块功能介绍
Oracle EBS 视频教程 AP模块 一共16讲
过过此文档,可以查看你的Oracle版本及所安装选项
win7环境 python2.7引入 oracle模块,里面有32和64位的文件, 如果引入引入cx_oracle报如下错误: cx_Oracle ImportError: DLL load failed: %1 不是有效的 Win32 应用程序。 请把压缩包对应的oci.dll放到%python_...
Oracle高版本的数据导入到低版本 例子 Oracle11g 导入到 Oracle10g
Oracle EBS 总账模块,模块功能介绍,功能使用说明等。
Oracle EBS 采购模块,模块功能介绍,功能使用说明等。