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.