You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

BI Publisher report parameters do not work

Summary:

Requisition Header Description based parameter is not working

Content (please ensure you mask any confidential information):

I have created a BIP report for Requisition details. One of the asks is to provide a parameter based on Requisition Header Description. So, i have created a LOV with below SQL and assigned it to a parameter (REQ Description).

LOV SQL: select distinct DESCRIPTION from POR_REQUISITION_HEADERS_ALL where DESCRIPTION is not null

When i click on view Data, its not showing values for all Menu Parameter Types, its only showing Calendar Parameter type.

When I 1. change Description parameter to Text type or 2. restrict above SQL with rownum<10, it works fine.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!