This content has been marked as final. Show 2 replies
As you are getting an ORA- error, there is nothing wrong with the OBIEE report or with the fact that the you have used Evaluate in the filters.
This seems like an error while parsing a particular row value for the parameters (Booked Date and Line Status Date) you are passing to the work_days_between_ADS function. Pick up the physical sql and fire it directly on the database and try to identify what values are causing the error (probably at line 8 of the function def).