BI Publisher (MOSC)

MOSC Banner

How to get data from a higher level on the output

edited Aug 24, 2012 4:20AM in BI Publisher (MOSC) 2 commentsAnswered ✓
I am using Oracle e-Business Suite 12.1.3.  In Payables, I am trying to generate a CSV file containing payment information.  This is a standard process that generates XML and expects an eText template.  I created a BI Publisher template with a TEMPLATE TYPE of DELIMITER_BASED.  The problem I am having now is that the data that I need to put on the CSV file doesn’t all exist at the same level in the XML data.  My XML looks something like this:

<OutboundPayment>

  <PaymentNumber>

    <PaymentReferenceNumber>37614</PaymentReferenceNumber>

  </PaymentNumber>

  <PaymentDate>2012-08-23</PaymentDate>

  <Payee>

    <Name>VWR INTERNATIONAL</Name>

  </Payee>

  <DocumentPayable>

    <DocumentNumber>

      <ReferenceNumber>mjmcsv3-1</ReferenceNumber>

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