EBS 常用 sql

登录sql：

[root@ebslouis ~]# su - oracle
[oracle@ebslouis ~]$

[oracle@ebs 4318672]$ source /home/oracle/.ora
[oracle@ebslouis ~]$ sqlplus /nolog

SQL> conn /as sysdba
Connected.
SQL> conn apps/apps
Connected.
SQL>

 

1. 查看patch是否打上

SQL> select * from ad_bugs where bug_number='4318672';

 

2. 查看EBS版本

select product_group_name, product_group_type, release_name from fnd_product_groups;

 

3. 查看用jre模式的基础patch是否安装

select bug_number, decode(bug_number,
'3438354', '11i.ATG_PF.H',
'4017300', '11i.ATG_PF.H.RUP1',
'4125550', '11i.ATG_PF.H.RUP2',
'4334965', '11i.ATG_PF.H RUP3',
'4676589', '11i.ATG_PF.H RUP4',
'5382500', '11i.ATG_PF.H RUP5 HELP',
'5473858', '11i.ATG_PF.H.5',
'5674941', '11i.ATG_PF.H RUP5 SSO Integrat',
'5903765', '11i.ATG_PF.H RUP6',
'6117031', '11i.ATG_PF.H RUP6 SSO 10g Integration',
'6330890', '11i.ATG_PF.H RUP6 HELP',
'6241631', '11i.ATG_PF.H.RUP7',
'8248307', '11i.ATG_PF.H RUP7 HELP'
) n_patch, last_update_date
FROM ad_bugs
WHERE bug_number
IN ( '3438354', '4017300', '4125550', '4334965', '4676589', '5382500', '5473858', '5674941', '5903765', '6117031', '6330890', '6241631', '8248307' );

 

4. 查询 form compiler 版本

[root@ebslouis oracle]# su - oracle

[oracle@ebslouis bin]$ source /home/oracle/.app

[oracle@ebslouis bin]$ cd /d01/oracle/visdb/9.2.0/bin

[oracle@ebslouis bin]$ f60run
Forms 6.0 (Forms Runtime) Version 6.0.8.24.1 (Production)

Forms 6.0 (Forms Runtime): Release  - Production

 

5. 查询 Developer 6i Patch 版本

Forms: 6.0.8.28.x --> Developer 6i Patch 19
Forms: 6.0.8.27.x --> Developer 6i Patch 18
Forms: 6.0.8.26.x --> Developer 6i Patch 17
Forms: 6.0.8.25.x --> Developer 6i Patch 16
Forms: 6.0.8.24.x --> Developer 6i Patch 15

 

6. 查看EBS安装的所有patch

select bug_number patch_id from ad_bugs;

 

7. 查看EBS安装完系统后打的patch

SELECT distinct ap.patch_name,decode(ab.application_short_name, null, mini.app_short_name,ab.application_short_name) application_short_name,ap.patch_type patch_type, mini.patch_level patch_level,ap.last_update_date Applied FROM applsys.ad_bugs ab, applsys.ad_applied_patches ap,applsys.ad_patch_drivers pd, applsys.ad_patch_driver_minipks mini WHERE ab.bug_number = ap.patch_name and ap.applied_patch_id = pd.applied_patch_id and pd.patch_driver_id = mini.patch_driver_id(+) ORDER BY ap.last_update_date desc；

 

8. 查看oracle版本号

SQL> select * from v$version;