BI Publisher Add-In does not show up in Office 2010/Windows 7

If you are installing BI Publisher for the first time in your Laptop .If you have a Windows 7 (64 bit) Laptop and if your MS office is a 32 bit version, you will face this issue.

Where can i see my office version

word_version

The XML Publisher installation will be smooth, but if you open the MS Word you will not see the Add in Option in the tool bar.

issue

Because you are installing a software that’s compatible on a 32 bit version on a 64 bit machine, Microsoft makes this Add in as an Inactive Add in

Open MS Word.go to File–> Options – Word options box opens and in that go to Add Ins

add_in

Under the Inactive application Add on you will see “BI Publisher Template for Word” as a COM Add in. In the above screen shot it shows active because i have fixed the issue

If you go to Manage: COM Add in at the bottom and try to enable this Add in, because its considered malicious Microsoft is going to make it Inactive again.

manage

The only way out is You need to install “Visual Studio 2010 Tools for Office Run time” from Microsoft site, its a free executable.  Visual Studio 2010 download link The moment you install this “BI Publisher Template for Word” will become an active Add on and then bing!, you will see the BI Publisher Add in show up once you restart your word.

fixed

Caution: Close all MS Office related stuff during this installation process .

Regards

Hari

List Of Responsibilities to which a concurrent program is Attached

This simple query can help you to identify the list of responsibilities to which a concurrent program is attached.

SELECT DISTINCT responsibility_name
FROM apps.fnd_responsibility_vl frv,
apps.fnd_request_group_units frg,
apps.fnd_concurrent_programs_tl fcp
WHERE frv.request_group_id = frg.request_group_id
AND frg.request_unit_id = fcp.concurrent_program_id
AND fcp.user_concurrent_program_name = ‘<Concurrent Program Name>’