[Oracle EBS] 9. The version of Oracle XML Publisher For Oracle EBS

Source: Internet
Author: User
Based on Metalink 362496.1
From the document, the XML Publisher version is not directly available.

The most useful is to query its version from the generated report.
The details are as follows,
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

However, the latest version may be omitted from the SQL statement.
-- 11i
Select decode (bug_number,
'123', '4. 123 ',
'123', 'xdo. H ',
'123', '5. 123 ',
'123', '5. 123 ',
'123', '5. 123 ',
'123', '5. 123 ',
'123', '5. 123 ',
'123', '5. 123 ',
'123', '5. 123'
) Patch,
Bug_number
From ad_bugs
Where bug_number in
('20140901 ',
'123 ',
'123 ',
'123 ',
'123 ',
'123 ',
'123 ',
'123 ',
'123'
);
-----------------------------------
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, '123', '5. 123') patch, bug_number
From ad_bugs
Where bug_number in ('123 ');
-------------------------------------
5.6.3 4440000

There is another one, that is, the command, but you also need to know the table. If there is something not in it, you should at least know that there is a new version,
Adident header $ oa_java/Oracle/apps/xdo/common/metainfo. Class
$ Header metainfo. Java 115.26 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)

I don't know what Oracle thinks. It's so complicated.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.