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.