Date parameter not displayed in Burst output
Hi,
Oracle R12.1.3
Oracle BI Publisher Desktop 11.1.1.7
Unix AIX
-------------------------------------------------------------------------
This is my data definition
<?xml version="1.0" encoding="UTF-8"?>
<dataTemplate name="XXNPG_OIE_PENDING_CLAIMS" description="iExpense Pending Claims Report" Version="1.0">
<parameters>
<parameter name="P_DATE" dataType="character"></parameter>
</parameters>
<dataQuery>
<sqlStatement name="Q1">
<![CDATA[
and Burst report I am accessing the P_DATE which is displaying as null.
Please be advised that the expense claim(s) you submitted on or before ${P_DATE} which were sent to ${APPRV} for approval have not yet been approved or rejected.
It is retrieving the date values in test systems but not in Live.