Running Total problem in xdoxslt with xdofx formula

John Bruso1

Summary

How to build a running total with xdoxslt:set_variable when it contains a xdofx formula

Content

Hi All,

 

I am building a BI Publisher RTF report. I am trying to build a running total for a field that has the following formula:

 

<?xdofx:

(

WYO_AMEND_FEE_1 + WYO_AMEND_FEE_2 + WYO_AMEND_FEE_CONS + WYO_AMEND_FEE_OTH + WYO_ORIG_FEE_1 + WYO_ORIG_FEE_2 + WYO_ORIG_FEE_CONST + WYO_ORIG_FEE_OTH

) - 

(

MONETARY_AMOUNT +MERCHANDISE_AMT + WYO_AMT_PD_1+WYO_AMT_PD_2+WYO_AMT_PD_CONS+WYO_AMT_PD_OTH

)?>

 

I am using the following method

 

Set RTotVarCONBAL to 0 at top of page...

<?xdoxslt:set_variable($_XDOCTX, 'RTotVarCONBAL', 0)?>

 

Build and print Running Total in the body...

<?xdoxslt:set_variable($_XDOCTX, 'RTotVarCONBAL', xdoxslt:get_variable($_XDOCTX, 'RTotVarCONBAL') + (xdofx:

(

WYO_AMEND_FEE_1 + WYO_AMEND_FEE_2 + WYO_AMEND_FEE_CONS + WYO_AMEND_FEE_OTH + WYO_ORIG_FEE_1 + WYO_ORIG_FEE_2 + WYO_ORIG_FEE_CONST + WYO_ORIG_FEE_OTH

) - 

(

MONETARY_AMOUNT +MERCHANDISE_AMT + WYO_AMT_PD_1+WYO_AMT_PD_2+WYO_AMT_PD_CONS+WYO_AMT_PD_OTH

)) )?>

 

<? xdoxslt:get_variable($_XDOCTX, 'RTotVarCONBAL')  ?>

 

Print Total

<?xdoxslt:get_variable($_XDOCTX, 'RTotVarCONBAL') ?>

 

ERROR

The error I'm getting is:

[082918_154651385][][ERROR] [Line 443.43] Incorrect XPath: xdoxslt:set_variable($_XDOCTX, 'RTotVarCONBAL', xdoxslt:get_variable($_XDOCTX, 'RTotVarCONBAL') + xdofx:

(

WYO_AMEND_FEE_1 + WYO_AMEND_FEE_2 + WYO_AMEND_FEE_CONS + WYO_AMEND_FEE_OTH + WYO_ORIG_FEE_1 + WYO_ORIG_FEE_2 + WYO_ORIG_FEE_CONST + WYO_ORIG_FEE_OTH

) - 

(

MONETARY_AMOUNT +MERCHANDISE_AMT + WYO_AMT_PD_1+WYO_AMT_PD_2+WYO_AMT_PD_CONS+WYO_AMT_PD_OTH

))

Thanks for your help!

John

Saresh-Oracle

Hi John,

Please let us know the version of BIP.
Found a Bug 19933387 - STRESS:FA:PRC:INCORRECT XPATH ERROR SEEN IN BIPUBLISHER.LOG on BIP 11.1.1.9.

Can you raise a SR with Oracle Support with rtf template and xml data?

Thanks,
Sareesh

 

John Bruso1

Thank you Sareesh.

I'm not able to find that Bug in Oracle support. maybe I'm searching incorrectly.

I can create an SR through my Oracle Support account. Is there a patch for the problem or some other fix?

Thanks,

John

Saresh-Oracle

Hi John,

I did not see any patch . But development team will review your rtf template and xml data and suggest a fix.

Thanks,
Sareesh

John Bruso1

Ok, thanks Sareesh. And, yes, that is my version of BIP.

Saresh-Oracle

Hi John,

Please log a SR for this issue.

Thanks,
Sareesh

John Bruso1

Yup, it's created. 3-18212685491

Saresh-Oracle

Thats good.

I will monitor the SR .

Regards,
Sareesh

John Bruso1

fyi, Sareesh, had to create a new SR for this: SR 3-18297137441