User’s Guide Release 11i - Oracle Help Center

1 Oracle XML PublisherUser s GuideRelease 11iPart No. B13817-01 August 2004 Oracle XML Publisher user s Guide , Release 11iPart No. B13817-01 Copyright 2004, Oracle . All rights Author: Leslie StuddardContributor: Nancy Chung, Tim Dexter, Incheol Kang, EdwardJiangThe Programs (which include both the software and documentation) contain proprietary information; theyare provided under a license agreement containing restrictions on use and disclosure and are also protectedby copyright, patent, and other intellectual and industrial property laws. Reverse engineering, disassembly,or decompilation of the Programs, except to the extent required to obtain interoperability with otherindependently created software or as specified by law, is information contained in this document is subject to change without notice. If you find any problemsin the documentation, please report them to us in writing. This document is not warranted to be as may be expressly permitted in your license agreement for these Programs, no part of these Programsmay be reproduced or transmitted in any form or by any means, electronic or mechanical, for any the Programs are delivered to the United States Government or anyone licensing or using the Programs onbehalf of the United States Government, the following notice is GOVERNMENT RIGHTS Programs, software, databases, and related documentation and technical datadelivered to Government customers are "commercial computer software" or "commercial technical data"pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations.

2 Assuch, use, duplication, disclosure, modification, and adaptation of thePrograms, including documentation andtechnical data, shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement,and, to the extent applicable, the additional rights set forth in FAR , Commercial ComputerSoftware--Restricted Rights (June 1987). Oracle Corporation, 500 Oracle Parkway, Redwood City, CA Programs are not intended for use in any nuclear, aviation, mass transit, medical, or other inherentlydangerous applications. It shall be the licensee's responsibility to take all appropriate fail-safe, backup,redundancy and other measures to ensure the safe use of such applications if the Programs are used for suchpurposes, and we disclaim liability for any damages caused by such use of the Programs may provide links to Web sites and access to content, products, and services from third is not responsible for the availability of, or any content provided on, third-party Web sites.

3 You bearall risks associated with the use of such content. If you choose to purchase any products or services froma third party, the relationship is directly between you and the third party. Oracle is not responsible for: (a)the quality of third-party products or services; or (b) fulfilling any of the terms of the agreement with thethird party, including delivery of products or services andwarranty obligations related to purchased productsor services. Oracle is not responsible for any loss or damageof any sort that you may incur from dealingwith any third is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks oftheir respective Us Your CommentsPreface1 XML Publisher IntroductionIntroduction.. 1-1 Process Overview.. 1-22 Creating an RTF TemplateIntroduction.. 2-1 Supported Modes.. 2-1 Prerequisites.. 2-2 Overview of Creating an RTF Template.. 2-2 Associatingthe XML Data to the Template Layout.

4 2-2 Designing the Template Layout.. 2-5 Adding Markup to the Template Layout.. 2-6 Creating Placeholders.. 2-6 Defining Groups.. 2-9 Defining Headers and Footers..2-13 Including Images..2-14 Supported Native Formatting Features..2-15 Special Features..2-16 Dynamic Data Columns..2-19 Data Reporting Features..2-22 Advanced Design Options..2-25 Using XSL Elements..2-25 Using FO Elements..2-26 Best Practices..2-27 Using Tables..2-273 Creating a PDF TemplatePDF Template Overview.. 3-1 Supported Modes.. 3-2 Designing the Layout.. 3-2iiiAdding Markup to the Template Layout.. 3-4 Creating a Placeholder.. 3-5 Defining Groups of Repeating Fields.. 3-7 Performing Calculations.. 3-8 Completed PDF Template.. 3-9 Runtime Behavior.. 3-9 Creating a Template from a Downloaded PDF..3-104 Using the Template ManagerIntroduction.. 4-1 Creating the Data Definition.. 4-1 Viewing/Updating a Data Definition.

