Oracle XML Tags Example


<?for-each:G_1?> 
<?end for-each?> 

Page Break: <?split-by-page-break:?>

Serial Number : <xsl:value-of select="position()"/>

Summation column : <?sum(current-group()/LINE_AMT)?> 
 
<?end body?> 
SQL function:
<?xdofx:decode(C_AMT_DUE_REM_INV,0,'',C_AMT_DUE_REM_INV)?> 
 
Current date : 
<?xdoxslt:sysdate('DD-MON-YYYY HH24:MI')?>
<?xdoxslt:sysdate('Day Month DD,YYYY')?> 
 
Format Number: 
<?format-number:field_name;'99G999G999G990D99'?>
<fo:bidi-override direction="ltr" unicode-bidi="bidi-override"><?field_number?></fo:bidi-override>
<?xdoxslt:set_variable($_XDOCTX,'V_OP',CS_OP_VAL_NEW)?>

<?xdoxslt:set_variable($_XDOCTX,'V_CLOS',CS_CL_VAL_NEW)?>

<?xdoxslt:get_variable($_XDOCTX,'V_OP')+RECEIPT_VAL-xdoxslt:get_variable($_XDOCTX,'V_CLOS')?> 
 
Sorting:
<?sort:SOURCE1;'ascending';data-type='text'?>
<?sort:SOURCE1;'descending';data-type='text'?>
<?sort:current-group()/ITEM_NAME;'ascending';data-type='text'?> 

 
Condition:
<?xdoxslt:ifelse(condition,true,false)?>
<?xdoxslt:ifelse(0=1,'yes 0 and 1 are equal','No 0 and 1 are not equal')?>
<?xdoxslt:ifelse ((APR) != 0, xdoxslt:div((APR1)*100,(APR)),0)?> ---Not required- <?end if?>

<?xdofx:to_number()?>

<?xdofx:if ../../../../CF_DOCUMENT ='STANDARD' or SECURITY_POR_PO_NUM!=''?> 

<?if: ../../../../CF_DOCUMENT ='STANDARD' or SECURITY_POR_PO_NUM!=''?>


<?if: CF_ACC_CODE='Y'  ?> <?call-template: code_y_acc_y?> <?end if?>

<?if: CF_ACC_CODE='N' ?><?call-template: code_n_acc_n?> <?end if?>
 
<?choose:?>
<?when: CP_RUNFOR='AA'?> ... <?end when?>
<?when: CP_RUNFOR='BB'?> ... <?end when?>
<?end choose?> 
 
<?xdoxslt:toWordsAmt(CS_IGST_AMT)?>

<?template:code_n_acc_n?>

<?end template?>

<?template:code_y_acc_y?>

<?end template?>



Last Page Only Content

<?start@last-page:body?>

<?end body?>



HIDE the COLUMN from the RTF report in ORACLE

Goto the Column Heading and the type the Code like:

In
the if
field we type the code like:

<?if@column:/items/@type="PRIVATE"?>

In
the end if
field we type the code like:

<?end if?>

Then go to the row of open value field.

In
the if
field we type the code like:

<?if@column:/items/@type="PRIVATE"?>

In
the 20.00
field we type the code like:

<?if@column:/items/@type="PRIVATE"?>  <?CF_OPENING_VAL?>  <?end if?>  

In
the end if
field we type the code like:

<?end if?>

Then go to the SUM total of the field and type the code like :

In
the if
field we type the code like:

<?if@column:/items/@type="PRIVATE"?>

In
the end if
field we type the code like:

<?end if?>
 

Displaying image dynamically in XML Publisher (BI Tools) in RTF Template :

Right click on company logo image and click “Size” 
then goto “AltText” tab 
and enter dynamic path in “Alternative Text” field.
e.g. url:{concat(‘${OA_MEDIA}’,’/JG_LOGO.jpg’)}. 
Dynamic Logo: url:{concat('$[OA_MEDIA]','/',//ORG_CODE)}  


BI Publisher software Link