An Oracle blog about BI Publisher

EBS R12 templates are here ... enjoy!

When it comes down to it, XMLP is a great reporting tool inside the E Business Suite but the greatest value is that offered by the products that use it and provide enhanced reporting functionality to their users. 11i10 got the ball rolling with the HRMS, Purchasing, Contracts, Advanced Collections and other teams moving some of their reporting functionality over to XMLP. In the case of Advanced Collections they jumped in a the deep end and based all of their reporting on XMLP including document delivery.

With the release of R12 you are going to see many more products taking advantage of the reporting gains XMLP offers them and ultimately you. The new Payments team are standardizing on a single extract and then providing you EFT formats (EText templates), Check formats (RTF Templates), the Global Finanacials teams have reduced the number of extracts they have and are shipping you layouts. But the most obvious thing to notice is the number of out of the box templates now available, roughly 870 templates across 60 or so teams means that there is a high chance the product as now developed the template you are interested in. So it should be a simple case of getting their template, copying it, customizing it and then deploying it - done.

I have generated a list of templates by product then by concurrent program available here. These are the templates shipping with the baseline R12 release. There is also a project going on to migrate the remainder of the Oracle Reports based concurrent programs to the XMLP platform, slated for release later this year you'll have more than 2000 templates available ... having met many of you and discussed the canned reports you either use none of them or very few and those you have to customize ... hopefully with this many templates available life will become easier for you.

What of your own custom reports, how can you migrate those? Well in R12 there are a set of libraries to help you move your Oracle Reports to a data template (extract) plus a layout template (RTF) ... the libraries are being used internally to convert the canned reports so they have been put through their paces ... more on this in another future post.

Hey, Im an 11i customer what do I get?
Well one of the carrots to come to R12 is the better reporting and the number of templates available. There are tentative plans to build a Template Bank on metalink to allow you to download development delivered templates, hopefully consulting templates and even other customer templates ... this is all still on the drawing board but a distinct possibility. With the 5.6.3 release, coming soon, you also get the migration libraries to help you move your own Oracle Reports. Of course if you can find a friendly R12 customer and do some template negociation and you're off to the races, hey we'll have an gray market in template swapping before you know it.

Join the discussion

Comments ( 8 )
  • Chen Hu Friday, February 23, 2007
    Hi Tim,
    I find it is more convenient for me to use your publisher as a standalone. If I can create a thing like that testing bed, it will be perfect. All this is because the publisher, in the way the testing bed was established, becomes a handy desktop tool, and I don't have to rely on Oracle Applications to generate a report.
    The steps to load the template, generate the XSL, and then run the publishing request are clumsy.
    Using the publisher directly, manually pick a data file and occasionally re-generating the XSL are fine, and intuitive to users.
    Just a point from me.
  • Tim Dexter Tuesday, February 27, 2007

    Hi Chen

    Loooong time no speak. Fair point on the development process and we are looking to streamline that going forward.


  • Derik Thursday, February 5, 2009
    Hi Tim,
    Is there an update on this project? We are reviewing R12 (12.0.4) and I did not notice any major increase in the number of templates. Is there a specific patch we need to install to get all these with R12?
  • gBala Thursday, November 5, 2009
    Tim -I want to see if you can help me with some design issue here using XMLP. I have a 8.5*14 paper layout for AP checks that's divided into four sections. The first section prints the remittance info [invoices etc] followed by the non negotiable check, followed by the same set of invoices that was printed in the remittance followed by the real check.
    I know for sure i can fit about 16-17 invoices per remittance section.
    Example: With 16-17 Invoices i would have just one page of document where the first section prints 17 invoices followed by the non negotiable info, again the same 17 invoices followed by the real check.
    The other scenario is I have more than 17 invoices. In this case, I want the system to print the 1-17 invoices in the first page, followed by the non negotiable info [we can print this one either in the first or last page], Again the 1-17 invoices gets printed followed by the real check. The next page starts with invoice 18-34 invoices and goes on.
    We are in R12.1.1
    I appreciate for all your help.
  • Stephen Manning Friday, June 18, 2010
    Hi Tim,
    Is there an updated list/catalog of all BI Publisher reports like the one mentioned here. I ask because it's over three years old now and I know there are several additional BIP based reports in 12.1.2 and I can't find an equivalent of R12Templates.pdf anywhere on Metalink.
    Stephen Manning
  • kläder Wednesday, August 18, 2010
    Thanks for this post
  • Mendel Potok Thursday, September 16, 2010
    I love the R12 templates! Thanks for letting me know!
  • guest Saturday, December 3, 2011

    Tim - May be am missing something here, but i could't find R12 templates. Can you please help me out to navigate them.


Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.