Unknown BI Publisher Templates for JD Edwards – PART 2

An XSL template is Extensible Style Sheet Language, and refers to a family of languages used to transform and render XML documents. JD Edwards embedded BI Publisher has an XSL processor in its core, so it makes sense to have this functionality available. In Part 2 of our short series on ‘Unknown’ BI Publisher Templates for JD Edwards, Senior Consultant Raul Pena covers the functionality of XSL templates, and how they support developers in BI Publisher.

XSL Template Functionality

In Part 1 of our short series, we discussed multiple templates that Oracle rarely uses, causing them to remain unknown to BI Publishers. Today we will be covering the topic of XSL Templates, what they do, and how to use them correctly.

So what exactly are XSL Templates used for? XSL Templates serve the main purpose of transforming an existing XML in to another XML. Sound strange? Well, the XML generated by JD Edwards when you add a report definition is based on the layout of the report, which works if you want to use tags similar to an RFT template to produce a better looking PDF.

But what if you need to send this somewhere that requires a specific XML format, like a bank or supplier? You can achieve this by creating a custom report, or by cloning an existing one. Once you have done this, you can add the code to create the file in any format you choose. If you have all the information you need in a report, all you need to do is re-arrange it into the desired format in this template. Let’s take a look at a sample.

Unlike E-text Templates, you will not find a sample of this in the BI Publisher desktop installation folder. We will reference a localization XSL template for SEPA payments as a sample. See below:

XSL Template

This is what an XSL Template looks like when pulled up in your system. As you can see, the template type is TS, which means XSL Template. Try looking for a ‘TS Template’ in your system. As I mentioned before, you probably don’t have one as most of these are localized. You may need to read more about XSL to fully understand this concept.

XSL Formatting

See the image below for a visual example of how XSL should be formatted:

XSL Template

To be able to run the transformation, you will need a source file using the template viewer, just like with the E-text Templates. The output of this formatting will look something like the second image below:

XSL Templates

Take Away

As mentioned in Part 1 of our short series, these templates are very powerful tools if used correctly. We’ve explored the various capabilities of E-text Templates, XSL Templates, and the XML output capabilities of each. Acquiring these “unknown” tools and gaining more experience with them can significantly aid in the efficiency of your BI Publisher skills set.

Ready to Strengthen your BI Publisher Expertise?

Get more information on our BI Publisher training options at Smartbridge. Our experts are ready to help you take your skill set to the next level.

BI Publisher Training
By |2018-08-29T14:08:09+00:00August 20, 2018|Categories: ERP / JD Edwards|

Receive more posts just like this, right in your inbox!

↓ Sign up for emails with the latest from Smartbridge.

Sign up for emails
Or add this feed URL to your favorite blog reader.