Handle oracle.xdo11g.xqxp.XQException at oracle.xdo11g.xslt.XSLStylesheet.flushErrors

Data Model

Receipts -----> Receipt Accounting
[G_MAIN] ---->[G_DIST]


<?for-each-group:G_RECEIPT?>

Line	Chart of Account	Description	Debit Amount	Credit Amount
<?for-each:G_DIST?> SL	CHART_OF_ACCOUNTS	CHAR_OF_ACC_DESC	0.00	0.00 <?end for-each?>

Amount

xyz

xyz

--xyz

<?sum(./G_DIST[DEBIT_AMOUNT!='']/DEBIT_AMOUNT)?>
<?end for-each-group?>

Here to fetch the sum of debit amounts : you need to write below (./ mean current group, and within current group of G_MAIN, we have another group G_DIST, and we will sum DIST_AMOUNT)
<?sum(./G_DIST/DEBIT_AMOUNT)?>

If you get error, that mean debit or credit amounts are null.

oracle.xdo.XDOException: oracle.xdo11g.xqxp.XQException: FORG0001
at oracle.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:1300)
at oracle.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:308)
at oracle.xdo.template.FOProcessor.createFO(FOProcessor.java:2105)
at oracle.xdo.template.FOProcessor.generate(FOProcessor.java:1208)
at RTF2PDF2.runRTFto(RTF2PDF2.java:484)
at RTF2PDF2.runXDO(RTF2PDF2.java:343)
at RTF2PDF2.main(RTF2PDF2.java:235)
Caused by: oracle.xdo11g.xqxp.XQException: FORG0001
at oracle.xdo11g.xslt.XSLStylesheet.flushErrors(XSLStylesheet.java:1850)

Now to handle this issue, we need to add a condition as below [highlighted in Red]

<?sum(./G_DIST[DEBIT_AMOUNT!='']/DEBIT_AMOUNT)?>
<?sum(./G_DIST/DEBIT_AMOUNT)?>