BIP - Parameterized Report - Does Not Filter Records (Query Integration Object) Based On BIP Report Parameter Values (Doc ID 1603985.1)

Last updated on JULY 20, 2016

Applies to:

Siebel Reports - Version 8.1.1 SIA [21111] and later
Information in this document applies to any platform.

Goal

Currently Report Parameters filter the records  to be displayed in report template once the data XML (record set).

The requirement is to use a value entered as a parameter for a parameterized report to be used in the query against the Integration Object
when preparing the data for the report generation.

For example one might define a param called 'Start Date' and set the IO Query Field property to [Start Date] as defined in the IO.
 
So that at runtime when QueryPage (EAI) method on the IO is invoked , it will filter in addition to the Bookmark.
 
So the search spec to the QueryPage method on EAI Siebel Adapter will be the ddition of User Query + BC Searchspec + Applet SearchSpec  + IO Query Field. 

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms