My Oracle Support Banner

OBIEE 11g: INSERTVIEW function not working when pulling the report from OBIEE in SmartView (Doc ID 2190071.1)

Last updated on DECEMBER 02, 2019

Applies to:

Business Intelligence Server Enterprise Edition - Version to [Release 11g]
Information in this document applies to any platform.


Followed the document for using the InsertView function.

When trying to run the same report using SmartView without the VBA code it takes the prompt values and runs just fine. However, when using the InsertView function the excel sheet remains empty.

Check SmartView log.

Used the note How to Enable Smart View Logging? (Doc ID 1354457.1) to generate the SmartView log.

You should see the below error

Report Path failed Invalid report view id




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.