BI publisher date parameter
Dear community,
it seems I have trouble with date parameters in Oracle BI Publisher. I followed the steps below but they did not work
- I set a LOV that returns a date oracle column using an sql that selects a date oracle column, e.g. SELECT DISTINCT PERIOD_FROM FROM EXAMPLE_TABLE
- I created a parameter named P_PERIOD_FROM with Date as Data Type and Menu as Parameter Type. I assigned it the LOV created in step 1.
- I created a simple dataset that has a date parameter, e.g. select id, desc, period_from, status FROM EXAMPLE_TABLE where PERIOD_FROM in (:P_PERIOD_FROM)
0