BI Publisher (MOSC)

MOSC Banner

Display Date Parameters on EBS env

edited Oct 3, 2019 5:02AM in BI Publisher (MOSC) 10 commentsAnswered ✓

On EBS R12, I have a couple of date parameters defined for a XML report, using data definition template:

P_START_DATE and P_END_DATE, the value set: FND_Standart_Date.

In the data definition XML

<parameters>

    <parameter name="P_START_DATE" datatype="Date"></parameter>

    <parameter name="P_END_DATE" datatype="Date"></parameter>

</parameters>

<sqlstatement name="Q_EMP_DATA">

<![CDATA[

select distinct

...

and pss.actual_termination_date between fnd_date.canonical_to_date(:P_START_DATE)  and fnd_date.canonical_to_date( :P_END_DATE)

...

]]>

The report pulls rows correctly. But I am trying to display the two date parameters:

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