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.


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. Cheers, Chen

Posted by Chen Hu on February 23, 2007 at 10:06 AM MST #

Hi Chen

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


Posted by Tim Dexter on February 27, 2007 at 03:26 AM MST #

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? Derik

Posted by Derik on February 05, 2009 at 02:13 AM MST #

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. gBala

Posted by gBala on November 05, 2009 at 05:46 AM MST #

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. Thanks! Stephen Manning

Posted by Stephen Manning on June 18, 2010 at 06:59 AM MDT #

Thanks for this post

Posted by kläder on August 18, 2010 at 05:18 AM MDT #

I love the R12 templates! Thanks for letting me know!

Posted by Mendel Potok on September 16, 2010 at 03:07 AM MDT #

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


Posted by guest on December 03, 2011 at 12:31 PM MST #

Post a Comment:
  • HTML Syntax: NOT allowed

Follow bipublisher on Twitter Find Us on Facebook BI Publisher Youtube ChannelDiscussion Forum

Join our BI Publisher community to get the most and keep updated with the latest news, How-to, Solutions! Share your feedback and let us hear your voice @bipublisher on Twitter, on our official Facebook page, and Youtube!


« June 2016