Modified:

29-Mar-2014

Type:

HOWTO

Applies to:

BI Publisher (formerly XML Publisher) - Version 11.5 to 12.1 [Release 11.5 to 12.1]
BI Publisher (formerly XML Publisher) - Version 5.6.3 to 5.6.3 [Release 5]
Information in this document applies to any platform.
Executable:XDOREPPB - Generate PDF from XML output and given template
Checked for relevance on 18-MAR-2013

Goal

Solution

There are various ways to find the version of Oracle XML Publisher.  This document applies to both the Oracle E-Business Suite 11i and the Oracle E-Business Suite Release 12 (12.0 and 12.1).

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 document property named PDF Producer will show e.g. Oracle XML Publisher 5.6.3.

• RTF Output
  
  1. Open the RTF document in Microsoft Office Word
  2. Open the menu File
  3. Select Properties
  4. Click on the tab Summary

  → The property named 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)
  2. Go to line 4 or 5

  → On this line it will show e.g. Generated by Oracle XML Publisher 5.6.1

An output file can be generated via the Preview functionality available under the XML Publisher Administrator responsibility.

Navigation path :

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

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.0.1 4236958

5.5.0 4206181

5.6.0 4561451

5.6.1 4905678

5.6.2 5097966

5.6.3 5472959

2.2. Oracle E-Business Suite Release 12.0 and 12.1

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.0 and 12.1 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

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:

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.

4. Additional patches for XML Publisher

Note 1138602.1 Overview of Available Patches for Oracle XML Publisher (embedded in Oracle E-Business Suite) provides a comprehensive list of recommended patches on top of the base releases described in this document. It is highly recommended to review this document for additional patch information.

References

NOTE:269605.1 - About Oracle XML Publisher Release 4.5
NOTE:295036.1 - About XML Publisher Release 5.0
NOTE:316447.1 - About Oracle XML Publisher Release 5.5
NOTE:337999.1 - About XML Publisher Release 5.6
NOTE:357308.1 - About Oracle XML Publisher 5.6.1
NOTE:422508.1 - About Oracle XML Publisher Release 5.6.3
PATCH:3263588
PATCH:3395631
PATCH:3822219
PATCH:4206181
PATCH:4236958
PATCH:4561451
PATCH:4905678
PATCH:5097966
PATCH:5472959
NOTE:1138602.1 - Overview of Available Patches for Oracle XML Publisher embedded in the Oracle E-Business Suite
NOTE:367394.1 - About Oracle XML Publisher Release 5.6.2