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.
Tagged:
0