Questions tagged [oracle-xml-publisher]

Oracle XML Publisher is a template-based publishing solution delivered with the Oracle E-Business Suite.

Oracle XML Publisher is a template-based publishing solution delivered with the Oracle E-Business Suite.

It provides a new approach to report design and publishing by integrating familiar desktop word processing tools with existing E-Business Suite data reporting.

At runtime, XML Publisher merges the custom templates with the concurrent request data extracts to generate output in PDF, HTML, RTF, EXCEL (HTML), or even TEXT for use with EFT and EDI transmissions

33 questions
9
votes
1 answer

How to print escaped HTML characters in Oracle XML Publisher

I am using Oracle's XML Publisher (based on Oracle XML Parser 10.1.0.5.0) to generate reports from my db using an .RTF template. In my front end the user enters some values in a CK Editor like the following image: In the database the values are…
MaVRoSCy
  • 17,747
  • 15
  • 82
  • 125
3
votes
1 answer

HTML tags are getting converted

I have the following code snippet to have output from XML data which is stored in the database table ServletOutputStream os = response.getOutputStream(); String contentDisposition =…
Jacob
  • 14,463
  • 65
  • 207
  • 320
1
vote
1 answer

ORA-31061: XDB error: special char to escaped char conversion failed

I'm completely new to Oracle's XDB, trying to breakfix a code in production environment which i am completely new to. SELECT DBMS_LOB.SubStr(RTRIM (XMLAGG (XMLELEMENT (E,XMLATTRIBUTES (ntx.nttx_str || '|' AS "Seg")) ORDER BY ntx.ref_id,…
1
vote
1 answer

How can use an ORACLS EBS xmlreport parameters from a package-body?

I have recently created a report using Oracle E-business suite, a XML publisher report. In that report I have added 4 parameters and I need to use those parameters from a package body which is a custom request these are the parameters in my xml…
1
vote
1 answer

How can I convert parameter input date to YYYYWW format and use it in SQLStatement section in XML publisher?

I have created an xml file as data definition template for my xml publisher. The data template has two parameters which are date( startdate,enddate). But this input dates should be converted to YYYYWW format so that in my SQLstatement I can use the…
ssik
  • 31
  • 2
1
vote
2 answers

BI Publisher - ignore section - based on info from XML input data

I have the following scenario: I'm developing a rtf report in BIP desktop 11 containing 3 sections: intro, content, ending. Based on xml input data, each section may generate one or multiple pages. Because each section has it's own unique header and…
1
vote
1 answer

XML Publisher Parameter Date Formatting

In XML Publisher template, how can I format the date parameter to DD-Mon-YYYY format? Start Date - With the…
Jacob
  • 14,463
  • 65
  • 207
  • 320
0
votes
0 answers

BI PUBLISHER RTF template COLUMN TRIM ISSUE

I have some issue RTF templete in a column. column have length 3 in the backend but when i took output IN excel sheet it shows length 5. i have used and but not working. Is there any solution in sql query or in xml code? Thanks.
0
votes
0 answers

Printing rows in a table for RTF using XML Publisher

I have a requirement where I need to print table records as shown in image (two tables - column M, N, O, P, Q for reference). Where record should print from left side of table then continue to print on right side of table . I need to use oracle XML…
Abhijit
  • 13
  • 10
0
votes
0 answers

RTF Template to get rows to columns

31 531 322623279 305634180
SSA_Tech124
  • 577
  • 1
  • 9
  • 25
0
votes
1 answer

How to Apply if else conditioning with HTML2FO tag in RTF Template BI Publisher

My Requirement is to display any particular text eg: 'XYZ' based on the RTF Field UE_GEN_DETAILEDDESCRTF, when UE_GEN_DETAILEDDESCRTF is not null its should display 'XYZ'. here UE_GEN_DETAILEDDESCRTF return some HTML values, to get the actual value…
0
votes
0 answers

Dynamic header in Oracle Bi Publisher rtf template

In my report I have two for-each and each one must have a static text as a header. I try this solution: `
0
votes
1 answer

Total sum not working inside the for-each-group tag in BI Publisher when using Group Left

I have the following template I am trying to upload- This is giving me an output like - This should come like - How can i change the RTF template to get the desired output ?
0
votes
1 answer

BI Publisher - Display Image using the URL in RTF

I am using Word 2019 to create RTF Templates for BI Publisher I have a table ITEM_IMAGE that has a column IMAGE_URL that contains the URL of the image on the internet I need to display the Image using the URL that is there on the field How can I do…
Imran Hemani
  • 599
  • 3
  • 12
  • 27
0
votes
1 answer

Total sum not working inside the for-each-group tag in BI Publisher

I have the following template I am trying to upload- This is giving me an output like - This should come like - How can i change the RTF template to get the desired output ?
SSA_Tech124
  • 577
  • 1
  • 9
  • 25
1
2 3