5 4-3 Creating the Template.. 4-3 Copying a Template.. 4-5 Viewing/Updating a Template.. 4-5 Updating the Template General Definitions.. 4-6 Previewing a Template.. 4-6 Editing the Template Layout.. 4-7 Adding Templates for Additional Languages.. 4-7 Mapping PDF Template Fields.. 4-75 Generating Your Customized ReportUsing the Concurrent Manager to Generate Your Report.. 5-16 XML Publisher Extended FunctionsExtended SQL Functions.. 6-1 XSL Equivalents.. 6-4 Using FO Elements.. 6-6 IndexivSend Us Your CommentsOracle XML Publisher user s Guide , Release 11iPart No. B13817-01 Oracle welcomes your comments and suggestions on the quality and usefulness of this publication. Yourinput is an important part of the information used for revision. Did you find any errors? Is the information clearly presented? Do you need more information? If so, where? Are the examples correct? Do you need more examples?

6 What features did you like most about this manual?If you find any errors or have any other suggestions for improvement, please indicate the title and partnumber of the documentation and the chapter, section, and page number (if available). You can sendcomments to us in the following ways: Electronic mail: FAX: 650-506-7200 Attn: Oracle Applications Technology Group Documentation Manager Postal service: Oracle Applications Technology Group Documentation ManagerOracle Corporation500 Oracle ParkwayRedwood Shores, CA 94065 USAIf you would like a reply, please give your name, address, telephone number, and electronic mail address(optional).If you have problems with the software, please contact your local Oracle Support AudienceWelcome to Release 11iof the Oracle XML Publisher user s manual is intended to instruct users on how to use OracleXML Publisher to createcustomized reports out of the Oracle E-Business Guide assumes you have a working knowledge of the following: The principles and customary practices of your business area.

7 Standard request submission in Oracle Applications. The Oracle E-Business Suite user learn more about standard request submission and the Oracle E-Business Suitegraphical user interfaces, read theOracle Applications user s you have never used Oracle Applications, Oracle suggestsyou attend one or more ofthe Oracle Applications training classes available through Oracle Related Documents on page viii for more Oracle Applications product AccessibilityOur goal is to make Oracle products, services, and supporting documentation accessible,with good usability, to the disabled community. To that end,our documentationincludes features that make information available to usersof assistive technology. Thisdocumentation is available in HTML format, and contains markup to facilitate accessby the disabled community. Standards will continue to evolve over time, and Oracle isactively engaged with other market-leading technology vendors to address technicalobstacles so that our documentation can be accessible to allof our customers.

8 Foradditional information, visit the Oracle Accessibility Program Web site of Code Examples in DocumentationJAWS, a Windows screen reader, may not always correctly read the code examples inthis document. The conventions for writing code require that closing braces shouldappear on an otherwise empty line; however, JAWS may not always read a line of textthat consists solely of a bracket or of Links to External Web Sites in DocumentationThis documentation may contain links to Web sites of other companies or organizationsthat Oracle does not own or control. Oracle neither evaluates nor makes anyrepresentations regarding the accessibility of these Web XML Publisher Introduction2 Creating an RTF Template3 Creating a PDF Template4 Using the Template Manager5 Generating Your Customized Report6 XML Publisher Extended FunctionsRelated DocumentsOnline DocumentationAll Oracle Applications documentation is available online(HTML or PDF).

9 PDF Documentation- See the Online Documentation CD for current PDFdocumentation for your product with each Release . This Documentation CD is alsoavailable on OracleMetaLinkand is updated frequently. Online Help- You can refer to Oracle Applications Help for current HTML onlinehelp for your product. Oracle provides patchable online help, which you can applyto your system for updated implementation and end user documentation. Nosystem downtime is required to apply online help. Release Content Document- See the Release Content Document for descriptions ofnew features available by Release . The Release Content Document is available onOracleMetaLink. About document- Refer to the About document for information about yourrelease, including feature updates, installation information, and new documentationor documentation patches that you can download. The About document is availableon GuidesOracle Applications shares business and setup informationwith other OracleApplications products.

10 Therefore, you may want to refer to other guides when you setup and use Oracle can read the guides online by choosing Library from the expandable menu on yourHTML help window, by reading from the Oracle Applications Document Library CDincluded in your media pack, or by using a Web browser with a URL that your systemadministrator you require printed guides, you can purchase them from theOracle Store Related to this ProductOracle Applications user s GuideviiiThis Guide explains how to enter data, query, run reports, and navigate using thegraphical user interface (GUI). This Guide also includes information on setting userprofiles, as well as running and reviewing reports and concurrent Applications System Administrator s GuideThis Guide provides planning and reference information forthe Oracle ApplicationsSystem Administrator. It contains information on how to define security and users, setreport output definitions, and manage concurrent processing.