Thursday, October 18, 2007

XML Publisher in R12
Oracle XML Publisher is a new Java-based product available within the technology stack of Oracle E-Business Suite. Utilizing a set of familiar desktop tools such as Adobe Acrobat and Microsoft Word, users can create and maintain their own report formats based on development delivered XML data extracts. Oracle XML Publisher then converts these documents to the XSL-FO format. Users can also obtain third party provided PDF forms, such as government tax forms, and merge XML data generated from Oracle E-Business Suite to fill the forms with the required data.
The new features are:
Oracle XML Publisher now supports data generation. The Oracle XML Publisher data engine enables you to rapidly generate any kind of XML data structure against one or multiple databases in a scalable, efficient manner. The data template is an XML document that you construct to communicate your request for data to the data engine. The data engine can be called to execute the data template using the Concurrent Manager or an API. The data engine supports schema generation, flexfields, single and multiple data queries, distributed queries against multiple databases, query links, parameters, multiple data groups, aggregate functions, and event triggers. The data engine can also generate a default RTF template.
The Oracle XML Publisher Template Manager now allows you to define a template as "translatable." When you define a template as translatable, Oracle XML Publisher extracts the translatable strings. You can then export the strings into an XLIFF (.xlf) file. This XLIFF file can then be sent to a translation provider, or using a text editor, you can enter the translation for each string. Upload the translated XLIFF file back to the Template Manager to make the translated template available at runtime.
The Template Builder for Word and the Template Viewer are two desktop tools that increase your productivity using Oracle XML Publisher. The Template Builder is tightly integrated with Microsoft Word to automate many RTF template design tasks. It allows you to:
Insert data fields, tables, forms, and charts
Browse and update the content of form fields
Extract boilerplate text into an XLIFF translation file and test translations
The Template Viewer is a Java application that facilitates the rapid development of templates by providing advanced preview capabilities.
The XML Publisher Administrator responsibility now provides an administration interface. Using this interface you can set configuration properties, define font mappings, upload font files, and define currency formats. You can configure the behavior of Oracle XML Publisher at the site level, data definition level, and template level. Previously the properties available through this feature were configurable only through the Oracle XML Publisher configuration file, and only at the server level. For customers who have already configured their systems using the xdo.cfg file, a command line utility is available to migrate their existing settings to the database.
Upload Font Files and Create Font Mappings
You can now upload fonts through the administration interface to make them available to Oracle XML Publisher at runtime. You can also create font mappings to map fonts used in your template to other fonts to be published in PDF output. The mapping can be defined at the site level, the template level, or the data definition level.
Define Currency Formats
This feature allows you to map a number format mask to a specific currency so that your reports can display multiple currencies with their own corresponding formatting.
Graphics Support
Drawing/shape support: Users can now use Microsoft Word’s native support for predefined drawing objects and custom drawings. In addition, they can manipulate shapes by stretching, compressing, skewing, and repeating them in the final output based on XML data or parameters. This behavior can also be applied to composite shapes in the template.
Background/watermark support: The native MS Word functionality to add backgrounds and watermarks, text or images is now supported.
SVG image support: Users can now embed SVG images directly in the template.
SVG chart output support: Charts generated in the template are now converted to the SVG format. This conversion improves both the chart image and supporting labels for the chart.
Hyperlink support for shapes: You can add a hyperlink to a shape to enable users to click the image in the document and link to an internal or external destination. The link can be static or dynamically determined at runtime.

Conditional Formatting
If construct: Rather than requiring the normal xsl:if statement, Oracle XML Publisher now supports the more familiar “if … then … else” construct.
Fixed-row enumeration: Users can now specify a fixed number of rows for a table regardless of the amount of data coming into the template at runtime.
Currency formatting: Numeric values can now be formatted according to their associated currency code.
Data Manipulation with an RTF Template Brought Forward/Carry Forward page totals: Used frequently in financial reporting, this feature allows you to calculate the page total for a given field, display it at the bottom of the page to be carried forward, and then display it at the top of the subsequent page as the brought forward total. Updateable variables: Updateable variables differ from standard XSL variables in that they are updateable during the template application to the XML data. This functionality allows you to create many new features in your templates that require updateable variables, such as a running total.
Parameters: You can now declare parameters in your template and pass values at runtime.
Batch Processing Enhancements This release provides better support for batch processing based on RTF templates by providing support for the following new features:
Restart page numbering for section breaks: For example, if generating invoices for multiple customers, you can now restart the page numbering for each new invoice.
Reset header and footer: Similarly, if header and footer data are being supplied from the data (such as customer name), they can be reset for each new invoice.
Number and Date Formatting You can now use the Oracle number and date format masks to control the display of numbers and dates. The Oracle masks ensure that at runtime the appropriate locale-specific formatting is used. The Microsoft native formatting masks are also supported.PDF Bookmark Support
Oracle XML Publisher can now generate the bookmark links that display in the PDF navigation pane. These links can either be static bookmarks or dynamic and based on the incoming data stream.Support for Variable Page Layouts Within a Report Odd and even header and footer support: You can now define different headers and footers for odd and even pages in your output.

Last-page-only content support: You can specify the layout and content of the last page of the report. This feature is useful for documents such as checks, invoices or purchase orders in which content such as the check or a summary must appear in a specific place only on the last page. Truncate Table Data You can now choose to truncate data in a table cell that is too big for the cell. Previously all data was wrapped.Multicolumn Pages Microsoft Word’s native multicolumn page function is now supported. Initial Page Number You can now define the page number from which you want the first page of a report to begin.Check Boxes You can now include a check box in your template that you define to display as checked or unchecked based on a value from the incoming data.
The printing of large documents, such as those that are thousands of pages long, is problematic in Oracle E-Business Suite using regular printing functionality. This release provides the ability to split an incoming document into multiple print jobs that can be directed to the printer or printers, enabling load balancing across a set of printers.
Previous releases of Oracle XML Publisher provided the ability to generate Electronic Funds Transfer (EFT) formats using an RTF template to communicate payment requests to a financial institution in an electronic format. This release builds on that functionality providing several enhancements. In addition, Oracle XML Publisher now has the ability to accept a remittance message from the financial institution in the electronic format and to generate XML data from the message for the calling application to update its reconciliation tables.
This release delivers the ability to create merged PDF documents from multiple subdocuments based on a command file
Table of contents: The table of contents can span multiple documents.
Bookmarks: This feature is the Adobe interpretation of bookmarks, that is, the links that appear on the left side of the document when opened in Adobe client software.

Master header/footer layouts: These layouts can support portrait and landscape page formats in the same document.

Section and master page numbering: Users can implement page numbering across the complete master document, or across a section made up of multiple subdocuments and numbering on the base documents.
Hyperlinks: The control file allows the user to build a set of cross-referencing hyperlinks within the master document and across multiple separate documents.
Preamble/postscript text: The user can add text prior to or after the insertion of a subdocument into the master document.
These features allow the user to build composite documents from subdocuments in a fast, scalable fashion.

No comments: