BI Publisher (MOSC)

MOSC Banner

Passing- Date Parameter and syntax

edited Aug 1, 2012 11:02AM in BI Publisher (MOSC) 3 commentsAnswered
Hi

I am trying to pass the parameter value from siebel and i know this should be posted in siebel forum, any sugestions will be helpful.

___________________________________________________________________________________________________________

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

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