Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Format data-type in xml Publisher desktop?

2913299Jul 3 2015 — edited Jul 10 2015

Hi all..

<G_CUSTOMER_TRX_ID>

            \< INVOICE\_NUM\>001201200120\</INVOICE\_NUM\>

            \<INVOICE\_DATE\>10-MAY-12\</INVOICE\_DATE\>

            \<CUST\_NUM\>45532\</CUST\_NUM\>

            \<TYPE\_NAME\>INVOICE\</TYPE\_NAME\>

</G_CUSTOMER_TRX_ID>

<G_CUSTOMER_TRX_ID>

            \< INVOICE\_NUM\>00120-1200120-ABC\</INVOICE\_NUM\>

            \<INVOICE\_DATE\>10-MAY-12\</INVOICE\_DATE\>

            \<CUST\_NUM\>45578\</CUST\_NUM\>

            \<TYPE\_NAME\>INVOICE\</TYPE\_NAME\>

</G_CUSTOMER_TRX_ID>

7-3-2015 10-27-59 PM.jpg

This is my .xml.

i create template for field Invoice_Num, Invoice_Date, Cust_Num, Type_Name.

Invoice_Num in table using type Varchar2, and with .rtf using type Regular Text.

But, if i try preview with Excel, for invoice_num i get data -- > 1201200120 and 00120-1200120-ABC.

Why '0' not show? i want in excel output i get data 001201200120 and 00120-1200120-ABC.

Please help me.

Thanks all..
This post has been answered by Jagadekara on Jul 7 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 7 2015
Added on Jul 3 2015
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-standard-edition-one
8 comments
6,456 views