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).
with error OBI doesn't generate SQL. anyway instead of using DB function I'm trying to incorporate database function functionality within the repository that way I can overcome the issue.