BI Publisher (MOSC)

MOSC Banner

Etext Template

edited Nov 10, 2011 10:04AM in BI Publisher (MOSC) 7 commentsAnswered
I am working on a Delimiter based ETEXT Template.
Is there a way you can have 2 repeating fields on the same line that belong to 2 different levels in the hierarchy?  I can't figure out how to set this up in the Etext RTF template. 
In the example below  CheckNumber,VendorNo and CheckAmount are from the OutboundPayment level
and Invoicenum and InvoiceAmt is from DocumentPayable level.

Sample XML Data format:


 <OutboundPayment>
   <CheckNumber>1</CheckNumber>
   <VendorNo>123</VendorNo>
   <CheckAmount>1000</CheckAmount>
   -<DocumentPayable>
     <Invoicenum>Inv1</Invoicenum>
     <InvoiceAmt>600</InvoiceAmt>
    </DocumentPayable>
   -<DocumentPayable>
     <Invoicenum>Inv2</Invoicenum>
     <InvoiceAmt>400</InvoiceAmt>
    </DocumentPayable>
 </OutboundPayment>

CheckNumber_1|VendorNo|CheckAmount|Invoice_Num1|Invoice_Num1_Amt

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center