BI Publisher (MOSC)

MOSC Banner

BI publisher date parameter

edited Jul 27, 2021 8:48AM in BI Publisher (MOSC) 6 commentsAnswered

Dear community,

it seems I have trouble with date parameters in Oracle BI Publisher. I followed the steps below but they did not work

  1. 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 
  2. 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.
  3. 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)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center