How to determine XMLP BIP Version

Here's a quick 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'
     , '4561451'
     , '4905678'
     , '5097966'
     , '5472959');

This is based on Metalink Note:362496.1 with 5472959 5.6.3 added.