This discussion is archived
4 Replies Latest reply: Aug 1, 2011 8:16 AM by DaveHarrison RSS

R42520 Pick Slip XML format

870668 Newbie
Currently Being Moderated
Hi

I need to have a BI template for Pick Slip R42520 report. I generated XML for the same. But the structuring of the XML is an issue:
XML format is like below:

-Root
--PS1/Line1
---PS1/HeaderInfo
--PS1/Line2
--PS1/Line3
--PS2/Line1
---PS2/HeaderInfo
--PS2/Line2
--PS2/Line3
...

I have a BI template, which requires first header to be printed (Pick Slip number, Order Number) and then the detail lines to be printed for an order. When a new pick slip number is triggered, it should trigger a page break and print details for next order.
Please advise.

Regards,
Priya
  • 1. Re: R42520 Pick Slip XML format
    Bruno Condemi Explorer
    Currently Being Moderated
    Hi,
    you can resequence the xml structure throug the template; refear to the bip guide of your current release.

    Regards

    Bruno Condemi.
  • 2. Re: R42520 Pick Slip XML format
    870668 Newbie
    Currently Being Moderated
    Hi

    As I could not generate the BI template with the XML given by Pick Slip. I modified the code a little. I stored the 'Pick Slip Number' from 'Header Custom Section' and displayed it in 'Pick Slip Detail Lines' section.
    Then in the RTF file, kept a 'for-each' group (Page Break) on 'Pick Slips Detail Lines' Section and regrouped on new RV Pick Slip. For the detail lines, a 'for-each loop on 'Current-group' is kept.
    This way I could group the data depending on the pick slip number.
    But Now i want to print all these on pre-printed stationary. the problem arises, as my Order Total footer section fluctuates depending on the number of rows printed.
    I studied the article given on link 'http://blogs.oracle.com/xmlpublisher/entry/anatomy_of_a_template_i_fixed#comment-1239058164000', but as here my Parent-Child elements are not properly defined, I dont get the expected result.

    Has any body worked on Pick Slip BI Template requirement?

    Regards,
    Priya
  • 3. Re: R42520 Pick Slip XML format
    870668 Newbie
    Currently Being Moderated
    [http://www.4shared.com/document/U0t87Ove/RT_US_EN_PickSlip_R5542520_-_C.html] [http://www.4shared.com/document/uP7xlJCO/R5542520_TMP0002_D110727_T0756.html] HI All

    I have modified Pick Slip Report R42520 and have displayed 'Pick Slip Number' retrieved in 'Header Custom Section' in 'Pick Slip Detail Lines'.
    and then for RTF I did re grouping on 'PickSlipDetaiLines/PickSlipNumber'.

    Now its running fine for orders having less no of lines. But it gives blank pages when the line are more.. ie. more than 15 or 20.

    I am sharing the XML and RTF document.

    Please advise.

    Regards,
    Priya
  • 4. Re: R42520 Pick Slip XML format
    DaveHarrison Newbie
    Currently Being Moderated
    Hi Priya

    The table row containing the product details is being treated as belonging to the table header. Select all the table rows from the top down to and including the detail row, and deselect the 'Repeat as header row at the top of each page' checkbox in the row properties. Then re-select from the top down to and including the column headers, but not the detail row, and then enable 'Repeat as header row at the top of each page'.

    Regards,
    Dave

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points