Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
BI Publisher - using to_Char in LoV returns Invalid Parameters Requested — Cloud Customer Connect
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

BI Publisher - using to_Char in LoV returns Invalid Parameters Requested

Received Response
15
Views
2
Comments
edited Sep 11, 2019 5:18AM in Oracle Analytics 2 comments

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. 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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