Announcing a new experience for the Oracle Analytics community coming April 4th!
This category will be read-only as we migrate this space from 3/30-4/4, after which you’ll be able to post as usual. See you there!
BI Publisher - using to_Char in LoV returns Invalid Parameters Requested
Summary
BI Publisher - using to_Char in LoV returns Invalid Parameters RequestedContent
Hi all,
I'm using Oracle Business Intelligence 11.1.1.9.0. I have a report where i would like to use a parameter with LoV which is just a sysdate trimmed to the minute :
TO_CHAR(SYSDATE, 'RRRRMMDDHH24MI')
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.