Stack Overflow
Stack Overflow

Questions tagged [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

34 questions
0
votes
1 answer

wrong date format in bi reports oracle

I have the following date which is in varchar2(11) column in database: select valid_untill from SALES_ORDERS_V where header_id = 7999410; 30-May-2016 Using rtf template and xml source, the report output (PDF) is: 4950-11-19 04:45:49:0 I don't…
Muhammad Nadeem
  • 368
  • 4
  • 7
  • 21
0
votes
1 answer

can I reference sql out put as parameter in 2nd query in xml publisher

I need to reference the sql data of one query as parameter value in 2nd query. for example: select order_no, order_date, customer from orders; select payment_no, payment_date, amount from payments where order_no = [:order_no]; is this possible in…
Muhammad Nadeem
  • 23
  • 1
  • 10
-1
votes
1 answer

unable to get the function value from procedure call?

I've made a package in which one procedure is defined to call the function and one function is written to return varchar2 value but i'm unable to do that not sure about the reason on why i'm not able to do. more over the function return value i.e…
NerdFredrick
  • 71
  • 4
-6
votes
1 answer

where clause with date range give strange result

In an xml publisher report I have the following where clause: where NVL(:P_ORDER_NUMBER, xx.order_number) = xx.order_number and xx.ordered_date between NVL(TRUNC(fnd_date.canonical_to_date(:P_FROM_DATE)), xx.ORDERED_DATE) and…
Muhammad Nadeem
  • 23
  • 1
  • 10
1 2
3