| Subject: |
All about XML Publisher |
| |
Doc ID: |
Note: 278727.1 |
Type: |
Howto |
| |
Last revision date: |
24-Mar-2006 |
Status: |
Moderated |
The information in this article applies:
Oracle Application Object Library-version: 11.5.1 to 11.5.10
Information in this document applies to any platform.
XML Publisher 4.5
Release 11i10
Scope & Application
The intended audience is MERs, Oracle consultants, and/or 3rd party partners with basic system administration knowledge who are implementing Oracle XML Publisher For the versions less than 11.5.10.
This document contains the installation, usage and issues with XML Publisher 4.5 only. As your more functionalities have been added into this product, the scope is restricted to 4.5 version only.
Summary:1. What is XML publisher2. why XML Publisher and what are the advantages of XML Publisher? 3. installation4. How-To5. Trouble shooting6. Resources Please click here to download the document in pdf format. Introduction:1. What is XML Publisher?Oracle XML Publisher (xdo in short) provides end users with a template-based, easy-to-use publishing solution. it is based on standard, well-known technologies and tools so your users can take advantage of it easily. it will free development from maintaining report layouts and allow you to concentrate on what you know best... data. your users will then have a set of familiar tools such as Adobe D Microsoft Word/EXCEL to create and maintain their own report formats based on your data extracts. users will then be able to send the report outputs to destinations of choice, email, fax, printers and others. go Top 2. why XML Publisher and what are the advantages of XML Publisher? In simple words, for easy generation of reports. the following are the advantages of XML Publisher:. main advantage is data separation and presentation. b. rapid development of report C. cost generation ction D. control over report layout and high customization E. different presentation tools. f. output in the format of one's choice. Go top 3. Installing XML Publisher 4.5Question:From which version of applications, can XML Publisher be installed? From 11.5.1 to 11.5.9 (I. E ., any 11i) instance, we can install XML Publisher. but it is evident that they wocould be brought up to latest stack with the pre-requisites being applied (for example: OA framework is one of the pre-requisites of xdo. so, you might need to apply all the latest patches of OA framework ).XML Publisher is already ded in release 11.5.10. Please follow these steps for versions less than 11.5.10.
1)Apply the patch3412795(AD splice patch for xdo ).
Ensure that the product is spliced correctly or else you will have errors after you apply the patch like you will not be able to see the appropriate responsibility etc 2) apply core xdo patch
3554612This patch wocould give the XML Publisher Core Engine Code. 3) apply OA xdo patch
3554613This patch gives the OA pages for uploading the templates and data definitions, XML Publisher administrator responsibility and XML report publisher concurrent program.
4) apply xdo documentation patch
3623558Documentation patch for XML Publisher 4.5.
This is an optional patch.
Go Top 4. How-to 4.1)
Ways to generate XML data:N generate/Write a valid XML file manuallyn generate a valid XML file from xml dom tree using xdkn parse an incoming file as XML file using xdk n generate a valid XML file from a Java string n generate a valid XML file from character-based Oracle datatype (varchar2, char, clob and others) through JDBC n generate a valid XML file from binary-based Oracle datatype (BLOB) through JDBC n generate a valid XML file from Oracle XML query (Java) N generate a valid XML file from dbms_xmlgen (PLSQL) n generate a valid XML file from sys_xmlgen (SQL) n generate a valid XML file from dbms_xmlquery (PLSQL) N using Oracle Reports 6i the current release in EBS, there is a white paper on this on our site 4.2)
How to get the XML Publisher runner (desktop version )?We are coming up with a licensed version of the runner for MERs to use. 4.3)
How to generate portrait, landscape and Landwide reports?One of the advantages of XML Publisher is separating the data from presentation. so, create a template with the respective styles and run the concurrent program. that will give the report in the specified style. 4.4)
Where will be the output file created?If you are using our concurrent program to generate the PDF, then it will go into the appl_out directory I. E ., concurrent manager will handle the files. if you are using APIs, then it is up to you where the output goes. 4.5)
Is there any way to get debug information?Yes !!! Set the af_log_xxx Profile options to 'yes' and we get the debug information. this is the OA framework logging method nothing specific to xdo you can generate lower level xdo logs by following these steps: 6)
How can we verify the installation of XML Publisher is successful?There are two ways to check this: 1. check the table fnd_product_installation for the status.2. we can use fnd_installation.get_app_info () to get the information. if 'status' is 'I, then it is successful else not successful. 7)
How to know the version of XML Publisher?Check the properties of a generated PDF document wocould give the version of XML Publisher. currently this is the only way to know the version. go top
5. trouble-shooting this section is divided into following 3 sections. Each of the section has the error, cause and the fix to the error.5.1) Installation issues5.2) Formatting errors5.3) Others
5.1. Installation issues:1)
Error: Main tablespace xdod not found or index tablespace xdof not found while splicing this product.
Cause: This is not specific only to xdo but is a general error when any product is being spliced. this is caused when the specific tablespace is not created. I did not test this after oatm is done. this error is caused without oatm. generally, product specific patches will create the tablespaces and the indexes.
Fix: Create the tablespace and index. For instructions, please follow the Note: 270131.1 2)
Error: 'Xml publisher administrator 'responsibility cocould not be found.
Cause: Core xdo patch is not applied properly.
Fix: Please apply the core xdo patch again. 3)
Error: After successfully applying all the patches and accessing the XML pub admin responsibility causes the following error:
-Unable to execute function (function_id = 1010946) or
-Unable to execute function. (resp_id = 21267/resp_appl_id = 603)
Cause: This error is not specific to xdo product. This is OA framework error. This error is caused when the menus get invalidate.
Fix: Please follow the Note: 275942.1 for this. Go top
5.2) formatting errors5.2.1)
Error
: While launching the XML Publisher runner, I get the following errors:
Invalid argument Error
Cocould not load file/URL specified: C:/Documents and Settings/ppvj/Local Settings/Temporary Internet Files/>
(Or)
Couldnotloadargumentexception [cocould not load file/URL specified: C:/Documents and Settings/ppvj/Local Settings/Temporary Internet Files/content. ie5/6ben2xmz/index [1]. JNLP] at com. sun. javaws. main. main (unknown source)
(Or)
Java. io. filenotfoundexception: C:/Documents and Settings/ppvj/Local Settings/Temporary Internet Files/content. ie5/6ben2xmz/index [1]. JNLP (the system cannot find the file specified) at java. io. fileinputstream. open (native method) at java. io. fileinputstream. <init> (unknown source) at java. io. fileinputstream. <init> (unknown source) at com. sun. javaws. JNL. launchdescfactory. builddescriptor (unknown source) at com. sun. javaws. main. main (unknown source)
Cause:
This error occurs when you have not set up the Java Runtime Environment correctly.
Fix 1:We have a page to help http://xdo.us.oracle.com/webstart/xdorunner/index.html
Fix 2: Other reason cocould be if javaws.exe is not found on the client machine. check if this is there and that you can start Java Web Start properly without any error. java console wocould help in getting the error. 5.2.2)
Error:
When generating PDF from RTF containing foreign characters like Arabic or Hebrew using XML Publisher, strange characters like ???? Are shown instead of them.
Fix:XML pub 4.5 patch installa set of variable width fonts. please copy the files from $ fnd_top/resources to/lib/fonts directory on all web and concurrent nodes. the font files are: albanywt. TTF-"single-byte" characters only albanwtj. TTF-Unicode font with Japanese Han ideographs albanwtk. TTF-Unicode font with Korean Han ideographs albanwts. TTF-Unicode font with simplified Chinese Han ideographs albanwtt. TTF-Unicode font with Traditional Chinese Han ideographs 5.2.3)
Error:
When trying to generate a PDF file, following error is generated:
Java. Lang. noclassdeffounderror: Java/SQL/blob
At oracle. SQL. sqlutil. makedatum (sqlutil. Java: 682)
At oracle. JDBC. Driver. scrollableresultset. getcacheddatumvalueat (scrollableresultset. Java: 2636)
At oracle. JDBC. Driver. scrollableresultset. getoracleobject (scrollableresultset. Java: 659)
At oracle. JDBC. Driver. scrollableresultset. getblob (scrollableresultset. Java: 1619)
At oracle. Apps. xdo. OA. schema. server. templateinputstream. initstream (templateinputstream. Java: 223)
At oracle. Apps. xdo. OA. schema. server. xdolobsinputstream. <init> (xdolobsinputstream. Java: 62)
At oracle. Apps. xdo. OA. schema. server. templateinputstream. <init> (templateinputstream. Java: 85)
& O. OA. schema. server. templatehelper. gettemplatefile (templatehelper. Java: 511)
At oracle. Apps. xdo. OA. schema. server. templatehelper. processtemplate (templatehelper. Java: 986)
At oracle. Apps. xdo. OA. CP. jcp4xmlpublisher. runprogram (jcp4xmlpublisher. Java: 352)
ATCP. Request. Run. Main (execute. Java: 125)
Cause
: Blob. Class is not available in the classpath. Sure That JDK/lib directory or SRC. jar in JDK directory is listed in classpath and af_classpath. go top
5.3) Others: 5.3.1)
Can we use XML Publisher for other applications running on a Oracle database or only with the eBusiness suite?Currently we are supporting only those mers who use API for eBusiness suite. However, there are plans to support for other products like IAS and database in future. 5.3.2)
To receive the output, we have to submit report in two steps:
Run Report to receive XML output and then run XML report publisher with Request ID from previous run to receive the PDF output. How to avoid this?We cannot currently do it from the concurrent Manager interface using the XML report publisher program. in next releases of xdo, development is planning to release an integrated version of the request submission form, probably shortly after the release of 11i10. this will mean a single step for users for report submission through SRS. 5.3.3)
Do we have any limit on the size of the XML files or template files and if not any size limits tions, will there be any performance impact?No, we don't have any size limit on the XML files or the template files. but for the performance, there wocould be performance impact because the data has to be merged for each record. this purely depends on the how much size the data is. 5.3.4)
How do we print PDF reports after generating from XML Publisher?1. from local printer when PDF viewer is spawned or document opened in client system using Acrobat reader.2. print from applications directly. this requires pasta to be setup. please follow pastas 3.2 Guide for setting this. 5.3.5)
Is bidi supported ages supported in 4.5? If so, when Arabic PDF template is created, headers will be from right-to-left, will the contents be right-to-left as well?Yes for both. 5.3.6)
From which version is the XML Publisher certified?11.5.1 onwards you can apply XML Publisher. However, applying xdo patches will bring you to approximately 11.5.7 baseline. 5.3.7)
Do we need separate licensing for XML Publisher?No !! XML Publisher is a part of applications techstack. So, need of separate licensing. go top 6. Resources XML: www.
XML.Orgwww.w3schools.com/
XML/Default. asp effecfo: http://www.w3schools.com/xslfo/default.aspwww.xslfo.info XSL: http://www.w3.org/TR/xsl/ iPP/IFP: http://www.ietf.org/html.charters/ipp-charter.html xliff: http://www.i18ngurus.com/docs/996845895.htmlhttp://www.sdl.com/products-home/products/products-ref-center/products-ref-center-white-papers/products-ref-center-white-papers-xliff.htm
To install XML Publisher into an 11.5.9 instance the following are the patches (in the order applied on our internal instance ):
- 3242200 ad Post H publish lidated patch 12/01
- 3412795 adsplice patch for xdo
- 3110802 interoperability views definition for contingent workers
- 3125496 add in all odfs required for new table upgrades for HR/chloroform merge
- 2690553 fndscaus: Modifications required for contingent workers
- 2563148 AOL/fndload rollup patch E
- 3325651 CCM node only (pasta printing patch ).
- 3554613 Oracle XML Publisher OA release 4.5.0
