[ORACLE EBS]9. The version of Oracle XML Publisher for Oracle EBS

基于Metalink 362496.1
从文档里看，没有直接的地方可以查询到XML PUBLISHER的版本。

最有用的是，从生成的REPORT里查询它的版本。
具体如下，
PDF Output : open the file in Adobe Acrobat
-> menu File
  -> Document Properties
    -> tab Description
      -> property ‘PDF Producer’ will show e.g. Oracle XML Publisher 5.6.2
RTF Output : open the file in MS Word
-> menu File
  -> Properties
    -> tab Summary
      -> property ‘Comments’ will show .e.g. Generated by Oracle XML Publisher 5.6.1

HTML and Excel output : open the file in Notepad
-> line 4 or 5 will show e.g. Generated by Oracle XML Publisher 5.6.1

One of ways to generate an output file is via the Preview functionality which is available under the XML Publisher Administrator responsibility. Navigation path :
-> Tab : Templates
  -> select a Template
    -> choose Preview
      -> save the PDF to the client PC
        -> provide the PDF file to Oracle Support

但这样一来，不能直接查询，从SQL来看的话，可能会遗漏最新版本。
--11i
SELECT DECODE (bug_number,
               '3554613', '4.5.0',
               '3263588', 'XDO.H',
               '3822219', '5.0.0',
               '4236958', '5.0.1',
               '4206181', '5.5.0',
               '4561451', '5.6.0',
               '4905678', '5.6.1',
               '5097966', '5.6.2',
               '5472959', '5.6.3'
              ) patch,
       bug_number
  FROM ad_bugs
 WHERE bug_number IN
          ('3554613',
           '3263588',
           '3822219',
           '4236958',
           '4206181',
           '4561451',
           '4905678',
           '5097966',
           '5472959'
          );
-----------------------------------
XDO.H     3263588
4.5.0     3554613
5.0.0     3822219
5.5.0     4206181
5.0.1     4236958
5.6.0     4561451
5.6.1     4905678

--R12
SELECT DECODE (bug_number, '4440000', '5.6.3') patch, bug_number
  FROM ad_bugs
 WHERE bug_number IN ('4440000');
-------------------------------------
5.6.3 4440000

还有一个，就是下命令，但也要知道对照表,  如果有不在里面的，至少知道有新的版本了，
adident Header $OA_JAVA/oracle/apps/xdo/common/MetaInfo.class
$Header MetaInfo.java 115.26 2005/12/28 10:08:39 bgkim noship $

... for the Oracle E-Business Suite R12
120.6 XDO 5.6.3 Patch 4440000
 
... for the Oracle E-Business Suite 11i
115.28 XDO 5.6.3 Patch 5472959 Note 422508.1 11i.ATG_PF.H.delta.5
115.27 XDO 5.6.2 (core) Patch 5097966 Note 367394.1
115.26 XDO 5.6.1 Patch 4905678 Note 357308.1
115.24 XDO 5.6.0 Patch 4561451 Note 337999.1
115.22 XDO 5.5.0 Patch 4206181 Note 316447.1
115.21 XDO 5.0.1 (core) Patch 4236958
115.19 XDO 5.0.0 Patch 3822219 Note 295036.1 11.5.10.1 / 11.5.10.2 / 11i.ATG_PF.H.RUP3 and RUP4
115.15 XDO 4.5.0 (XDO.H) Patch 3263588 Note 269605.1 11.5.10
115.12 XDO 4.3.0 (core)

也不知道ORACLE怎么想的，搞那么复杂。