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

Search not working for LOV in BI Publisher Report

Accepted answer
edited Feb 11, 2020 10:33PM in Reporting and Analytics for ERP 3 comments


Search not working for LOV in BI Publisher Report


Hi Team,

I have created LOV through SQL in BI Publisher Report. If i am using value without transforming , search is working fine. As soon as i start using to_date or to_char function in the SQL, search stops working. Below are the SQL for the LOV :


LOV Query  : User is able to search Manually 
SELECT GP.period_name as pname
 FROM gl_periods gp
LOV Query : 'User is not able to Search , even though value is available in the list. 
SELECT TO_DATE(gp.period_name,'Mon-yy', 'NLS_DATE_LANGUAGE=ENGLISH') as pname

Howdy, Stranger!

Log In

To view full details, sign in.


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