Hi Thomas, As I understand this should be under OutboundPaymen because PayeeBankAccount comes under that XML tag. There are two ways we can achieve 1111 into 1+1+1+1 = 4 .. 1. We can create custom tag using standard user hook package(IBY_FD_EXTRACT_EXT_PUB) that oracle provide for Payment format customization . There we…

I tried its working for me...could you please upload template and sample xml

in youe sample XML you have only one <PayeeBankAccount> which is 26900161931. and after calculation its returning ten digit 6900161931, which is correct as per your code. Since you have only one PayeeBankAccount then what sum you are expecting ? Regards, Brajesh

Thanks you Thomas, But calculation is under OutboundPaymentInstruction, that confused me. If under OutboundPaymentInstruction we have multiple OutbondPayment under that multiple PayeeBankAccount will be there so which PayeeBankAccount digit we are going to SUM since the logic is at the OutboundPaymentInstruction level. I…

I cannot see any group in your excel template? Please create group to repeat the row for XML group, it should work after that

You can do below <?xdofx:to_date(INVOICE_DATE,'DD-MM')?>-<?xdofx:to_date(INVOICE_DATE,'YYYY')+1?>

You can very much do it using repeating header feature of XML publisher use <?for-each@section:GROUPNAME?> You can see example of repeating header under Wiindow Start Menu > BI Publisher Desktop\samples\RTF templates\Advanced\RepeatingHeader

Please use <?xdoxslt:sysdate()-1?>

From the Window Start Menu > Oracle BI Publisher Desktop > 'Template Viewer' It will open template viewer window from there on top Working Directory select the path where your excel template is there. Same path place your XML data, on the Template Viewer window left side you can see XML data and Right side you can see your…

Hi, Busting program will not restrict size of the output. This may be issue with the space available for busting in busting path directory. Go to XML Publisher Administrator > Administration tab > Under Property > General > Temporary directory , please check what is the directory path provided here. This is the path used…

Looks like you template got crashed. Can you copy the content into different Word Document and save it as rtf. Then load data and try to open properties

Can you upload your rtf and sample xml

What is your source of data? where do you get the XML data for your report? We need to create one tag for the url in that XML and need to use that in rtf template

We cannot control excel column width using RTF template, but you can try fixed width but heigth 100% in cell proprty. This will wrap the text in EXCEL if it exceed in width At the table level, specify fixed width: Example <fo:table start-indent="-0.35pt" xdofo:table-summary="Template Table 1" xdofo:row-header-count="0">…

Hi , Can you create the XDO_METADATA for if condition and use it on excel. <xsl:if test=".//INVOICE_TYPE='PREPAYMENT'"> </xsl:if> Regards, Brajesh

Hi, You can use Excel if condition . In your case "I need to display cell data (Egs Column A) only if another cell (Egs Column B) contains data" in this case for cell A you can write like below =IF(B1="","",A1) --it means If B is blank then A also will be blank and if B is not blank then it will display value of A Above is…

WHat is the oracle seeded report name?