BI Publisher (MOSC)

MOSC Banner

Date parameter not displayed in Burst output

edited Nov 30, 2017 10:14AM in BI Publisher (MOSC) 4 commentsAnswered

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.

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