Siebel Business Process & Functionality (MOSC)

MOSC Banner

BI Publisher-Passing Date as a parameter

edited Aug 8, 2012 7:37AM in Siebel Business Process & Functionality (MOSC) 3 commentsAnswered
Hi

I a have a requirement to pass a date parameter which will have the last day of every month, example: 06/31/2012

In my rtf i do the below:

1. declared the parameter as

<?param@begin:P_Date?>

2. <?namespace:psfn=http://www.oracle.com/XSL/Transform/java/com.siebel.xmlpublisher.reports.XSLFunctions?&gt;

3. when i use the below syntax

<?for-each:LcAccountDailyHeader[(psfn:totext(RPTRunDate,"yyyy-MM-dd","MM/dd/yyyy"))=(psfn:totext($P_Date,"yyyy-MM-dd","MM/dd/yyyy"))]?>

where LcAccountDailyHeader is the group and RPTRunDate is my date field i get error when i try to preview the rtf template

I am expecting to pass 06/31/2012 as mentioned above in the $P_Date parameter.

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