How to determine XML Publisher and Business Intelligence Publisher Version in oracle eBusiness Suite

SQL to get the version of XML Publisher / BI Publisher that you are running in the Oracle eBusiness Suite:

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',

'4905678',

'5097966',

'5472959',

'4561451'

);