BI Publisher - using to_Char in LoV returns Invalid Parameters Requested
SummaryBI Publisher - using to_Char in LoV returns Invalid Parameters Requested
I'm using Oracle Business Intelligence 188.8.131.52.0. I have a report where i would like to use a parameter with LoV which is just a sysdate trimmed to the minute :
I make this parameter hidden because i want the value to be same for a content_id used in bursting query too.
The problem is that when i use to_char in LoV , the report returns error 'Invalid Parameters Requested'.
I came across a MOS note saying that we have to avoid using functions like to_char and the workaround is to populate a temp table in event trigger and then to query that table.