Sitemap

Amicuk Programming Answers

Xml Publisher to Excel Output Trailing sign problem

2015-10-11   Views:2

Advertisement

Hi Experts, I have developed one XML report which output type is EXCEL in Oracle Application. I am getting some -ve value in the report so I need to do the trailing sign Menace for example I got a value -8645 I need to display the value like (8645).

Hi Experts,
I have developed one XML report which output type is EXCEL in Oracle Application.
I am getting some -ve value in the report so I need to do the trailing sign
Menace for example I got a value -8645 I need to display the value like (8645).
This functionality is working in PDF output but in EXCEL out put it is not working.
Could any body please help me on this..
Its Urgent .
Thanks in Advance.

The replay answer
Advertisement
Hi,
<?xdoxslt:abs(ELEMENT_NAME)?>
use above one i think this may work

Go to See the other 2 answers

Xml Publisher to Excel Output Trailing sign problem

Category:DefaultRelease time:2015-10-11Views:130

Hi Experts, I have developed one XML report which output type is EXCEL in Oracle Application. I am getting some -ve value in the report so I need to do the trailing sign Menace for example I got a value -8645 I need to display the value like (8645).[More]

XML Publisher to Excel Report : Date format problem

Category:DefaultRelease time:2015-10-11Views:130

Hi, I am trying to create an Excel report with XML Publisher. I have an issue with the Date Fomatting. In the XML template, I have set the "Date" column in date format. But the excel output report "Date" column returns as "General[More]

XML Publisher Report EXCEL output Huge stored as Web Pages

Category:DefaultRelease time:2015-10-11Views:130

Hello I have a XML Publisher Report which generates EXCEL output and the output file size is huge. What I notice that it is stored as Web Pages *.htm; *.html (Save as Type) in Excel this is the reason it is huge. If I save as Microsoft Office Excel W[More]

XML Publisher report default output in Excel format.

Category:DefaultRelease time:2015-10-11Views:130

Hi, We have defined one concurrent program whose output format is text, this concurrent program executable is PL/SQL and in this PL/SQL program we are generating XML data and displaying XML using below fnd_request. l_conc_id := FND_REQUEST.SUBMIT_REQ[More]

XML Publisher report in EBS - Parameter Form Problem

Category:DefaultRelease time:2015-10-11Views:130

Hi, XML Publisher is a very powerful tool for report developing. In EBS, we have some efficient issue for showing the parameter form when submit a concurrent program. If the report is D2K Report or PL/SQL script, when submit a request, it almost show[More]

Output shown blank when we run report in xml publisher using excel template

Category:DefaultRelease time:2015-10-11Views:130

Hi, 1) We have a requirement where we need to run report to shown 100 columns. Since Microsoft word supports only 63 columns. So we are building the report template in Excel. 2) When I run the report in Excel locally I get the output. But when I upla[More]

XML Publisher - OPP log: Output file was found but is zero sized - Deleted

Category:DefaultRelease time:2015-10-11Views:130

Hi, I have created one Main template and sub-template is called from it. I am working with Oracle Apps version 12.1.1. XML Source file gets created using rdf file attached to the concurrent program. Now after registering main template with the requir[More]

Hot
Bom dia, Onde trabalho o GRC já envia os XML´s para as empresas cujos emails estao cadastrados. Porém no corpo do email, preciso que seja incluída a msg abaixo. Gostaria de alguma dica de como fazer isso. Grato, Roberto Prezado cliente, Você está rec [More]
Hello All, Currently I am trying to create a SOAP web service within a HCP Java application to allow backend systems to consume data stored in HCP. This is the planned scenario: 1. Create data in HCP - therefor I am using JPA and a oData Model. 2. Ba [More]
I have a Mid-2011, 21.5" iMac running Yosemite v10.10.1.  I upgraded from 4 to 8 GB of RAM about a year ago, but I don't think that's an issue with this problem. I can no longer download movie or tv show purchases from the iTunes Store to iTunes v12. [More]
So we are testing out a 3rd party backup and recovery tool. The testing for individual pages and list items went pretty well. However, we are seeing really odd behavior when attempting to recover the sites. Obviously we will be working with the vendo [More]
Hi., Iam unable to get the media from the Endeca Experience Manager for my endeca app 'CRS'. I have created the endeca app named 'CRS' using the reference app discover-data-catalog-integration and successfully initialized and indexed.Iam able to see [More]
I am trying to write a query to understand whether we have a purchase price variation from the latest invoice to the second latest invoice. I am having a problem gaining the information for the second purchase invoice as SAP Query generator seems to [More]
Hello, we are facing ORA-00054 error when loading Oracle table using BO Data services (Oracle 10g database, BODS Xi 3.2 SP3) Test Job performs 1- truncate table 2- load table (tested in standard and bulk load modes) Scenario when issue happens is: 1- [More]
Under the print and fax preferences the 4V is visible in default and appletalk. However, when I try to add it the operation to connect "timed out". I've chosen "auto select" and the 4V driver under the print using dialog. It seems obvi [More]
Hi, In CRM system we had created on BP and replicated to ECC system. Replication was done successfully. In ECC now we had modified some of the details like Name, Address, contact details. From this updated details only address is not getting replicat [More]
Dear all , Please guide me how to add few user defined fields in the output list of standard VL06 transaction code - (Delivery Monitor Report - WS_DELIVERY_MONITOR) - I have to add in the option of 'List Outbound deliveries' - Pls revert. Thanks in A [More]