Summary

BI Publisher - using to_Char in LoV returns Invalid Parameters Requested

Content

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. 

Unfortunately, this is Fusion Cloud and i don't have access to creating tables. 

Any ideas how i can generate a unique value for CONTENT_ID? Any other ways of getting the timestamp so I can use it in both Data Model and Bursting Query?

Anyone knows a bi publisher job sequence or number which i can query runtime and use?

Thanks in advance!

Kind Regards,

Aleks