Total Pageviews

Thursday, March 14, 2013

XML Publisher Reports Issues in Oracle Apps  by Avinash Kumar


Hi Firends,

Most of the issues will be solved by below tag:

For Example I have faced below scenarios :

Ex:1 

When output is in CSV format..column payment term. have the values 01-00
but my output was displayed as  'JAN-00'

Answer) I have used below tag to solve the issue <?xdofx:PAYMENT_TERM||'    '?>

Ex: 2

When output is in CSV format column one of the column contain around 20 number like 123757638868363833846846
My CSV output was displayed in exponential value like 12375763e373884 etc...

Answer) I have  used the below tag to resolve the issue.

<?xdofx:SALES_ORDER_NUMBER||'    '?>

Ex : 3

To Get Values in For Total Amount including decimal values. 
123455.00 


Please use below tag

<fo:bidi-override direction="ltr" unicode-bidi="bidi-override"> <?format-number:sum(TOT_AMOUNT);'99G999G999G990D00PT'?> </fo:bidi>


<fo:bidi-override direction="ltr" unicode-bidi="bidi-override"> <?format-number:sum(APPROVED_AMT);'99G999G999G990D00PT'?> </fo:bidi>


<fo:bidi-override direction="ltr" unicode-bidi="bidi-override"> <?format-number:sum(TOTAL_AMT);'99G999G999G990D00PT'?>

Ex : 4

For Summary and Details Reports

Use 

<? if:P_REPORT_TYPE='Summary'?>
<?end if?>

<? if:P_REPORT_TYPE='Detail'?>
<?end if?>



Spiting by Page Break

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

For Looping we use tag

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


Ex : 5 

To hide the column we use 

<?if@column:B_ADDRESS1!=''?><?B_ADDRESS1?><?end if?>




Regards,
Avinash Kumar.

No comments:

Post a Comment