An Oracle blog about BI Publisher

AR Print Statements ... XMLP'ed

I have been scouring blogs over the last few daze and came across a post from Gareth that I missed in my last recce. Gareth is a regular contributor to the XMLP/BIP blog collective, focusing on EBS integration among other subjects. He comes up with some nuggets of gold that I hope he does not mind me sharing with folks - more pearls of BIP wisdom from the real Middle Earth a.k.a New Zealand here.
Those of you that had been struggling with getting XMLP based formatting for check printing are now in better shape with an AP patch for 11i 4303528 - I wrote about that here. This time, Gareth has come up with a neat approach to another thorny problem in EBS - AR Statements.

Getting XMLP templates applied to 'Print Statements' in AR is painful at best - its a combination of spawned 'C' and Oracle Reports. For those of you still struggling, nothing official yet, but Gareth has a solution that is not too invasive or custom.

Check it out and get it implemented here http://garethroberts.blogspot.com/2008/01/beautiful-statements-in-1-easy-step.html

Thanks Gareth!

Join the discussion

Comments ( 6 )
  • Frank Smith Monday, August 25, 2008
    I will like to know if you print flyers with the following specs i have provided below.
    1. Measures 8 1/2 ' x 11'
    2. 100# Gloss Text or Aqueous Coating
    3. 1 Sided.
    4. Provide quote on 80,000 Copies.
    Frank Smith
  • Tim Monday, August 25, 2008
    Hi Frank
    You can do. We are not a printing service - more a tool to allow you to print documents.
  • ramsay Tuesday, September 16, 2008
    hi tim,
    would just like to comment on this solution from gareth on AR Print Statements...it works like a charm!
    i've created a rtf statement template,pdf output.now id like to display the buckets,which is in a table, on only the last page if there's more than one page.and on the first if there's only one.do you know how?i've tried the tag ?start@last-page:body??end body? after a ?ctrl-enter? page break, but it keeps bomming.and then i also want to display it in the footer of the last page,but thats not too serious.any help on other ways i can try and do this ?
  • Mahesh Thursday, July 9, 2009
    Hi Tim,
    Is it possible to Customize AR Statements in R12 , it's quite different from older version using Data template , can you post the approach in this case if possible.
    Best Regards,
  • Rob Saturday, October 11, 2014

    Hi Tim,

    My company want to display customer po# on the customer statement.

    WHats the easiest way to achieve it? Do I need to customize the ARXSGPO.rdf? Is that the only option ?


  • guest Monday, October 20, 2014

    Hi Rob

    That PO number needs to be in the data somewhere or passed as a parameter so that the layout template can 'see' it and then render it. If the data source for the document is that rdf, then your only option would be to customize it.


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