Note:362496.1:How to Determine the Version of Oracle XML Publisher for Oracle E-Business Suite 11i and Release 12

轉自Metalink：Note:362496.1

Goal

How can the current version of Oracle XML Publisher on an Oracle E-Business Suite environment be determined? This document applies to both the Oracle E-Business Suite 11i and the Oracle E-Business Suite Release 12.

Solution

There are various ways to find the version of Oracle XML Publisher.

1. Based upon an output file generated by XML Publisher

• PDF Output
  
  1. Open the PDF document in Adobe Reader
  2. Open the menu File
  3. Select Document Properties
  4. Click on the tab Description
     
  ==> The property ‘PDF Producer’ will show e.g. Oracle XML Publisher 5.6.3.
• RTF Output
  
  1. Open the RTF document in Microsoft Word
  2. Open the menu File
  3. Select Properties
  4. Click on the tab Summary
  ==> The property ‘Comments’ will show .e.g. Generated by Oracle XML Publisher 5.6.3
  
• HTML and Excel output
  
  1. Open the document in Notepad (or any other plain text editor)
     
  ==> line 4 or 5 will show e.g. Generated by Oracle XML Publisher 5.6.1
  

One option to generate an output file is via the Preview functionality which is available under the XML Publisher Administrator responsibility. Navigation path :

1. Responsibility: XML Publisher Administrator
2. Function: Templates
3. Select a Template for which a Preview Data file has been uploaded before
4. Click on the Preview icon
5. Save the PDF to the client PC
6. Determine the version either by the above instructions OR provide the PDF file to Global Customer Support..
   

2. Based upon the applied patches

Every patch that is installed on the system will have a record in the table AD_BUGS. Either one of the following SQL statements can be used to determine which Oracle XML Publisher patches are applied, depending on the release of Oracle Applications that is installed.

2.1. Oracle E-Business Suite 11i

The following SQL statement will show which patches and thus with version of Oracle XML Publisher is installed on an Oracle E-Business Suite 11i environment:

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');

PATCH BUG_NUMBER
----- ------------------------------
XDO.H 3263588
4.5.0
3554613
5.0.0 3822219
5.5.0 4206181
5.0.1 4236958

2.2. Oracle E-Business Suite Release 12

The following SQL statement will show which patches and thus with version of Oracle XML Publisher is installed on an Oracle E-Business Suite Release 12 environment:

SELECT DECODE (bug_number, '4440000', '5.6.3') PATCH, bug_number

FROM ad_bugs
 WHERE bug_number IN('4440000');

PATCH BUG_NUMBER
----- ------------------------------
5.6.3 4440000

Note: Patch 4440000 is in fact the base release of the Oracle E-Business Suite Release 12. It is provided via the Oracle E-Business Suite Applications Release 12.0 Media Pack and not as a standalone patch.

3. Based upon the file version of the MetaInfo.class

The version of a specific Java Class has a one to one relationship with the currently installed version of Oracle XML Publisher. This method is suitable for both Oracle E-Business Suite 11 and Release 12.

$ adident Header
$OA_JAVA/oracle/apps/xdo/common/MetaInfo.class
$Header MetaInfo.java 115.19 2004/11/30 02:45:52 tsuzuki noship $

The following matrix shows the corresponding XML Publisher version for each version of MetaInfo.class:

Metainfo.class	XML Publisher	Patch	Reference	Included in ...
... for the Oracle E-Business Suite Release 12
120.6	5.6.3	Patch 4440000	Note 422508.1	Release 12 (12.0.0)
... for the Oracle E-Business Suite 11i
115.28	5.6.3	Patch 5472959	Note 422508.1	11i.ATG_PF.H.delta.5
115.27	5.6.2 (core)	Patch 5097966	Note 367394.1
115.26	5.6.1	Patch 4905678	Note 357308.1
115.24	5.6.0	Patch 4561451	Note 337999.1
115.22	5.5.0	Patch 4206181	Note 316447.1
115.21	5.0.1 (core)	Patch 4236958
115.19	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	4.5.0 (XDO.H)	Patch 3263588	Note 269605.1	11.5.10
115.12	4.3.0 (core)	Patch 3395631

In order to upgrade to a newer release, there's no requirement to apply all previous versions. For example, if the current version is Oracle E-Business Suite 11.5.10, then one can directly upgrade to XML Publisher 5.6.3 by following the instructions as described Note 422508.1.

Note: The 'core' patches provide ONLY the XML Publisher core classes and do not upgrade e.g. the User Interface (UI) within the Oracle E-Business Suite. The 'core' patches only offer specific bug fixes on top of the previous version, e.g. XDO 5.6.2 is a core patch on top of 5.6.1. Is NOT recommended to apply ONLY a core patch as it may break the UI.