Please ask to DBA to bounce the OACore

Hi Thank you, YGUTTIKONDA wrote:try using XDOFX commands or XSLT samples below <?xdofx:to_char('12345')?><?xdofx:to_number('12345')?><?format-number:fieldname;'999G999D99'?> How to use above code with SQL code ? <LINE_AMOUNT>100<LINE_AMOUNT/> -->it is displaying 100.00000 if i use <?format-number:fieldname;'999G999D9999'?>…

Thank you for help! Have u tried to_char () in ur orginal query???? No, i can't PO_STANDARD_PO.xsd is the source file which is having xml code. Sample code: <xs:element ref="LINE_AMOUNT" minOccurs="0"/> I used <?format-number(LINE_AMOUNT, '#,##0.00', 'myFMT')?> in rtf template but getting Caused by:…

Thank you Violeta, It was printing if the LINE_AMOUNT is like 200, but it is not working if i have 2,000.00(the generated XML data tag) FYA...if the XML data tag generated 2400.52 then it will be working for me(2400.52000), but the data was generated like 2,400.52. Please let me know if any questions

Is this syntax <?xdofx:TO_CHAR(fieldname, '9,999,999.99')?> will display 5 decimals? like 1,000.00000

used like as you suggested but no luck.

I have used <?format-number:LINE_AMOUNT;'999G999D99999'?> But still it is showing like this. 14,589.52 FYA...old code for LINE_AMOUNT Could you please help me?

Hi Experts, Could you please help me on this?

How to use to-char?

are you using like this or adding pic directly ?

Could you please help me on this?

Thanks for your help. Can you please help me where & how to add the above code in the below sample file? Thanks again,

3591335 wrote:How many pages are there ....how you want to use and what do u mean by 2,3 and last page. I will have max 3 pages lines data for one Order Number. I have header and lines data only , i don';t have total amount (ex: Total on last page). Ex: Page 1of 1 Order Number 1234 Order Date <?Order_Date?> Order Total…

Like this? <?start:body?> <?call-template:header_details?> --->for page1?? <?call-template:header_details1?> --->for page2?? <?call-template:header_details2?>--->for page3?? <?for-each@section:XMLELEMENT?> <?call-template:line_details?> <?end for-each?> <?end body?> Please correct me!

3591335 wrote:Main Template : <?call-inline-template:invoice_logo?> Sub template: <?if order =1234?>I pasted the actual logo for order1234.jpg image<?end if?> <?if order number =2345?>I pasted the actual logo for order1456 .jpg image<?end if?> like that try it Thanks , Actually i don't have any filters to display different…

Hi ​ ​ ​ ​ Could you please help me on this requirement ? Inv Org :Pick Slip : Page: 1 of 1Order Number : 1234 <<...I need this only on first page if the order has more than one page lines..>>Order Number Order Type Pick Slip No CarrierCust. Date Delivery Number <<.......>>Line No Item No Qty…

Could you please help me on this?

Could any one help me on this?

you doing EBS bi publisher correct ? then follow my link...the one which i provide example is the sample.

what kind of delivery you want PDF to folder, Burst to Email , printer?<?xml version="1.0" encoding="UTF-8"?><xapi:requestset xmlns:xapi="http://xmlns.oracle.com/oxp/xapi" type="bursting"> <xapi:request select="/DATA_DS/G_1"> <xapi:delivery> <xapi:filesystem id="pdftofolder"…